Fin Fang Foom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 598
Hi everyone me again.
Does anyone have any examples how to a multiple regression with formulas?
I'm very new to this stuff and I'm learning. Right now I'm using a Data Analysis tool for regression. This what I did to get the multiple regression.
1. Click on "Tools" then "Data analysis" then choose regression
2. Click on Y range icon - input (highlight) the Y range (dependent variable) - hit "Enter"
3. Click on X range icon - input (highlight) the X range (4 independent variables) - hit "Enter"
4. Check the Labels box (make sure you have included the top labels row in the input ranges)
5. Under "output options" check "New Workshhet Ply"
6. check the "Residuals" box
Hopefully I did that right. But my boss would like me to make template with formulas. Take a look at the example below in cells D4:D8 I did some research and I came up with those formulas but its not comming out the same as the Summary Ouput results. Or are they? I just dont know.
Does anyone knows if they are? Also does anyone knows how to do this with formulas?
Does anyone have any examples how to a multiple regression with formulas?
I'm very new to this stuff and I'm learning. Right now I'm using a Data Analysis tool for regression. This what I did to get the multiple regression.
1. Click on "Tools" then "Data analysis" then choose regression
2. Click on Y range icon - input (highlight) the Y range (dependent variable) - hit "Enter"
3. Click on X range icon - input (highlight) the X range (4 independent variables) - hit "Enter"
4. Check the Labels box (make sure you have included the top labels row in the input ranges)
5. Under "output options" check "New Workshhet Ply"
6. check the "Residuals" box
Hopefully I did that right. But my boss would like me to make template with formulas. Take a look at the example below in cells D4:D8 I did some research and I came up with those formulas but its not comming out the same as the Summary Ouput results. Or are they? I just dont know.
Does anyone knows if they are? Also does anyone knows how to do this with formulas?
| Alfredo2.xls | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | SUMMARY OUTPUT | ||||||||||
| 2 | |||||||||||
| 3 | Regression Statistics | ||||||||||
| 4 | Multiple R | 0.970477245 | 0.917106137 | ||||||||
| 5 | R Square | 0.941826083 | 0.841083666 | ||||||||
| 6 | Adjusted R Square | 0.929578943 | 0.826636727 | ||||||||
| 7 | Standard Error | 0.088765731 | 0.140515269 | ||||||||
| 8 | Observations | 24 | 24 | ||||||||
| 9 | |||||||||||
| 10 | ANOVA | ||||||||||
| 11 | df | SS | MS | F | Significance F | ||||||
| 12 | Regression | 4 | 2.423744 | 0.605935897 | 76.90171 | 1.83E-11 | |||||
| 13 | Residual | 19 | 0.149708 | 0.007879355 | |||||||
| 14 | Total | 23 | 2.573451 | ||||||||
| 15 | |||||||||||
| 16 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| 17 | Intercept | 0.53730577 | 0.03273 | 16.41641689 | 1.11E-12 | 0.468802 | 0.60581 | 0.468802 | 0.60581 | ||
| 18 | 0 | 0.056358131 | 0.018668 | 3.018922886 | 0.007059 | 0.017285 | 0.095431 | 0.017285 | 0.095431 | ||
| 19 | 0 | 0.036454347 | 0.011576 | 3.149047596 | 0.005284 | 0.012225 | 0.060684 | 0.012225 | 0.060684 | ||
| 20 | 0 | 0.022872332 | 0.00343 | 6.668276197 | 2.24E-06 | 0.015693 | 0.030051 | 0.015693 | 0.030051 | ||
| 21 | 0 | 0.005432485 | 0.003014 | 1.802495018 | 0.087354 | -0.00088 | 0.011741 | -0.00088 | 0.011741 | ||
Sheet1 | |||||||||||
