next up previous contents index
Next: COS Up: A Function Reference Previous: COLS

CORR

 

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:

displaymath16000

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


next up previous contents index
Next: COS Up: A Function Reference Previous: COLS

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999