Excel Online Activity: Moving Average 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 TER X Open spreadsheet Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places 2. What is the MSE for the three period moving average? Round your answer to two decimal places. 3. Choose the correct graph for the three-period moving average forecast. The correct graph is 100 Chervation Forecast Three-Perlod Moving Average Forecast 93 Three-Period Moving Average Forecast 100 Observation Forecast 95 90 . 35 80 Time Period 10 14 100 Observation Forecast Three-Period Moving Average Forecast 95 90 B 85 80- Inree-Period moving Average Forecast 100 Observation Forecast 95 90 C. 85 80 Time Period 9 10 11 12 13 14 Observation Forecast 100 Three-Period Moving Average Forecast 95 90 D. D 85 80 Time Period 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal pla 5. What is the MSE for the four-period moving average? Round your answer to two decimal places 6. Choose the correct graph for the four-period moving average forecast. The correct graph is 100 Observation Forecast Three-Period Moving Average Forecast 95 90 - A. 85 SO Time Period 10 11 12 13 M N R Moving Average Forecasting Use the area below to draw are chart for the the period moving avere Periods ir moving average 3 Time Panod Error Error Form 2 Demand Forecast 07 BY 12 B3 BB 83 5 ANA WIM WNIA NA NA WNA NA NA WA 7 MA VA 02 90 BO 34 WA FANA ANA NA 10 11 12 13 NA WA NA WA NA Nest persona ME WA Pod Demand for EE Periods in wege Use the bow to dourado Time Period Demund Forecast Emo Error 20 02 + 5 LA ANCA V VW V VINE WN Value Not Available Aww to the con VITW MON 2 WA - w LA WA 1 M VN WA Next periodo WA ANA ME WA Which moving Vite