# QMB2100 STATISTICS Used Car Project Excel

Need help with my Statistics question – I’m studying for my class.

## Instructions

Suppose you are in the market to purchase a used car. To make an informed decision regarding your purchase, you would like to collect as much information as possible. Among the information you might consider is the typical price of the car, the typical number of miles the car should have, and its crash test results, insurance costs, and expected repair costs.

Make a list of at least three cars that you would consider purchasing. To be fair, the cars should be in the same class (compact, midsize, etc). They should also be of the same age.

Collect information regarding the three cars in your list by finding at eight cars of each that are for sale. Obtain such information as the asking price and the number of miles the car has. Sources of data include your local newspaper, classified ads, and car websites (www.cars.com and www.vehix.com). Compute the summary statistics for asking price, number of miles, and other variables of interest. Remember, the summary statistics include min, max, mean, median, mode, range, variance, standard deviation, and so on.

• Write a report (4-5 paragraphs) in Microsoft Word (.doc or .docx) format with supporting data supporting your conclusion regarding which car you would purchase and why.
• Attach the Excel sheet used for the primary data source.
• You’ll submit both the Word document and the Excel file.

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeContent

 30.0 to >26.0 pts Exemplary All required elements are fully addressed, easily identified, and integrated into the assignment at the highest level. All key facts are clearly identified and completely addressed. 26.0 to >17.0 pts Meets Expectations All required elements are addressed and identified. Several key facts are identified and completely addressed. 17.0 to >9.0 pts Developing Required elements are addressed, but further elaboration is needed. A few key facts are identified and addressed. 9.0 to >0.0 pts Novice Few of the required elements are addressed. Little or no elaboration present. 0.0 pts Not Acceptable Assignment not submitted, submitted late OR contains plagiarized content.

30.0 pts

This criterion is linked to a Learning OutcomeData Source

 30.0 to >26.0 pts Exemplary Original data provided and summarized in appropriate tabular form and is presented in a neat and accurate way graphically or numerically 26.0 to >17.0 pts Meets Expectations Original data provided and summarized in tabular form, but with a minor error in tabulation or computation or presentation. 17.0 to >9.0 pts Developing Original data is provided, with quite a few errors when summarizing data either graphically or numerically or data is not appropriately tabulated. 9.0 to >0.0 pts Novice Original data is provided, tabulated and summarized but with some major errors. 0.0 pts Not Acceptable Original data is not provided.

30.0 pts

This criterion is linked to a Learning OutcomeTechnical

 40.0 to >34.0 pts Exemplary Demonstrates excellent problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, well organized, and flows well. 34.0 to >27.0 pts Meets Expectations Demonstrates good problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, organized, yet minor errors in format exist. 27.0 to >17.0 pts Developing Demonstrates inadequate problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported and correctly interpreted. Composition is, generally, structured logically, focused, organized, and flows well with but a few errors in format exist. 17.0 to >4.0 pts Novice Demonstrates poor problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported yet incorrectly interpreted. Composition is, generally, structured logically, focused, organized, but major errors in format exist. 4.0 to >0 pts Not Acceptable Confusing explanation of statistical concepts.

40.0 pts

This criterion is linked to a Learning OutcomeData Interpretation

 30.0 to >26.0 pts Exemplary Thorough and accurate interpretation of the data 26.0 to >17.0 pts Meets Expectations Correct and good interpretation of the data. 17.0 to >9.0 pts Developing Correct and good interpretation of the data, except for minor errors or omissions. 9.0 to >0.0 pts Novice Interpretation of the meaning of the data is provided, but with some major errors. 0.0 pts Not Acceptable No data interpretation provided

30.0 pts

This criterion is linked to a Learning OutcomeReport Writing

 30.0 to >26.0 pts Exemplary Follows APA writing style and basic rules of formal English grammar and written essay style. Communicates in a cohesive, logical style. 26.0 to >19.0 pts Meets Expectations Mostly follows APA writing style and basic rules of formal English grammar and written essay style. Mostly communicates in a cohesive, logical style. 19.0 to >12.0 pts Developing APA writing style and basic rules of formal English grammar and written essay style are followed, but with minor errors. Mostly communicates in a cohesive, logical style though at times ideas are unclear and confusing. 12.0 to >5.0 pts Novice APA writing style and basic rules of formal English grammar and written essay style are followed, but with major errors. Report is not communicated in a cohesive, logical style. Ideas are unclear and confusing. 5.0 to >0 pts Not Acceptable Does not follow APA writing style and basic rules of formal English grammar and written essay style.

30.0 pts

[opskill_register_order]

### "Looking for a Similar Assignment? Order now and Get a Discount!

essaywritinghelp.net
Hello