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 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.
The Correlation function requires the following parameters:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
The Correlation function generates the following outputs:
- Correlation - A single value representing the correlation between the two sets of input values.