Given the following series Yt, use Excel or Minitab to answer the
following questions: Round your answers to 2 decimal places. (5 points
each part = 25 points total)
a. What is the forecast for period 9 using a five-period moving average?
b. Use simple exponential smoothing with a smoothing constant of .4 and a starting
value equal to the value of the first period to forecast period 9.
c. In part b, what is the forecast error for time period 5?
d. In part b, what is the MAD?
e. In part a, what is the MAD?