Time

PeriodDemand$186289384485592687788883986109411901292$

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three$-$period and four$-$period moving average forecasts and answer the following questions.

Open spreadsheet

Questions

$1.$ What is the forecast for the $13$th period based on the three$-$period moving average? Round your answer to two decimal places.

fill in the blank $2$

$2.$ What is the MSE for the three$-$period moving average? Round your answer to two decimal places.

fill in the blank $3$

$3.$ Choose the correct graph for the three$-$period moving average forecast.

The correct graph is

graph Agraph Bgraph Cgraph D

$.$

$4$ What is the forecast for the $13$th period based on the four$-$period moving average? Round your answer to two decimal places.

fill in the blank $5$

$5.$ What is the MSE for the four$-$period moving average? Round your answer to two decimal places.

fill in the blank $6$

$6.$ Choose the correct graph for the four$-$period moving average forecast.

The correct graph is

graph Agraph Bgraph Cgraph D

$.$