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):

Instructions:

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.

Data:

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