Regression Analysis Report: Annual Motor Sales
Your organization has collected sales data on its small engine product sold and distributed from 6 different locations: Kansas City, Chicago, Houston, Oklahoma City, Omaha, and Little Rock. The organization wants to predict motor sales for the next three months for each location. Your task is to conduct predictive analytics statistical tests on a sample data set named motor_sales.csv. The variable names can be found in the first row of the file.
You are expected to perform the appropriate regression statistics tests and prepare the appropriate tables, charts, and graphs needed to predict future sales. You must provide an alternate and null hypothesis.
Submit the following items for this assignment:
- Screenshots of the results for each statistical test including any charts, graphs, and tables. Include date and time for each screenshot capture.
- Alternate and null hypotheses for each business question
- Projections for 3 months of future sales for each location
- What business insights can the company gain from the results of this test
Your paper must be three to five pages in length (not including the title page and reference pages). Figure notation for screenshots should comply with APA guidelines. In support of your response, cite and integrate at least two scholarly sources.