B bpatrick Dec 11, 2005 #1 Does anyone know the exact Excel formula that gives Rsquared ? I have R-squared formulas that give different answers than Excel gives. Thanks.
Does anyone know the exact Excel formula that gives Rsquared ? I have R-squared formulas that give different answers than Excel gives. Thanks.
B bpatrick Dec 11, 2005 #3 I'm actually looking for the complete formula. I've already done the rsq(a1:a5,b1:b5)
L late apex Dec 11, 2005 #4 If you go to Help - Contents and Index, then look up RSQ under the Index tab, it'll give you the exact formula.
If you go to Help - Contents and Index, then look up RSQ under the Index tab, it'll give you the exact formula.
B bpatrick Dec 11, 2005 #5 Thanks Late Apex. I have that formula but maybe I'm doing something wrong. I'll have to check. Thanks.
Thanks Late Apex. I have that formula but maybe I'm doing something wrong. I'll have to check. Thanks.
