Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below:

Day Bicycle Victims

1 14

2 14

3 11

4 11

5 12

6 27

a, What is the forecast for day 4 using a 3-period moving average model? (SHOW THE PROCESS)

b.What is the forecast for day 5 using a 3-period moving average model? (SHOW THE PROCESS)

c. What is the forecast for day 6 using a 3-period moving average model? (SHOW THE PROCESS)

d.What is the MAD for the 3-period moving average forecasts for days 4 through 6? (SHOW THE PROCESS)

e.With an alpha value of 0.42 and a starting forecast in day 3 equal to the 22 , what is the exponentially smoothed forecast for day 4? (SHOW THE PROCESS)

f.What is the exponentially smoothed forecast for day 5? (SHOW THE PROCESS)

g.What is the exponentially smoothed forecast for day 6?(SHOW THE PROCESS)

h.What is the MAD for the exponentially smoothed forecasts for days 4 through 6 using alpha=0.42?(SHOW THE PROCESS)

iWhat is the MSE for the exponentially smoothed forecasts for days 4 through 6 with alpha=0.42? (SHOW THE PROCESS)