PEARSON


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.







 
Created with Zapof