Excel Function : PEARSON
Returns the Pearson product moment correlation coefficient
Microsoft Excel Reference Page
Syntax and Description of the PEARSON Excel Function
The syntax for the PEARSON function in Microsoft Excel is: =PEARSON(array1, array2) where array1 and array2 are the two data sets for which you want to calculate the correlation coefficient.
About PEARSON Excel Function
The PEARSON function returns the Pearson product moment correlation coefficient, R, a dimensionless index that ranges from -1.0 to 1.0 inclusive.