Assignment 6 Project Part 2 – Due by midnight 2/17. Exponential Smoothing Forecast.
This assignment addresses forecasting your selected Y data (dependent variable) using an exponential smoothing technique. Note: Do not use the X (independent) variables in this exercise. Use only one exponential smoothing method — the best that applies. Do not use any other forecasting techniques in this assignment.
a) Tell me why you selected the appropriate exponential smoothing method by commenting on your Y data characteristics. (you should use a time series plot and autocorrelations to do this),
b) Apply the appropriate exponential smoothing forecast technique to your Y variable excluding the last two years of data (hold out period). Show the Y data, fitted values and residuals in excel format and show your exponential smoothing model coefficients. (Find the correct coefficient and not just use the default values.)
c) Evaluate the “Goodness To Fit” using at least two error measures — RMSE and MAPE.
d) Check the “Fit” period residual mean proximity to zero and randomness with a time series plot; check the residual time series plot and autocorrelations (ACFs) for trend, cycle and seasonality.
e) Evaluate the residuals for the “Fit” period by indicating the residual distribution using a histogram (normal or not and random or not),
f) Comment on the acceptability of the model’s ability to pick up the systematic variation in your Fit period actual data.
g) Develop a two year forecast (for the hold out period).
h) Evaluate the “Accuracy” of the forecast for the “hold out period” using RMSE and MAPE error measures used from forecast period residuals and comment them.
i) Do the forecast period residuals seem to be random relative to the hold out period data? Check the forecast period time series plot of the residuals.
j) Did the error measures get worse, remain the same or get better from the fit to the hold out period? Do you think the forecast accuracy is acceptable?
Show your work and graphs in a Word document. Make sure that you comment on statistics and graphs relevant to answering the above questions. DO NOT leave statistics and graphs alone without an comment. If you show something write about it. Again, this is a single Word document with any Mintab results copied and pasted in it.