In this assessment, you will use data on car prices to create charts in Excel an

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

In this assessment, you will use data on car prices to create charts in Excel an

In this assessment, you will use data on car prices to create charts in Excel and calculate statistical measures from the
dataThe data is provided in Auto Data [XLSX] Download Auto Data [XLSX]. It contains information on 82 used cars that are for sale, specifically, the asking price, the model year, the mileage, the color, and the trim.
Part 1
Use the information provided in Auto Data [XLSX] Download Auto Data [XLSX]to create the following:
A bar chart using either the color or trim variable. Make sure you include a title for the plot and label all axes correctly.
A pie chart using either the color or trim variable. Make sure you include a title for the plot and label the sectors of the chart correctly.
A scatterplot using the miles and asking price. Make sure you include a title for the plot and label all axes correctly.
You may refer to pages 264–267 of the text for information on how to read these types of charts.
Part 2
Use the information provided in Auto Data [XLSX] Download Auto Data [XLSX]to calculate the following:
The mean and median for the Asking Price and Miles variables.
The (sample) standard deviation for the Asking Price and Miles variables.
The proportion of Luxury cars and the proportion of Performance cars.
You may refer to pages to 271–290 of the text for more information on these statistical measures.
Part 3
In a Word document, write a 2–3 paragraph summary of your findings:
What are two interesting findings when looking at the charts in Part 1?
How would the charts help you make an informed decision if you were in the market for buying a vehicle?
Explain briefly the real-world situation to which it applies.
State the problem. Which question should be answered?
Explain the solution. What are the mathematical steps necessary to solve the problem?
Submission Instructions
Submit the Excel document containing your work for Parts 1 and 2.
Submit the Word document containing your work for Part 3.

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!