Use excel ro answer questions and show work

Problem 1 A regional hospital had the following number of patient admissions during the past 8 weeks: [ a. Using a four-period moving average, forecast the number of patients for weeks 5 to 9 . b. Develop a 3-week weighted moving average forecast for week 4 through 9 with weights of W1 =0.5,W2=0.3 and W3=0.2. c. Forecast patient admissions for week 9 using exponential smoothing with =0.2 Assume that the forecast for Week 4(F4) is the nave forecast