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
* For the Google documentation refer to support.google.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