Proposal Report About Data. Data Analysis. SPSS Data Analysis
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:
- What are the means, medians, modes, range and standard deviation for each of the six car models? Draw box plots.
- 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:
- Introduction and problem background
- Data description and the business questions to be answered
- Initial data exploration – descriptive statistics/graphs
- Analyses
- 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 |
Leave a Reply
Want to join the discussion?Feel free to contribute!