# 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