Reference no: EM1316537

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.