Skip to content
Prev 205877 / 398506 Next

R^2 in linear regression

Terias 
Hello,

I was doing a linear regression with the following formula:
lm(y~x+0), so it passes through the origin. But when I called the summary of
the regression i saw that R squared is abnormally high (it's a lot lower in
other programs such as SigmaPlot and MS Excel).The manual explained the
cause of the difference (because of the different computing method), but
what should I do to get the same R^2 in excel and R?

WITHOUT PASSING THROUGH THE ORIGIN:
R^2: Multiple R-squared: 0.9711,     Adjusted R-squared: 0.9654
In MS Excel: 0,9711

So it's OK.


WITH PASSING THROUGH THE ORIGIN:
Multiple R-squared: 0.9848,     Adjusted R-squared: 0.9822
In MS Excel: 0,8907

So almost 10% difference.

Thank you for your help.

Csanad Bertok, Hungary

Thread (3 messages)

Terias R^2 in linear regression Jan 9 Peter Dalgaard R^2 in linear regression Jan 9 Terias R^2 in linear regression Jan 9