RCORRCOEFF returns the correlation coefficient (i.e. the goodness of fit) for the linear regression line through the X and Y Cell Range.

SYNTAX:

RCOFFCOEFF(X Cell Range,Y Cell Range)

X Cell Range: The cell range for the X-Axis data.

Y Cell Range: The cell range for the Y-Axis data

EXAMPLES:

=RCORRCOEFF(E9:E14,C9:C14)

 

See Also: RSLOPE, RINTERCEPT