Question 2.1:

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 10

2 6

3 19

4 22

5 28

6 28

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

Note: Please type a number and only a number in text boxes.

Question 2.2:

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

Note: Please type a number and only a number in text boxes.

Question 2.3:

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

Note: Please type a number and only a number in text boxes.

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.33 and a starting forecast in day 3 equal to the 17 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places)(2 marks)

Question 2.7:

What is the exponentially smoothed forecast for day 5? (2 marks) (Round to two decimal places)

Note: Please type a number and only a number in text boxes. Question 2.8:

What is the exponentially smoothed forecast for day 6? (Round to two decimal places)(2 marks) .

Note: Please type a number and only a number in text boxes.

Question 2.9:

What is the MAD for the exponentially smoothed forecasts for days 4 through 6 using alpha=0.33?(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.33? (2 marks)

(Round to two decimal places)