Question: 3. Complete the table, using the Holt Winters Multiplicative Model. For the information presented below please find the level (l), growth rate (b), seasonal factor
3. Complete the table, using the Holt Winters Multiplicative Model. For the information presented below please find the level (l), growth rate (b), seasonal factor (sn), forecast, forecast error, squared forecast error, SSE, MSE and s for period # 1 to 4 using the Holt Winter Multiplicative forecasting method. Assume four quarters in a year as four seasons. Please show your calculations. (20 points)
| n | alpha | gamma | delta | SSE | MSE | s | |
| 4 | 0.2000 | 0.1000 | 0.1000 | ||||
| Forecast | Squared | ||||||
| Growth | Seasonal | Made Last | Forecast | Forecast | |||
| Time | y | Level | Rate | Factor | Period | Error | Error |
| -3 | 0.7062 | ||||||
| -2 | 1.1114 | ||||||
| -1 | 1.2937 | ||||||
| 0 | 95.25 | 2.4706 | 0.8886 | ||||
| 1 | 72 | ||||||
| 2 | 116 | ||||||
| 3 | 136 | ||||||
| 4 | 96 |
Please show step by step calculation and final table filled in with al the values. Do not show Excel sheet for calculations, thank you!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
