PLEASE SHOW WORK AND FORMULAS IN EXCEL SHEET

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 272 388 622 605 222 1.3 222 302 338 239 1.7 1.4 1.6 0.9 1.2 0.5 0.3 0.7 1.1 1.4 659 493 483 579 652 535 399 423 619 567 548 766 479 283 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 456 672 584 609 596 529 612 683 565 559 785 783 599 711 756 712 512 447 574 654 552 470 596 562 2.2 505 829 686 893 184 188 290 369 395 846 961 193 193 245 317 435 0.6 0.7 0.8 0.9 1.3 1.5 1.9 0.5 0.8 651 650 491 549 463 595 829 0.8 0.9 886 639 645 627 459 454 480 1 800 Question Set 2. Using only the Nashville sales data: 1. Forecast sales for January 7th through January 30th using a three-day weighted moving average. (5pts) The weights are: Day 1 day previous 2 days previous 3 days previous Weight 0.50 0.30 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. Create a scatter scatter-chart for the three-day weighted moving average. Label your chart axes properly. (2 pts)