Please show computations from excel file

Questions Burlington has tracked daily sales of coats for the three locations below: Date Chicago California Seasonal Relatives for Chicago Sales 0.5 New York 152 456 640 586 195 0.4 650 653 1.5 420 543 187 0.7 645 507 632 546 240 0.4 207 0.9 623 531 511 311 373 0.9 1.2 544 639 500 225 0.5 576 570 276 0.3 540 544 475 0.7 475 674 755 1.1 645 711 732 534 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/18 1/26/18 1/27/18 1/28/18 1/29/18 1/30/18 1.4 2.2 594 564 975 511 170 0.3 693 650 699 203 0.7 0.8 645 570 288 580 520 378 0.9 456 400 1.3 609 546 576 798 1.6 585 1111 1.9 649 609 176 0.5 657 480 213 0.7 600 544 240 0.8 703 560 0.7 657 476 311 456 1 546 656 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 23.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) Questions Burlington has tracked daily sales of coats for the three locations below: Date Chicago California Seasonal Relatives for Chicago Sales 0.5 New York 152 456 640 586 195 0.4 650 653 1.5 420 543 187 0.7 645 507 632 546 240 0.4 207 0.9 623 531 511 311 373 0.9 1.2 544 639 500 225 0.5 576 570 276 0.3 540 544 475 0.7 475 674 755 1.1 645 711 732 534 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/18 1/26/18 1/27/18 1/28/18 1/29/18 1/30/18 1.4 2.2 594 564 975 511 170 0.3 693 650 699 203 0.7 0.8 645 570 288 580 520 378 0.9 456 400 1.3 609 546 576 798 1.6 585 1111 1.9 649 609 176 0.5 657 480 213 0.7 600 544 240 0.8 703 560 0.7 657 476 311 456 1 546 656 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 23.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)