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. 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 1 day previous Weight 0.50 2 days previous 3 days previous 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) 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. (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 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. Questions 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 672 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 1.1 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 463 574 1/23/21 846 1.5 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