Question: Hi, Can you help me with the estimated demand function to forecast the demand for SF Bread, company and the interpretation of ALL coefficient estimates?
Hi,
Can you help me with the estimated demand function to forecast the demand for SF Bread, company and the interpretation of ALL coefficient estimates?
| SUMMARY OUTPUT | ||||||||||
| Regression Statistics | ||||||||||
| Multiple R | 0.903092399 | |||||||||
| R Square | 0.81557588 | |||||||||
| Adjusted R Square | 0.786068021 | |||||||||
| Standard Error | 15631.83704 | |||||||||
| Observations | 30 | |||||||||
| ANOVA | ||||||||||
| df | SS | MS | F | Significance F | ||||||
| Regression | 4 | 27015107558 | 6753776889 | 27.63927659 | 7.44276E-09 | |||||
| Residual | 25 | 6108858229 | 244354329.2 | |||||||
| Total | 29 | 33123965787 | ||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| Intercept | 131614.4445 | 74055.78904 | 1.777233707 | 0.087699772 | -20906.30814 | 284135.197 | -20906.30814 | 284135.197 | ||
| Price (P) | -16712.96228 | 4282.784148 | -3.902359236 | 0.000636387 | -25533.52134 | -7892.40321 | -25533.52134 | -7892.40321 | ||
| Competitor Price (Px) | 16940.39581 | 3630.194899 | 4.666525154 | 8.8436E-05 | 9463.869461 | 24416.92216 | 9463.869461 | 24416.92216 | ||
| Advertising (Ad) | 0.17082099 | 0.096340319 | 1.773099703 | 0.088397565 | -0.02759561 | 0.369237591 | -0.02759561 | 0.369237591 | ||
| Income (I) | 8.582484853 | 1.063625112 | 8.069088215 | 2.00808E-08 | 6.39190793 | 10.77306178 | 6.39190793 | 10.77306178 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
