Excel CORREL Function

Use:

Computes correlation coefficient (i.e., R) between two variables

Syntax:

CORREL( x-range , y-range )

Example:

Cell E4 formula:     CORREL( B2:B9 , C2:C9 )

 

Notes:

The order of the X and Y data is not important. CORREL( B2:B9 , C2:C9 ) yields the same value as CORREL( C2:C9 , B2:B9 ).

Related Functions:

COVAR, RSQ, INTERCEPT, SLOPE