CORREL

CORREL(array1, array2)

Returns the correlation coefficient between two data sets.

array1	The first array.
array2	The second optional array.

REMARKS

* Returns the Pearson Correlation Coefficient
* The "array1" and "array2" must be numbers, or names, arrays, or references that contain numbers.
* If either array contains any zero values, these are included.
* If either array contains text, logical values, or empty cells, those values are ignored.
* If either array has a different number of data points, then #N/A is returned.
* If either "array1" or "array2" is empty, then #DIV/0! is returned.
* If the standard deviation of the two arrays is zero, then #DIV/0 is returned.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=CORREL({1, 2}, {1, 2}) = 1	1
2	=CORREL({1, 2, 3}, {1, 2, 3}) = 1	2
3	=CORREL(B1:B2, B3:B4) = 1	3
4	=CORREL({1, 2, 3, 4, 5}, {1, 3, 5, 7, 0}) = 0.110	4
5	=CORREL({3, 2, 4, 5, 6}, {9, 7, 12, 15, 17}) = 0.997
6	=CORREL({3, 2, FALSE, 4, 5, 6}, {9, 7, 12, 15, 17}) = #N/A
7	=CORREL({3, 2, "some text", 4, 5, 6}, {9, 7, 12, 15, 17}) = #N/A
8	=CORREL({0, 1, 2}, {1, 2}) = #N/A
9	=CORREL({1, 2}, {1, 2, 3, 4}) = #N/A