Please break down the math steps for each part: I$\text{'}$m unsure if I did it correctly.

Use the data from Heartville General Hospital for the past $5$ years below.

You are the hospital's manager, and are considering the best forecasting methods. Accordingly, you

need to calculate the forecasts as instructed, and the errors for each method. Begin error calculation

in year $3,$ so all methods are compared for the same years.

Note: For each forecasting method, calculate these measures and keep one decimal:

i$.$ Average forecast error

ii$.$ the mean absolute percent error $($MAPE$),$

iii. Mean squared error $($MSE$),$

a$.$ Exponential smoothing, with a$=0\mathrm{.}75.$ Let the initial forecast for year $1$ be $46.$

b$.$ Trend projection $($hint: you need to create a regression equation using MS Excel$)$

c$.$ Two$-$ year weighted moving average, using weights $0\mathrm{.}6$ and $0\mathrm{.}4,$ with more recent data given

more weight.

d$.$ If Avg forecast error is chosen, which forecasting method should it choose?

e$.$ If MAPE is chosen, which forecasting method should it choose?

f$.$ If MSE is chosen, which forecasting method should it choose?