Developing the histogram and pie chart for the sample data.
Used Car Sales
|
Year Sold
|
$13,500.00
|
2008
|
$11,225.00
|
2005
|
$14,950.00
|
2008
|
$14,650.00
|
2005
|
$13,350.00
|
2008
|
$13,025.00
|
2008
|
$18,375.00
|
2008
|
$16,400.00
|
2008
|
$16,500.00
|
2008
|
$21,550.00
|
2008
|
$17,975.00
|
2005
|
$15,900.00
|
2005
|
$15,600.00
|
2005
|
$13,125.00
|
2005
|
$12,550.00
|
2008
|
$14,725.00
|
2008
|
$20,500.00
|
2005
|
$19,700.00
|
2005
|
$21,275.00
|
2005
|
$21,975.00
|
2008
|
$23,650.00
|
2005
|
$18,650.00
|
2005
|
$17,950.00
|
2005
|
$18,900.00
|
2005
|
$20,125.00
|
2005
|
$21,125.00
|
2005
|
$16,550.00
|
2005
|
$24,450.00
|
2005
|
$20,200.00
|
2008
|
$17,850.00
|
2008
|
$22,500.00
|
2005
|
$20,025.00
|
2005
|
$22,050.00
|
2005
|
$21,075.00
|
2008
|
$22,225.00
|
2008
|
$20,425.00
|
2008
|
$23,975.00
|
2008
|
$24,650.00
|
2008
|
$22,750.00
|
2005
|
$26,450.00
|
2005
|
$18,850.00
|
2008
|
$21,075.00
|
2005
|
$24,200.00
|
2005
|
$23,475.00
|
2005
|
$19,700.00
|
2008
|
$21,275.00
|
2008
|
$18,650.00
|
2005
|
$17,950.00
|
2008
|
$18,900.00
|
2005
|
$26,425.00
|
2008
|
$24,200.00
|
2008
|
$23,475.00
|
2008
|
$24,475.00
|
2008
|
$26,550.00
|
2005
|
$22,750.00
|
2005
|
$26,450.00
|
2008
|
$11,475.00
|
2005
|
$11,750.00
|
2008
|
$10,550.00
|
2005
|
$11,550.00
|
2008
|
You have been hired by a used car dealership in Prince George to perform a statistical analysis on the used cars that were sold from their lot in 2005 and 2008. They have provided you a list of 60 prices of the vehicles that were sold. They have also indicated whether the vehicle was sold in 2005 or 2008.
A) Prepare a histogram from the entire sample of price data. Separate the prices into $4000 intervals with the minimum being $10550 and the maximum being $26550.
B) From the histogram that you have just created, use the cutpoints as original values to code the price data into the following 4 new text groups (beginning with the cheapest group): Low, Middle, Middle-High, and High. Tally the results to determine the number of cars sold in each group. Prepare a Pie Chart (%) that will inform the dealership what percentage of the cars sold fell into each group.
C) Make some comments to explain your graph.