Excel Function : PEARSON

Download now!

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.