Consider the stylized example of Figure 7.3, in which there is a jump in the mean value.

Question:

Consider the stylized example of Figure 7.3, in which there is a jump in the mean value. Using the same worksheet as a template, enter the exponential smoothing calculations for these periods. Assume that S1 = 100.
FIGURE 7.3 Moving- Average Calculations in a Stylized Example
AI BIC Moving Average Example к 1 3 Period 4-week Moving Average Observed A(t) Forecast Error Deviation Percent 6-week

a. Take a = 0.2. Calculate the forecasts generated by exponential smoothing, and compute the values of MSE, MAD, and MAPE for periods 10-15.
b. Repeat the calculations in part (a) but with a = 0.6.
c. If we suspect that there might be a jump in the underlying process, which of the two values of a examined in parts (a) and (b) would be preferred?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Management Science The Art Of Modeling With Spreadsheets

ISBN: 1301

4th Edition

Authors: Stephen G. Powell, Kenneth R. Baker

Question Posted: