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 12

2 10

3 22

4 25

5 24

6 27

1. What is the forecast for day 4 using a 3-period moving average model? (1 mark) (Round to two decimal places).

Question 2.2:

What is the forecast for day 5 using a 3-period moving average model? (Round to two decimal places).

Question 2.3:

What is the forecast for day 6 using a 3-period moving average model? (1 mark) (Round to two decimal places).

Question 2.5:

What is the MAD for the 3-period moving average forecasts for days 4 through 6? (2 marks) (Round to two decimal places)

Question 2.6:

With an alpha value of 0.42 and a starting forecast in day 3 equal to the 25 , what is the exponentially smoothed forecast for day 4?

Question 2.7:

What is the exponentially smoothed forecast for day 5?

Question 2.8:

What is the exponentially smoothed forecast for day 6?

Question 2.9:

What is the MAD for the exponentially smoothed forecasts for days 4 through 6 using alpha=0.42?

Question 2.14:

What is the MSE for the exponentially smoothed forecasts for days 4 through 6 with alpha=0.42?