Hi everyone... I'm running a simple linear regression in excel that needs to have an intercept of 0. Thus, I ran the regression through Tools / Data Analysis and checked the "Constant is Zero" box. However, I also ran the regression line by plotting the points in a scatterplot, adding a trendline, checking "Set intercept = 0" and displaying equation and R square....
The problem is that the equations (really just slopes) are the same but the R squares are completely different. Does anyone have a clue why this could be or which one would be correct? I have always expected them to match (I did the same example except did not set intercept equal to 0 and they were equal). I have checked my inputs several times, and everything appears correct....
Any Clues to this difference in R squares????? Thanks!
Edit: I have Excel 2003... I have read that there is a known glitch before 2003 but it should be correct in the 2003 version....
The problem is that the equations (really just slopes) are the same but the R squares are completely different. Does anyone have a clue why this could be or which one would be correct? I have always expected them to match (I did the same example except did not set intercept equal to 0 and they were equal). I have checked my inputs several times, and everything appears correct....
Any Clues to this difference in R squares????? Thanks!
Edit: I have Excel 2003... I have read that there is a known glitch before 2003 but it should be correct in the 2003 version....
Last edited:
