Question
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
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,343Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started