Question description

You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot.

Review the Week 2 Data Set.

You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot.

Review the Week 2 Data Set.

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.
  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.

To get a custom written paper, place an order with us!

Additional Benefits for you

  • ♦ 24/7 customer support
  • ♦ Plagiarism-free research papers
  • ♦ 100% privacy and confidentiality

Strawberries

Leave Comment

Your email address will not be published. Required fields are marked *

GET YOUR PROJECT DONE ASAP