# PEARSON

PEARSON(array1, array2)

Returns the pearson product moment correlation coefficient.

 array1 The first array of independent values. array2 The second array of dependent values.

 REMARKS
 * The pearson product moment correlation coefficient is a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.* The arguments must be either numbers or names, array constants, or references that contain numbers.* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.* If "array1" and "array2" are empty, then #N/A is returned.* If "array1" and "array2" have a different number of data points, then #N/A is returned.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =PEARSON({1,2,3,4},{5,6,7,8}) = 1 2 =PEARSON({1,2,3,4},{10,20,30,40}) = 1 3 =PEARSON({10,20,30,40},{5,6,7,8}) = 1 4 =PEARSON({1,2,3,4},{2,20,30,5}) = 0.187 5 =PEARSON({2,20,30,5},{1,2,3,4}) = 0.187 6 =PEARSON({"some text",2,3,4},{5,6,7,8}) = 1 7 =PEARSON({1,2,3,4},{""}) = #N/A 8 =PEARSON({10,20,30,40},{5,6,7,8,9,10}) = #N/A 9 =PEARSON({1,2,3,4},) = #VALUE! 10 =PEARSON("some text",{5,6,7,8}) = #N/A