Here is the data for M8 Lab.

Please calculate a model to forecast for 19,20,21 and 22. What is the projected margin of error

Period QuarterActual

1 1 119

2 2 133

3 3 167

4 4 186

5 1 187

6 2 167

7 3 196

8 4 207

9 1 201

10 2 215

11 3 276

12 4 248

13 1 269

14 2 301

15 3 342

16 4 291

17 1 207

18 2 300

Using excel:

A. Explain and graph the data using the Holt-Winter's Model

B- Calculate an example a graph that uses the Holt-Winter's Model graph which compares how the model "tracks" actuals

C- Explain and calculate the projected errors for the 4 forecasts for each of the various smoothing constants ( please show and explain the algorithmically increment).

D- please calculate and explain the model graph results as it compares to actual for the worst set of smoothing constants as it relates to your errors.

E-Please calculate and explain the graph results as it compares to actualfor the best set of smoothing constants as it relates to your errors.