Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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. Click anywhere in the data table. Tab Insert > PivotTable > OK. Drag manufacturer to Rows and Values. Drag manufacturer to Values again. Right click on "Count of manufacturer2", Show Values As, % of Grand Total". If your pivot table is made correctly, it will match the picture: What is the most common used-car manufacturer? What are the two least common
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started