I need the answers on an excel file with the formulas please

IDS 355 Summer 2021 Assignment 2 Due Friday 10/15 11:59pm 40 points Instructions Deadline This assignment may be submitted for full credit until Friday, October 15th at 11:59pm. Late submissions will not be accepted one week after the deadline. If you need an extension for an assignment, you must ask your TA in advance. Please consult the syllabus for details about lateness penalties and extension requirements. In any event, we strongly recommend submitting your assignment early, in case problems arise with the submission process. Problem Guidelines Because using spreadsheet software is a basic business skill, the assignments are intended to give you practice in structuring problems as well as simply finding the answers. All problems must be solved using Excel formulas to receive credit. If, for example, you solve a problem on paper and then copy the results to Excel, you will receive no credit for that problem. Submission Guidelines All assignments are to be submitted using the Blackboard site. Assignments should be uploaded using the upload link associated with the assignment. It is important that all homework files include the student's NetId, so they can be easily identified and sorted. The file containing homework assignment 2 submitted by the student with NetiD rbaker2 should be named rbaker2hw2. Make sure your submission is a working file. If you upload a corrupted file (or a file which cannot be downloaded and opened completely), you will receive 0 points for this assignment. For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right-click the worksheet tab located at the bottom of your current sheet and use the rename option. Label the tabs as "Q Set 1", "Q Set 2", and "Q Set 3, respectively. Be sure to label all results clearly. Questions 672 Durhlington has tracked daily sales of coats for the three locations below: Seasonal Relatives for Date Washington Newyork Houston Washington Sales 1/4/21 272 0.4 659 456 1/5/21 388 0.5 493 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 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 574 1/23/21 846 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 1.1 463 1.5 Question Set 1. Using only the Washington sales data, generate the following sales forecasts: 1. Nave forecasts (using the deseasonalized sales data) for January 5th through January 30th. You will need to adjust the sales data to remove the seasonality effects. (6pts) 2. Four-day moving average forecasts for January 8th through January 30th using the original (seasonalized) sales data. (3pts) 3. Twelve-day moving average forecasts for January 16th through January 30th using the original (seasonalized) sales data. (3pts) Note that, for example, you will not be able to make a four-day moving average forecast for January 7th since four previous sales figures are required. 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. 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 Houston 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. (pts) 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 29th (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. IDS 355 Summer 2021 Assignment 2 Due Friday 10/15 11:59pm 40 points Instructions Deadline This assignment may be submitted for full credit until Friday, October 15th at 11:59pm. Late submissions will not be accepted one week after the deadline. If you need an extension for an assignment, you must ask your TA in advance. Please consult the syllabus for details about lateness penalties and extension requirements. In any event, we strongly recommend submitting your assignment early, in case problems arise with the submission process. Problem Guidelines Because using spreadsheet software is a basic business skill, the assignments are intended to give you practice in structuring problems as well as simply finding the answers. All problems must be solved using Excel formulas to receive credit. If, for example, you solve a problem on paper and then copy the results to Excel, you will receive no credit for that problem. Submission Guidelines All assignments are to be submitted using the Blackboard site. Assignments should be uploaded using the upload link associated with the assignment. It is important that all homework files include the student's NetId, so they can be easily identified and sorted. The file containing homework assignment 2 submitted by the student with NetiD rbaker2 should be named rbaker2hw2. Make sure your submission is a working file. If you upload a corrupted file (or a file which cannot be downloaded and opened completely), you will receive 0 points for this assignment. For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right-click the worksheet tab located at the bottom of your current sheet and use the rename option. Label the tabs as "Q Set 1", "Q Set 2", and "Q Set 3, respectively. Be sure to label all results clearly. Questions 672 Durhlington has tracked daily sales of coats for the three locations below: Seasonal Relatives for Date Washington Newyork Houston Washington Sales 1/4/21 272 0.4 659 456 1/5/21 388 0.5 493 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 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 574 1/23/21 846 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 1.1 463 1.5 Question Set 1. Using only the Washington sales data, generate the following sales forecasts: 1. Nave forecasts (using the deseasonalized sales data) for January 5th through January 30th. You will need to adjust the sales data to remove the seasonality effects. (6pts) 2. Four-day moving average forecasts for January 8th through January 30th using the original (seasonalized) sales data. (3pts) 3. Twelve-day moving average forecasts for January 16th through January 30th using the original (seasonalized) sales data. (3pts) Note that, for example, you will not be able to make a four-day moving average forecast for January 7th since four previous sales figures are required. 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. 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 Houston 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. (pts) 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 29th (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