We are studying forcasting :The homework question is : The second part of the qu

Question

We are studying forcasting :The homework question is :

The second part of the question is develop a casual regression model to forcast demand that includes both time and the introduction of the new chip as explanatory varibles. Help Please!

Microprocessor Data Demand Month New Chip Introduced 3949 1 0 3544 2 0 6138 3 0 7752 4 0 10700 5 1 7766 6 0 5482 7 0 8789 8 0 13103 9 1 7326 10 0 8669 11 0 7219 12 0 7456 13 0 9744 14 0 14561 15 1 8564 16 0 12214 17 0 19020 18 1 14751 19 0 14269 20 0 14896 21 0 15359 22 0 16527 23 0 17029 24 0

Explanation / Answer

The Regression model is

y=a+bx1+cx2

where demand is independent varaibles and x1,x2 are independent variables.

From excel

The fitted Model is y=3097.18 + 535.57 x1 + 4955.86 x2

SUMMARY OUTPUT Regression Statistics Multiple R 0.944266829 R Square 0.891639844 Adjusted R Square 0.881319829 Standard Error 1513.459395 Observations 24 ANOVA df SS MS F Regression 2 395804463.8 1.98E+08 86.39909 Residual 21 48101746.12 2290559 Total 23 443906210 Coefficients Standard Error t Stat P-value Intercept 3097.183006 658.7938872 4.701293 0.000122 Month 535.5705134 44.68196631 11.98628 7.44E-11 New Chip Introduced 4955.863462 829.9306893 5.971418 6.31E-06

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.