# Question: Compute the two period and four period moving average predictions for the data

Compute the two-period and four-period moving average predictions for the data set.

a. Prepare a line graph comparing the moving average predictions against the original data.

b. Compute the MSE for each of the two moving averages. Which appears to provide the best fit for this data set?

c. Compute forecasts for the next two weeks using the two-period and four-period moving average techniques.

a. Prepare a line graph comparing the moving average predictions against the original data.

b. Compute the MSE for each of the two moving averages. Which appears to provide the best fit for this data set?

c. Compute forecasts for the next two weeks using the two-period and four-period moving average techniques.

## Answer to relevant Questions

Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE.a. What are the optimal values for the weights?b. Prepare a line graph comparing the weighted moving ...Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of α and β.a. What are the optimal values of α and β?b. Prepare a line graph comparing the ...Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of α and β.a. What are the optimal values of α and β?b. Prepare a line graph comparing the predictions ...Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?Post your question