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 -- View this message in context: http://n4.nabble.com/R-2-in-linear-regression-tp1010473p1010473.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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 and provide commented, minimal, self-contained, reproducible code.