A restaurant wants to forecast its weekly sales.

Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet C9 Excel P39 Data in MindTap. Use Excel and the Moving Average template to answer the following questions. (Note: You may copy the data from the worksheet to the template.)

a. Plot the data and provide insights about the time series.

b. What is the forecast for week 16, using a twoperiod moving average?

c. What is the forecast for week 16, using a threeperiod moving average?

d. Compare MSE for the two- and three-period moving average models to determine the best model.

Transcribed Image Text:

Week 1 2 3 4 5 6 7 00 9 10 11 12 13 14 15 Sales (dollars) 1623 1533 1455 1386 1209 1348 1591 1332 1245 1521 1421 1502 1656 1614 1332