Regression -- Constant is Zero-- Help

cww

New Member
Joined
Jan 16, 2009
Messages
4
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....
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top