Please Show Formula in Excel

Data collected on patient days in a hospital over the past 12 months are shown in the following table. a) Using a weight of . 50 for the most recent observation, 30 for the second most recent, and 20 for third most recent, compute a three-month weighted moving average for the time series. Compute the MAD, MSE and MPE for this method.( six marks) b) Use exponential smoothing with a smoothing constant of 0.30 to forecast the patient days. Assume that last period's forecast for month I is equal to actual to begin the procedure. Which method do you think is best? Is this an improvement over the weighted average- use MAD only ( Six marks) c) Use regression analysis to estimate the line of best fit -use the manual method with the formulas shown below.f. eight marks)