CORR(R1, R2)

 

Description

This function 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:

 

 

Parameters

 

R1

A range.

 

R2

A range.

 

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

Ranges must have the same dimensions.