Re: [R] Different Estimated values between R and Excel

On Aug 23, 2011, at 7:48 AM, Komine wrote: Hi, I used simple linear regression with the R software and EXCEL on the same data. Although , I find the same R2=0.84, I find different estimated values (intercept and slope). For the R software (slope =0.0009, Intercept = -0.1478), for EXCEL (sl

Re: [R] Different Estimated values between R and Excel

Thanks, I see the problem. R did the opposite of Excel. I invert the position of variables in my code and the result is now correct. -- View this message in context: http://r.789695.n4.nabble.com/Different-Estimated-values-between-R-and-Excel-tp3762508p3762870.html Sent from the R help mailing

Re: [R] Different Estimated values between R and Excel

I you had posted your code which gave the results, we would have seen that you switched your variables. Bart -- View this message in context: http://r.789695.n4.nabble.com/Different-Estimated-values-between-R-and-Excel-tp3762508p3762738.html Sent from the R help mailing list archive at Nabble.co

[R] Different Estimated values between R and Excel

Hi, I used simple linear regression with the R software and EXCEL on the same data. Although , I find the same R2=0.84, I find different estimated values (intercept and slope). For the R software (slope =0.0009, Intercept = -0.1478), for EXCEL (slope =927.7, Intercept = 154,41). When I use the e