Question: 3. Using only the Seattle sales data: 1. Forecast sales for January 5 th through January 30 th using exponential smoothing with alpha set to
3. Using only the Seattle sales data:
1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th was 456. (6pts)
2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5th through January 29th. Again, you should not include the forecast for January 30th since there is no corresponding sales figure for that date. (4pts)
3. Using your forecasts from Q3.1, find the mean squared error of the sales forecasts for January 5th through January 29th. (4pts)
| Date | Chicago | Seasonal Relatives for Chicago Sales | Nashville | Seattle |
| 1/4/21 | 272 | 0.4 | 659 | 456 |
| 1/5/21 | 388 | 0.5 | 493 | 672 |
| 1/6/21 | 622 | 1.3 | 483 | 584 |
| 1/7/21 | 605 | 1.7 | 579 | 609 |
| 1/8/21 | 222 | 1.4 | 652 | 596 |
| 1/9/21 | 222 | 1.6 | 535 | 529 |
| 1/10/21 | 302 | 0.9 | 399 | 612 |
| 1/11/21 | 338 | 1.2 | 423 | 683 |
| 1/12/21 | 239 | 0.5 | 619 | 565 |
| 1/13/21 | 283 | 0.3 | 567 | 559 |
| 1/14/21 | 505 | 0.7 | 548 | 785 |
| 1/15/21 | 829 | 1.1 | 766 | 783 |
| 1/16/21 | 686 | 1.4 | 479 | 599 |
| 1/17/21 | 893 | 2.2 | 435 | 711 |
| 1/18/21 | 184 | 0.6 | 651 | 756 |
| 1/19/21 | 188 | 0.7 | 650 | 712 |
| 1/20/21 | 290 | 0.8 | 491 | 512 |
| 1/21/21 | 369 | 0.9 | 549 | 447 |
| 1/22/21 | 395 | 1.3 | 463 | 574 |
| 1/23/21 | 846 | 1.5 | 595 | 654 |
| 1/24/21 | 961 | 1.9 | 829 | 552 |
| 1/25/21 | 193 | 0.5 | 886 | 470 |
| 1/26/21 | 193 | 0.8 | 639 | 596 |
| 1/27/21 | 245 | 0.8 | 645 | 562 |
| 1/28/21 | 317 | 0.9 | 627 | 454 |
| 1/29/21 | 480 | 1 | 459 | 800 |
| 1/30/21 |
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
