The spreadsheet titled Compact Cars has sales data for six of the top car models, over a six month period in 2019. We do not have sales for the whole of 2018 year meaning the data we have on hand is a sample of the 2018 whole year population data.

For the entire 2019 year, our goal is to test, whether a) the mean number of car types sold is substantially different for the six models and b) whether or not 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 2019 year to the questions above, from the sample data

Carry out the following tasks and fully explain your results for each:

1. A) What are the means, medians, modes, range and standard deviation for each of the six car models? (i.e. generate descriptive statistics) B) Draw box plots.
   1. Show the Excel File including all of the analysis to show the work.

Car Model 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 Car Model 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