Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compact Cars Project Part 1 - Proposal The spreadsheet entitled Compact Cars has sales data for six of the top car models, over a six

image text in transcribed
Compact Cars Project Part 1 - Proposal 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: 1. What are the means, medians, modes, range and standard deviation for each of the six car models? Draw box plots. 2. 1What are the means, medians, modes, range and standard deviations for each of the six months (May October)? Draw box plots. Your write up a \"project proposal\". Initial findings should be between 1-2 pages long, that will include a brief introduction, description of the data, and the business questions from above points 1. 8c 2. to be answered, and basic exploratory analyses using descriptive statistics (graphs and numerical summary measures). Phase 1 remit is due 11/17/2019. Your report should have the following sections, arranged sequentially: 1. Introduction and problem background 2. Data description and the business questions to be answered 3. Initial data exploration descriptive statisticsr'graphs 4. Analyses 5. Interpretation of results, deficiencies in methods, final conclusions and recommendations for decision-making Submission: Your initial report must be uploaded on Titanium as a single Microsoft Word or a pdf file. No email submission will be accepted. If a student disregards this and uses email to submit, a zero is assigned for the report. Submitting a report is no guarantee for receiving any credit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus Enhanced With Graphing Utilities (Subscription)

Authors: Michael, Michael Sullivan III, Michael III Sullivan, III Sullivan

6th Edition

0321849108, 9780321849106

More Books

Students also viewed these Mathematics questions