Question 1 (10 points) Read the textbook, pages 168 to 173. You will complete the Figure 6?1, the Exhibits 6?1, 6?2, and 6?3. In this question, you will learn how to smooth a time series with moving averages; isolate the seasonality of a time series; and extracting the irregular component. You will also review AVERAGEIF function and learn how to use VLOOKUP function. Note that the Revenues.xlsx file is available on eLearning. You will use the data in the spreadsheets, AMZN Quarterly Revenue, and AMZN Annual Revenue. See below for the answers you will need to create in the excel file. Question 2 (10 points) Read the textbook, pages 186 to 190. You will complete Exhibits 6?9 and 6?10, and 6?11, as well as the Figure 6?7. In this question, you will learn how to forecast the trend using regression and use seasonal dummy variables to account for seasonality. Note that the Revenues.xlsx file is available on eLearning. You will use the data in the spreadsheet, AMZN Quarterly Revenue. See below for the answers you will need to create in the excel file.
