CORREL(array1, array2)

Returns the correlation coefficient between two data sets.

array1The first array.
array2The 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

 AB
1=CORREL({1,2},{1,2}) = 11
2=CORREL({1,2,3},{1,2,3}) = 12
3=CORREL(B1:B2,B3:B4) = 13
4=CORREL({1,2,3,4,5},{1,3,5,7,0}) = 0.1104
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 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top