Please answer the following in excel format while showcasing the equations used:

1. Imagine that you work for an emergency department that wants to get ready for the next week of the flu season. You are asked to forecast the number of patients to expect based on the following data from the past. a) Using 5-period moving average method and develop a forecast for the upcoming week. b) Using 3-period moving average method to forecast week 11 , with weight 0.2,0.5, and 0.3