i need this paper rewritten. These were the instructions given. i have attached paper and excel sheet.
Go to the Cengage (Links to an external site.) website and log into your account. Go to the student resources for Chapter 6 of your text. Download the data file Revenues.xlsx. Using the data for TGT (Target Corp) quarterly sales data, complete the following tasks:
- Create a line chart of sales. Is there a trend? Do you notice seasonality? If so, what is the frequency?
- Using the procedures you learned in the text, Chapter 6, decompose the time series into the trend, seasonality, and irregular components.
- Which of the time series methodologies discussed in the chapter would likely be the most appropriate for forecasting Target’s sales?
Submit your Excel workbook. Submit a 1-2-page paper summarizing your answers to questions 1-3, using references to support your conclusions.