Reference no: EM13140344

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 variableexcludingthe last year of data (hold out period).Show the Y data, fitted values and residuals in excel format andshowyour exponential smoothingmodel 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) Checkthe "Fit" period residual meanproximity tozero andrandomnesswith a time series plot; check the residual time series plot andautocorrelations (ACFs) for trend, cycle and seasonality.

e) Evaluate the residuals for the "Fit" period byindicating 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 one 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?