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 19

2 7

3 19

4 18

5 29

6 31

Using excel answer the following: Question 2.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.37 and a starting forecast in day 3 equal to the 23 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 2.7 What is the exponentially smoothed forecast for day 5? (2 marks) (Round to two decimal places) 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.37?(2 marks) (Round to two decimal places)

Question 2.14:

What is the MSE for the exponentially smoothed forecasts for days 4 through 6 with alpha=0.37? (2 marks)

(Round to two decimal places)