HEllo! I need help with #1&2

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 le below. Use the Microsoft Excel Online le 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. 13.48 0 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 13.48 0 3. Choose the correct graph for the three-period moving average forecast. The correct graph is graphA v 9 , I C D E F G H B Moving Average Forecasting AWNE Periods in moving average 3 Time Demand Forecast Error Error^2 Period Formulas 85 93 88 #N/A #N/A #N/A 89 #N/A #N/A VOUAWN 88 #N/A 7 11 96 #N/A #N/A #N/A #N/A #N/A #N/A 12 94 #N/A 8 85 #N/A #N/A 13 #N/A #N/A 14 9 88 #N/A 10 88 #N/A #N/A #N/A 15 16 11 84 #N/A #N/A #N/A 17 12 92 #N/A #N/A #N/A 18 Next period forecast: 13 #N/A 19 20 MSE #N/A 21 22 23 24 Periods in moving average 4 25 Time Error Error 2 26 Period Demand Forecast 27 85 28 93 29 88 30 89 #N/A #N/A #N/A 31 88 #N/A OO OO VOULAWN 32 96 #N/A #N/A #N/A 7 #N/A #N/A 33 94 34 85 #N/A #N/A #N/A 88 #N/A #N/A #N/A 35 #N/A #N/A 36 88 #N/A #N/A #N/A #N/A 37 11 84 #NIA 38 12 92 #N/A #N/A Next period forecast: 13 #N/A 39 40 #N/A 41 MSE 42 Which moving average is best? #N/A 43 44 45