I am using Excel for plotting a trend line to my data. when the trend line is fitted it gives R square value that differs significantly from the R square calculated using regression in SPSS. Why is that so, and which R square shall I use?
I tried it in Excel 2007, 2010 and 2013, spss 15, 17, 21 and 22 and the same is obtained, beware of looking the adjusted R-squared
R square indicate Correlation coefficient . it must be same in excel or SPSS.
I use linear relation.
my data spreads over 19 years and for that i need trendline. the r2 fro trendline using excel is higher than one obtained by regression in spss.
Thanks all.
Mistake was on my part.
at one place i used year 1997-1998.............2007 etc on X axis and at other place I used only 1,2,3,4... etc. on x axis. that caused the difference.
Thanks.
- Badges
- Science topic