QNT/275 wk1 pt2

Create and calculate the following in Excel®:

1. Create a Pie Chart which summarizes colors of the cars in the sample.
2. Create a Bar Chart which summarizes the frequency of the models of the cars in the sample.
3. Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.
   • Calculate the mean Days in Inventory for the cars in the sample. 
   • Compare that to the median and the mode.  
4. Highlight the value that would be a better representation of the "typical" price of a car in inventory?
5. Calculate the standard deviation of the Days in Inventory for the cars in the sample. 
6. Calculate the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.