[R] Different Estimated values between R and Excel
Komine
momadou at yahoo.fr
Tue Aug 23 13:48:18 CEST 2011
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 estimated values from the R software, the results seem bad,
however the results of Exel seem correct.
Do you know why I have different estimated values between the R software and
EXCEL?
I give below a sample of data:
Thank you in advance
var1 var2
0,11 264,6
0,01 226,7
0,05 168,1
-0,03 144,9
-0,07 108,1
0 118,22
-0,09 85,6
-0,07 103
-0,05 89,6
-0,06 92,8
-0,11 64,9
-0,11 33
-0,08 32,5
-0,12 42,3
-0,14 36,7
--
View this message in context: http://r.789695.n4.nabble.com/Different-Estimated-values-between-R-and-Excel-tp3762508p3762508.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list