This function returns the correlation coefficient of the two sets of data.
Syntax
CORREL(array1,array2)
Arguments
The two arrays of data in the arguments of this function should meet these criteria:
- The data should contain numbers, names, ranges, or references that are numeric. If some cells do not contain numeric data, they are ignored.
- The arrays should be the same size, with the same number of data points.
- The arrays should not be empty, nor should the standard deviation of their values equal zero.
Data Types
Accepts arrays of numeric data for both arguments. Returns numeric data.
Examples
CORREL(C1:C10,D1:D10)
CORREL(R1C3:R10C3,R1C4:R10C4)
CORREL({5,10,15,20,25},{4,8,16,32,64}) gives the result 0.9332565253
CORREL({73000,45000,40360},{42,70,40}) gives the result -0.3261046660
Version Available
This function is available in product version 1.0 or later.