Proposal Report About Data. Data Analysis. SPSS Data Analysis

Compact Cars Project -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. What are the means, medians, modes, range and standard deviations for each of the six months (January – June)? 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. & 2. to be answered, and basic exploratory analyses using descriptive statistics (graphs and numerical summary measures). Phase 1 report is due 4/7/2020.

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 statistics/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.

Proposal Part 1: 20 points maximum based on the rubric, to be converted to 2 points

Proposal Part 1 grading: Using rubric criteria (see below).

For Phase 1, feedback to be provided based on these components:

• Adherence to the project guidelines: Check to see whether you have included all the deliverables and the document meets the guidelines for structure (sections) and formatting.
• Quality and presentation of the project background and initial analyses: Check to see if you have included a clear description of the background, business questions, and accurate descriptive statistics and graphs, as needed to obtain useful insights relevant to the business questions (with interpretation – just not the numbers/graphs). Provide guidance so that the next steps in the analysis could be completed successfully.
• Quality and clarity of writing (including grammar and organization): Check for flow, organization, grammatical errors and typos. For writing guidance, refer to the Business Writer’s Handbook.

 

Data

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

 

Grading Rubric

 

Criteria	Poor (0 – 2)	Average (2 – 4)	Excellent (4 – 5)
Introduction & Background: a)       Purpose, business problem description; b)       Description of variables and outline of the statistical methods to be applied (descriptive statistics for Phase 1 and inferential methods for Phase 2)	a) Purpose unclear and the problem description vague; b) Description of variables and statistical methods incorrect or vague (as relevant to each Phase)	a) Purpose included but the problem description lacks clarity; b) Outline of variables and statistical methods adequate (1 error at most) but can be improved	a) Problem well-defined and covers the scope; b) Variable descriptions and statistical methods accurately and clearly outlined
Methodology: Application of the appropriate statistical methods and analyses (as relevant to each Phase)	Incorrect statistical method used and incorrect analysis (Does not meet)	Correct method used but some errors in intermediate steps of the analyses and calculations	Correct method used, correct steps followed, and correct final answers (meets expectations)
Decision-making: Interpretation of the results, conclusions, and final decision-making in the context of the business problem	Conclusion is incorrect and interpretation is incorrect or missing (does not meet)	Correct interpretation of results but the conclusions are not communicated properly in the business context (meets but can be improved)	Correct interpretation of results and conclusions in the context of the business problem (meets expectations completely)
Organization: Development, layout, flow and design	Points not sequential – hard to follow; layout incorrect; design is incorrect or messy	Points are sequential; layout is adequate; design and flow are adequate (meet but can be improved)	Points are well developed, layout is clean, and design is professional
Literacy: Paragraphs, grammar, punctuation, & word choice; Introduction & conclusion	Several misspellings; grammar and/or word usage errors are disruptive; does not include introduction or conclusion	Minor errors in spelling, grammar, punctuation, or word choice; introduction and/or conclusion are included but are not well-structured	Not more than 1 or 2 errors overall; effective introduction and conclusion