Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Special Functions : RCORRCOEFF
Q10750 - INFO: RCORRCOEFF

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

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/12/2008 8:56 PM.
Last Modified on 6/2/2008 11:53 AM.
Last Modified by Scott Dorner.
Article has been viewed 2171 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article