Excel Function : PEARSON
Category
Statistical
Description
Returns the Pearson product moment correlation coefficient
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PEARSON-function-0c3e30fc-e5af-49c4-808a-3ef66e034c18
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.
