### 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.office.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