next up previous contents index
Next: COS Up: A. Function Reference Previous: CONFIDENCE   Contents   Index


CORR, CORREL

Syntax: CORR(R1, R2)
  CORREL(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:

\begin{displaymath}
\frac{\sum_{i=1}^N (x_i-\overline{x})(y_i-\overline{y})}
{\...
...^2 \right)
\left( \sum_{i=1}^N (y_i-\overline{y})^2 \right)}}
\end{displaymath}

CORREL is a synonym for CORR.

Examples:

CORR(A1..A4, B1..B4) = 0.44213546, where A1..A4 = .5, .98, .22, .1, and B1..B4 = .87, .6, .21, .49.

CORREL(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

Excel function: CORREL


next up previous contents index
Next: COS Up: A. Function Reference Previous: CONFIDENCE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003