Year Quarter Sales 1 1 6 2 15 3 10 4 4 2 1 10 2 18 3 15 4 7 3 1 14 2 26 3 23 4 1
ID: 3265100 • Letter: Y
Question
Year Quarter Sales 1 1 6 2 15 3 10 4 4 2 1 10 2 18 3 15 4 7 3 1 14 2 26 3 23 4 12 4 1 19 2 28 3 25 4 18 5 1 22 2 34 3 28 4 21 6 1 24 2 36 3 30 4 20 7 1 28 2 40 3 35 4 27 Question 3.(17.43, p.864) Hudson Marine is an authorized dealer for C&D; marine radios. Quarterly sales of radios (in number of units) are given in the file HudsonMarine.xlsx. Develop an estimated regression equation estimate the seasonal and linear trend effects. Use number of period And Qtr1. Qtr2 and Qtr3 as the predictor variables, where Qtr1 = 1 if the observation is from the first quarter and 0 otherwise, Qrt2 =1 if second quarter and 0 otherwise, and Qtt3 = 1 if third quarter, 0 otherwise. Compute the quarterly forecasts for next year. Compute centered (four-point) moving averages for this time series. a. b. c.Explanation / Answer
y =0.035714286+0.970982143*t+4.91296429*Q1+14.51339286*Q2+9.113839286*Q3
Quarterly Forecast using regression
SUMMARY OUTPUT Regression Statistics Multiple R 0.987612601 R Square 0.97537865 Adjusted R Square 0.971096676 Standard Error 1.617907359 Observations 28 ANOVA df SS MS F Significance F Regression 4 2385.044643 596.261161 227.7871496 3.86408E-18 Residual 23 60.20535714 2.61762422 Total 27 2445.25 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.035714286 0.86480786 0.04129736 0.967415242 -1.753277076 1.824706 -1.75328 1.824706 t 0.970982143 0.038219469 25.4054326 2.48328E-18 0.891919148 1.050045 0.891919 1.050045 Q1 4.912946429 0.872375599 5.63168713 9.87386E-06 3.108300007 6.717593 3.1083 6.717593 Q2 14.51339286 0.868179444 16.7170427 2.31371E-14 12.71742684 16.30936 12.71743 16.30936 Q3 9.113839286 0.865651987 10.5282948 2.86884E-10 7.323101714 10.90458 7.323102 10.90458Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.