I'm trying to understand a correl function that is on a spreadsheet that I inherited. It has the following function: =CORREL(A2:A6,B2:B6)^2 and the answer returns 0.547511 but if I remove the ^2 the answer returns -0.73994. I could be wrong but I'm thinking the ^2 is meaning to raise to the second power....why would they put that in the formula or is my meaning wrong? Thanks in advance for any explaination.
The CORREL function returns the correlation coefficient (r) which is a measure of covariance of x,y divided by the std dev of x times the std dev of y. It can vary from -1.0 to +1.0. r squared is the coefficient of determination (which is what was in the spreadsheet you received) is a considered a direct measurement of the fit of the points to the fit (line) proposed. Yes, the ^2 in the formula means raised to the second power.
ChemistB
Last edited by ChemistB; 04-24-2008 at 09:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks