The spreadsheet entitled Compact Cars has sales data for six of the top automobile models, over a six-month period in 2019. There are no sales for the whole/complete of 2019-year sales data meaning what is available is a sample of the 2019-year sales. Your task is to test both: if the mean number of automobile types sold is significantly different for all of the six models AND whether or not the mean number of automobiles sold per month is significantly different among the months (Some of these tests will be taught in a later part of the class under "Hypothesis Testing" & ANOVA). The sample of automobile sales data for 2019 is in the Excel file provided. So, first do the following tests and conclude the findings (these have been taught in class):

Part 1 What are the means, medians, modes, range and standard deviation for each of the six car MODELS? Draw box plots. 2. What are the means, medians, modes, range and standard deviations for each of the six MONTHS? Draw Column Chart.

Part 1 is due on Sunday March 28, 2021.

Part 2which includes:

1. Introduction to the problem and formulation of a business problem(s) presented.
2. Data description.
3. Descriptive statistics and the supporting graphs.
4. Analyses.
5. Interpretation of results, explain the methods shortcoming (if any, if you don't think there is shortcoming please explain why the methods are appropriate for this analyses), final conclusions which include practical decision-making.

Month Chevy Malibu Ford Fusion Hyundai Sonata Honda Accord Toyota Camry VW Passat January 22,161 21,753 21,456 19,791 21,435 20,121 February 18,724 19,835 20,442 21,322 20,235 19,555 March 18,384 17,007 16,163 17,631 17,339 16,456 April 19,837 17,870 15,504 14,950 14,543 14,533 May 17,547 16,597 15,473 16,250 16,177 17,325 June 16,694 16,623 14,745 15,508 15,686 17,343