For this assignment, you will use the attached Excel file, complete all the assignment in that Excel file, save your work, and submit your completed file. 1) The attached Excel Workbook contains six worksheets, named Data Set 1, Data Set 2, Data Set 3, Data Set 4, Data Set 5, and Data Set 6. Using the named worksheets in the file, create a plot of the data in each worksheet. Identify the pattern exhibited by the plot and the forecast method you would recommend using for that data.
2) Open a new worksheet in the workbook, name this worksheet "Problem 2c" (no quotes). Using the data for Problem 2 on page 125, complete a plot of the data.
Which of the forecasting methods in Problem 2 seem least appropriate for this data? Explain.