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 on a new worksheet showing the frequency and percent frequency of the manufacturer from the Used Car Data.

What is the most common used$-$car manufacturer?

What are the two least common?

Create a two way pivot table on a new worksheet showing Year vs$.$ Condition using the Used Car Data.

What relationship do you see in this data between year and condition $($How does age affect condition?$).$