The spreadsheet entitled Compact Cars has sales data for six of the top car models, over a six month period in 2018. We do not have sales for the whole of 2018 year, meaning the data we have at hand is a sample of the 2018 whole year population data. 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 plot
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