The CORRELATION function calculates the correlation between two input data series. It measures the strength of the relationship between the two series. The resulting correlation value ranges between -1 and 1. A correlation value of zero implies that the two series are independent and have no relationship. A correlation value that is close to 1 implies that the two series are positively correlated. Similarly, a correlation value that is close to -1 implies that the two series are negatively correlated. If the correlation value is negative, this means that when the first input is large, the second input is small (and vice-versa).
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.