Returns the Pearson correlation coefficient of two sets of data.
Syntax:
CORREL(x, y)
where x and y are ranges or arrays containing the two sets of data.
Any text or empty entries are ignored.
CORREL calculates:
where are the averages of x, y.
Example:
CORREL(A1:A30, B1:B30)
returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.