Correlation
The CORRELATION function calculates the correlation, or the strength of the relationship between two input data series.
The resulting correlation value ranges between -1 and 1, where a value close to -1 indicates a negative correlation, a value close to 1 indicates a positive correlation, and a value close to zero indicates no correlation. A negative correlation means that when the first input is large, the second input is small (and vice-versa) whereas a positive correlation means the both input values become larger and smaller at the same time.
The CORRELATIONGROUP function calculates the correlation, or the strength of the relationship between two input data series as values ranging between -1 and 1, where the input values are grouped by the specified hierarchies.
1. Syntax
Correlation:
CORRELATION(d0,d1,Alignments...)
Correlation group:
CORRELATIONGROUP(d0,d1,Alignments...)
2. Input
The Correlation function requires the following input series:
- d0: First Input data values - The first set of data values for which the Correlation is calculated.
- d1: Second Input data values - The second set of data values for which the Correlation is calculated.
3. Parameters
The Correlation function requires the following parameters:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
4. Output
The Correlation function generates the following outputs:
- Correlation - A single value representing the correlation between the two sets of input values.
The Correlation group function generates the following outputs:
- Correlation group - A single value representing the correlation between the two sets of input values.