Question

Q4 A and B

Year 1 1 2 3 4 5.2 Q4. The following data show the quarterly sales of Amazing Graphics, Inc. for the years 1 through 3. Quarter Time Period (0) Sales (1000s) 4.8 2 4.1 3 6.0 4 6.5 2 5 5.8 2 6 2 3 7 6.8 2 4 8 7.4 9 6.0 3 2 10 5.6 3 3 11 7.5 3 4 12 8.8 From the above data, it could be concluded that both quarterly seasonal effects and linear trend in the sales pattern are present. A time series model was considered for this question and the estimated regression equation from Minitab is found as follows: Vr(Sales) = 4.52 - 0.77 Quarter_2 +0.83 Quarter_3 +1.42 Quarter_4 + 0.2 t, التي 1

Answer 1

Sol:

Given Data

The regression equation is:

Y(Sales) 10.52+2.8*Quarter2-3.5*Quarter3+0.4*Quarter4 +0.2*t

(a).

Find the estimated sales for the first quarter for the next year

Sales = 10.52 + 2.8 * 0 - 3.5 * 0 + 0.4 * 0 + 0.2*13

Sales = 13.12

(b) .

Find the estimated sales for the fourth quarter for the next year

Sales = 10.52 +  2.8 * 0 - 3.5 * 0 + 0.4 * 1 + 0.2*16

Sales = 14.12

If you Satisfy with Answer, Please give me "Thumb Up". It is very useful for me.
Thank you for your support.