Menu
info@onlinenursinghomework.com
Cell: +1 (985) 805-5163

QMB2100 STATISTICS Used Car Project Excel

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

Don't use plagiarized sources. Get Your Custom Essay on
QMB2100 STATISTICS Used Car Project Excel
Just from $9/Page or 300 words
Order Now

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

Looking for a similar assignment? Get help from our nursing qualified experts!

Order Now

Open chat
Get help
You can now contact our live agent via whatsapp! ping +1 ( 681) 249-1107.
You will get plagiarism free custom written paper