Assignment Task: See the tab "Used Car Data". This list represents a consolidated list from 2021 of used cars for sale on Craigs List in the Athens, GA area.
The data set contains 421 used cars from the year 1995 or newer that sold for $1000 or more. The list also includes columns like price, condition, manufacturer and other relevant categories a buyer might find of interest.
Create a pivot table showing the frequency and percent frequency of the manufacturer from the Used Car Data.
What is the most common used car manufacturer? What is the least common used car manufacturer?
In one paragraph, describe any relationship the data shows between year and condition, and explain why.