Management
For the entire 2018 year, our goal is to test, whether the mean number of car types sold is substantially different for the six models and whether the mean number of cars sold per month is substantially different between the months. At this point in time we are new to data analytics and are not aware of any specific tests to find the answer.
As such we want to infer the answers for the entire 2018 year to the questions above, from the sample data.
Phase 1 report must include the preliminary findings:
- What are the means, medians, modes, range and standard deviation for each of the six car models? Draw box plots.
- What are the means, medians, modes, range and standard deviations for each of the six months (January – June)? Draw box plots.
Your write up a “project proposal”. Initial findings should be between 1-2 pages long, that will include a brief introduction, description of the data, and the business questions from above points 1. & 2. to be answered, and basic exploratory analyses using descriptive statistics (graphs and numerical summary measures).
Your report should have the following sections, arranged sequentially:
- Introduction and problem background
- Data description and the business questions to be answered
- Initial data exploration – descriptive statistics/graphs
- Analyses
- Interpretation of results, deficiencies in methods, final conclusions and recommendations for decision-making
Data
| Month | Chevy Cruze | Ford Focus | Hyundai Elantra | Honda Civic | Toyota Corolla | VW Jetta |
| January | 21,711 | 21,303 | 21,006 | 19,341 | 20,985 | 19,671 |
| February | 18,274 | 19,385 | 19,992 | 20,872 | 19,785 | 19,105 |
| March | 17,934 | 16,557 | 15,713 | 17,181 | 16,889 | 16,006 |
| April | 19,387 | 17,420 | 15,054 | 14,500 | 14,093 | 14,083 |
| May | 17,097 | 16,147 | 15,023 | 15,800 | 15,727 | 16,875 |
| June | 16,244 | 16,173 | 14,295 | 15,058 | 15,236 | 16,893 |
