Question & Answer: Are more people in the US buying more cars than in the past? Are they buying more foreign cars relative to domestic cars? Are auto sales seaso…..

Are more people in the US buying more cars than in the past? Are they buying more foreign cars relative to domestic cars? Are auto sales seasonal, with more sales occurring during some months than others? Does automobile production mirror sales very closely? These are some questions you have been asked to answer, using the data in the file Part2.xlsx. This file contains monthly data on U.S. sales of domestic and foreign cars since 1967. It also shows monthly production of domestic cars since 1993.The data are shown in two forms: not seasonally adjusted-the raw data-and seasonally adjusted. You are tasked to prepare a report that explains any important patterns you observe in these data. Of course, your report should contain relevant charts and/or tables. Make sure your report indicates whether you are using seasonally adjusted data or raw data (or both) and why? Write your response in APA or MLA format, be sure to include all pivot tables or other charts that you used to support your analysis.