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