Question: PLEASE ANSWER B AND SHOW WORK Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the
PLEASE ANSWER B AND SHOW WORK
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.0 | 6.0 | 4.0 | 5.0 | 10.0 | 8.0 | 7.0 | 9.0 | 12.0 | 14.0 | 15.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 | 4.74.7 | 55 | 6.36.3 | 7.77.7 | 8.38.3 | 88 | 9.39.3 | 11.611.6 | 13.713.7 |
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 | nothing | nothing | nothing | nothing | nothing | nothing | nothing | nothing | nothing |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
