Excel Online Activity: Exponential Smoothing 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 the single exponential smoothing forecast and answer the following questions. Open spreadsheet Questions 1. What is the forecast for the 13th period based on the single exponential smoothing? Round your answer to two decimal places. 2. What is the MSE for the single exponential smoothing forecast? Round your answer to two decimal places. 3. Choose the correct graph for the single exponential smoothing forecast. The correct graph is Observation Exponential Smoothing Forecast Back Next D 3 2 3 4 5 6 7 -8 9 0 1 2 -3 4 25 26 Exponential Smoothing Forecasting Smoothing constant 0.2 Next period forecast Time Period 1 2 3 5 6 7 9 10 11 12 13 D G Observation Forecast Error Error 2 84 88 83 84 91 96 83 86 89 94 90 93 MSE Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A J #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A FINA #NIA #N/A #N/A #N/A #N/A INA INIA #N/A #N/A #NA #NA K N 0 Use the area below to draw a line chart for Excel Online Activity: Exponential Smoothing 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 the single exponential smoothing forecast and answer the following questions. Open spreadsheet Questions 1. What is the forecast for the 13th period based on the single exponential smoothing? Round your answer to two decimal places. 2. What is the MSE for the single exponential smoothing forecast? Round your answer to two decimal places. 3. Choose the correct graph for the single exponential smoothing forecast. The correct graph is Observation Exponential Smoothing Forecast Back Next D 3 2 3 4 5 6 7 -8 9 0 1 2 -3 4 25 26 Exponential Smoothing Forecasting Smoothing constant 0.2 Next period forecast Time Period 1 2 3 5 6 7 9 10 11 12 13 D G Observation Forecast Error Error 2 84 88 83 84 91 96 83 86 89 94 90 93 MSE Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A J #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A FINA #NIA #N/A #N/A #N/A #N/A INA INIA #N/A #N/A #NA #NA K N 0 Use the area below to draw a line chart for