This function returns the correlation coefficient of the two sets of data.
CORREL(array1,array2)
The two arrays of data in the arguments of this function should meet these criteria:
Accepts arrays of numeric data for both arguments. Returns numeric data.
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