Durhlington has tracked daily sales of coats for the three locations below: Date Washington Seasonal Relatives for
Question:
Durhlington has tracked daily sales of coats for the three locations below:
Date | Washington | Seasonal Relatives for Washington Sales | Newyork | Houston |
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 |
Question Set 2. Using only the Newyork sales data:
1. Forecast sales for January 7th through January 30th using a three-day weighted moving average. (5pts)
The weights are:
Day | Weight |
1 day previous | 0.50 |
2 days previous | 0.30 |
3 days previous | 0.20 |
2. Find the mean absolute deviation of the sales forecasts for January 7th through January 29th. You should not include the forecast for January 30th since there is no corresponding sales figure for that date. (3pts)
3. Find the mean squared error of the sales forecasts, again for January 7th through January 29th. (4pts)
4. show scatter scatter-chart for the three-day weighted moving average. Label your chart axes properly. (2 pts)