MGSC312v7 |MGSC 312 Assignment_3_sample solved by excel Athabasca University

Quiz 2

1)



Year People (in 100s) Forecast Forecast Error Absolute Value of Forecast Error
1 22
2 24
3 28
4 24 24.67 -0.67 0.67
5 22 25.33 -3.33 3.33
6 24 24.67 -0.67 0.67
7 20 23.33 -3.33 3.33
8 26 22.00 4.00 4.00
9 24 23.33 0.67 0.67
10 28 23.33 4.67 4.67
11 26 26.00 0.00 -
17.33
12 26.00
1) What is the 3-year
moving average for
period 4?

24.67 1)

2) What is the 3-year
moving average
26.00 for period 12?
forecast

3)
What is the Mean
Square Error (MSE) for
the 3-year moving
average?



MSE = 7.67

4)
Year People (in 100s) Forecast Forecast Error Absolute Value of Forecast Error
1 22
2 24 22 2.00 2.00
3 28 22.80 5.20 5.20
4 24 24.88 -0.88 0.88