Question: Use the data below to compute the following: A.) Compute the 4 period simple moving average forecasts. Compute the MAD and MSE for the 4-period

 Use the data below to compute the following: A.) Compute the
4 period simple moving average forecasts. Compute the MAD and MSE for

Use the data below to compute the following: A.) Compute the 4 period simple moving average forecasts. Compute the MAD and MSE for the 4-period simple moving average. B.) Compute the 4-period weighted moving average forecasts using the weights= 0.2,0.15,0.35 and 0.3 . Compute the MAD and MSE for the 4-period weighted moving average. C.) Compute the exponential smoothing forecasts using alpha=0.25. Compute the MAD and MSE for the exponential smoothing forecasts. D.) Calculate the regression line. Compute the MAD and MSE for the regression line. E.) Use your results for A.)-D.) to determine which forecast is best. Explain your results. Notes: Use the data below to compute the following: A.) Compute the 4 period simple moving average forecasts. Compute the MAD and MSE for the 4-period simple moving average. B.) Compute the 4-period weighted moving average forecasts using the weights= 0.2,0.15,0.35 and 0.3 . Compute the MAD and MSE for the 4-period weighted moving average. C.) Compute the exponential smoothing forecasts using alpha=0.25. Compute the MAD and MSE for the exponential smoothing forecasts. D.) Calculate the regression line. Compute the MAD and MSE for the regression line. E.) Use your results for A.)-D.) to determine which forecast is best. Explain your results. Notes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!