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. 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 Insert Arial 09 fo 1 Moving Average Forecasting 2 -3 Periods in moving average 4 5 6 7 8 9 10 11 12 13 14 File 15 16 17 18 19 20 21 22 23 Home V Next period forecast Draw B Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 Page Layout 10 Formulas Data A D E 3 Demand Forecast Error 88 90 85 86 84 94 96 90 93 92 88 96 MSE B F Error 2 Review View *** H G Formulas SN/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Help E I #N/A FINA UNA UNA #N/A #N/A #N/A #N/A UN/A F Editing Number J UNIA Y SNA F #N/A ONIA BNIA ANIA FINA SNIA FINA ERA M K M N 0 P Q Use the area below to draw a line chart for the three-period me Use the area below to draw a line chart for the four-period mon A 23 24 Periods in moving average 25 26 27 00010338883300 28 29 32 34 35 36 37 39 40 41 42 43 ****** 44 45 46 47 48 B 4 Time Period 1 2 3 4 5 6 7 B 9 10 11 12 Next period forecast: 13 Which moving average is best? C D Demand Forecast 88 90 85 86 84 94 96 90 93 92 88 MSE 96 E F Error Error 2 G SN/A #N/A INA INIA #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A F #N/A #N/A FINA INIA UNIA #N/A #N/A } #N/A UNIA #N/A #NIA UNIA INIA #NIA F #N/A K M 0 Use the area celow to draw a ane chart for the