The CORREL function calculates the correlation coefficient between two sets of data.
The function arguments should contain numbers or refer to ranges containing numbers, and should have matching numbers of data points. The correlation coefficient is a number between -1 and 1. The formula used is:
For example, the correlation coefficient between the height (array1) and weight (array2) of six people, can be calculated using the formula:
CORREL({1.52, 1.75, 1.96, 1.85, 1.55, 1.30}, {170, 167, 210, 182, 154, 100})
This returns a correlation coefficient of 0.918156, which indicates high correlation.
Low correlation tends towards 0, as can be seen when array1 and array2 contain many data points filled with random numbers.
See also: