PLEASE USE EXCEL FOR ANSWER, AND PLEASE, PLEASE SHOW FORMULAS IF USED.

THANK YOU

Question Set 3. Using only the Seattle sales data: 1. Forecast sales for January 5th through January 30 using exponential smoothing with alpha set to 0.8. Assume the sales forecast for January 4" was 441. (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 29" (4pts) Reminder: Check your work to make sure you have only included forecasts and accuracy measures for the exact date ranges specified. Also, please copy these tables into your Excel file while solving. Durhlington has tracked daily sales of coats for the three locations below: Date Chicago Nashville Seattle Seasonal Relatives for Chicago Sales 0.4 0.5 441 272 388 659 493 672 622 483 1.5 1.7 584 634 605 579 222 1.4 652 596 222 1.9 514 529 302 0.9 399 612 347 423 1.2 0.5 683 564 239 619 283 0.3 588 559 505 0.7 548 785 829 1.1 766 783 697 1.4 479 599 1/4/21 1/5/21 1/6/21 1/7/21 1/8/21 1/9/21 1/10/21 1/11/21 1/12/21 1/13/21 1/14/21 1/15/21 1/16/21 1/17/21 1/18/21 1/19/21 1/20/21 1/21/21 1/22/21 1/23/21 1/24/21 1/25/21 1/26/21 1/27/21 1/28/21 1/29/21 1/30/21 2.2 711 893 184 188 0.3 435 651 650 710 0.7 712 290 0.8 491 512 369 0.9 549 447 1.3 451 574 395 846 1.6 595 654 1161 193 1.9 0.5 0.7 829 886 552 496 193 639 596 226 0.8 656 562 317 0.7 627 454 480 1 469 841