Syntax: @CORR(R1, R2)
R1 = a range
R2 = a range
@CORR returns Pearson's product-moment correlation coefficient for the paired data in ranges R1 and R2. R1 and R2 must have the same dimensions. The result is between -1 and 1. @CORR can be used to determine whether pairs of data are statistically related. The closer the correlation is to zero, the less likely that they are related. The function is given by:
Examples:
@CORR(A1..A4, B1..B4) = 0.44213546, where A1..A4 = .5, .98, .22, .1, and B1..B4 = .87, .6, .21, .49.
@CORR(H5..H9, K5..K9) = 0.92384914, where H5..H9 = 14, 35, 37, 0, 33, and K5..K9 = 67, 77, 94, 34, 99.
@CORR(F1..F9, G1..G15) = Error - @CORR, ranges must be same dimensions