a) Tell 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). Explain.
b) Apply the appropriate exponential smoothing forecast technique to your Y variable excluding the last year 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.) Explain.
c) Evaluate the "Goodness To Fit" using at least two error measures - RMSE and MAPE.Explain.
d) Check the "Fit" period residual mean proximity to zero nd randomness with a time series plot; check the residual time series plot and autocorrelations (ACFs) for trend, cycle and seasonality. Explain.
e) Evaluate the residuals for the "Fit" period by indicating the residual distribution using a histogram (normal or not and random or not), Explain.
f) Comment on the acceptability of the model's ability to pick up the systematic variation in your Fit period actual data. Explain.
g) Develop a one year forecast (for the hold out period of 8 quarters). Explain
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?
Attachment:- Data.xlsx