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
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.
- 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?