Question: For the time series data presented in Table 9.10 calculate seasonal forecasts using the simple seasonal additive exponential smoothing model. If we plot the time

For the time series data presented in Table 9.10 calculate seasonal forecasts using the simple seasonal additive exponential smoothing model.

Quarter 1 2 3 4 Table 9.10 1 17.15 19.87 20.53 20.78 2 16.80 15.87 17.13 18.11 3 13.85 19.67 20.29 20.94 Year

If we plot the time series as illustrated in Figure 9.44 we note that we have a definite pattern in the shape of the curve, which repeats over the same time period quarters.

This suggests a seasonal module would be appropriate.

Series value 30.00- 25.00- 20.00- 15.00- 10.00- 5.00- 0.00- 3 5 7 Time series plot Series 9 11 13 15 17 19 21

Quarter 1 2 3 4 Table 9.10 1 17.15 19.87 20.53 20.78 2 16.80 15.87 17.13 18.11 3 13.85 19.67 20.29 20.94 Year 16.99 18.96 24.84 23.11 5 21.12 21.03 24.55 25.90 6 17.35 17.57 18.19 21.66

Step by Step Solution

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Figure 945 illustrates the Excel solution Excel solution ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!