Do it on Excel. Show all the work

The manager of the health clinic would also like to use exponential smoothing to forecast demand for emergency services in the facility. However, she is not sure whether to use a high or low value of a. To make her decision, she would like to compare the forecast accuracy of a high and low a on historical data. She has decided to use an a = 0.6 for the high value and a = 0.2 for the low value. For both alpha values, enter exponential smoothing forecasts for weeks 2-6, and calculate the MAD for each alpha value. (Round answers to 2 decimal place, e.g. 15.25.) Initatilize the computations using the naive method Demand (in patients serviced) Week 1 420 2 308 3 3 364 4 449 5 474 6 357 Exponential Smoothing Forecasts Week Demand a-02 a 0.6 1 420 2 308 3 364 449 474 5 357 6 MAD 6 357 MAD (a) which value of a do you think would be better to use? It would be better to use a (b) is your answer the same as in part above? The answer is