I need this problem worked out in excel with formulas please. Screenshots of excel file work perfectly. Thanks!

11. The director of an emergency room, Simran Kaur, has observed that patient traffic at the emergency room follows a seasonal pattern, with higher patient traffic on weekends than on weekdays. She has gathered the following data on daily patient admissions during the past 4 weeks: Week Day 2 3 Monday 110 105 109 112 Tuesday 95 100 92 88 Wednesday 89 85 80 84 e Thursday 93 96 78 90 Friday 150 155 152 148 12 Saturday 255 260 268 275 295 160 Sunday 166 170 175 552 PART III INTEGRATIVE DECISIONS 14. For Given this information: del me a. a. Compute the daily seasonal indices of patient admissions using the simple average method. b. Compute the daily seasonal indices of patient admissions using the centered moving average method. b