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:

**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

Grey Trout Software

02 March 2003