Use the information provided in 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.
Part 2
Use the information provided in 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.
Part 3
In a Word document, write a 23 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?
Submission Instructions
- Submit the Excel document containing your work for Parts 1 and 2.
- Submit the Word document containing your work for Part 3.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
✔Secure Service ✔ Plagiarism Free ✔On-time Delivery
Leave a Reply
You must be logged in to post a comment.