Forecasts and actual sales of digital music players at Just Say Music are as follows:

Month Forecast Actual Sales March 150 170 April 225 233 May 197 185 June 265 254 July 245 239 August 260 210 September 255 220 October 279 180 Answer the following questions using the Moving Average Excel template:

Choose the correct graph for the forecasts and actual sales of MP3 players at Just Say Music.

The correct graph is -Select-graph Agraph Bgraph Cgraph DItem 1 .

A. B. C. D. What is the forecast for November, using a two-period moving average? Round your answer to two decimal places.

What is the forecast for November, using a three-period moving average? Round your answer to two decimal places.

Compute MSE for the two- and three-period moving average models and compare your results. Do not round intermediate calculations. Round your answers to two decimal places.

2-period MA 3-period MA MSE The -Select-2-period3-periodItem 6 moving average is a better model.