pls use excel

Question Set 2. Using only the California 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.40 2 days previous 0.35 3 days previous 0.25 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) Question Set 3. Using only the New York 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 29". (4pts) Date Chicago Seasonal Relatives for Chicago Sales California New York 1/4/18 1/5/18 1/6/18 1/7/18 1/8/18 1/9/18 1/10/18 1/11/18 1/12/18 1/13/18 1/14/18 1/15/18 1/16/18 1/17/18 1/18/18 1/19/18 1/20/18 1/21/18 1/22/18 1/23/18 1/24/18 1/25/1R 1/26/18 1/27/18 1/28/18 1/29/18 1/30/18 152 195 653 187 240 207 311 373 225 276 475 755 732 975 170 203 288 378 400 798 1111 176 213 240 311 456 0.5 0.4 1.5 0.7 0.4 0.9 0.9 1.2 0.5 0.3 0.7 1.1 1.4 2.2 640 586 420 645 507 623 511 500 576 540 475 645 534 511 650 699 580 520 546 576 649 657 600 703 657 546 456 650 543 632 546 531 544 639 570 544 674 711 594 564 693 645 570 456 609 585 609 480 544 560 476 656 0.3 0.7 0.8 0.9 1.3 1.6 1.9 0.5 0.7 0.8 0.7 1