Question: Please help with question b. thank you Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in
Please help with question b. thank you
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table:
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| Registrations (000) | 4.04.0 | 6.06.0 | 5.05.0 | 4.04.0 | 10.010.0 | 9.09.0 | 8.08.0 | 11.011.0 | 12.012.0 | 16.016.0 | 12.012.0 |
This exercise contains only parts a and b.
a) Using a 3-year moving average, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal
place):
| Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast | 5 | 5 | 6.3 | 7.6 | 9 | 9.3 | 10.3 | 13 | 13.3 |
b) Using a 3-year weighted moving average in which the registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal
place):
| Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast |
|
| 7.3 | 8.3 | 8 | 8.3 |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
