R help - Jan 2010 - Linear regression - R^2

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

	[[alternative HTML version deleted]]

Dear Csanad,

PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
Reproducible code/problem are welcome.
By the way, who you believe is right?

bests

milton
On Sat, Jan 9, 2010 at 5:40 PM, Csanád Bertók
<bertok.csanad@gmail.com>wrote:
> 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
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
>
http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]