Question: 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
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. Also, do the following: Compare the mean to the median and the mode. Highlight the value that would be a better representation of the "typical" price of a car in inventory.| Sample Car # | Color | MPG | Suggest Retail Price | Option Package | Days in Inventory |
| 1 | Grey | 27.6 | $ 24,390.00 | LX | 1 |
| 2 | Grey | 32.4 | $ 21,780.00 | Touring | 10 |
| 3 | Blue | 33.2 | $ 21,149.00 | Touring | 28 |
| 4 | Black | 34.7 | $ 22,069.00 | LX | 21 |
| 5 | Blue | 27.2 | $ 22,532.00 | Touring | 16 |
| 6 | Blue | 26.6 | $ 20,345.00 | Touring | 22 |
| 7 | Red | 37.3 | $ 22,112.00 | EX | 12 |
| 8 | Silver | 34.9 | $ 21,289.00 | Touring | 23 |
| 9 | Silver | 29.6 | $ 24,871.00 | LX | 15 |
| 10 | Silver | 32.3 | $ 25,389.00 | EX | 8 |
| 11 | Grey | 31.9 | $ 25,998.00 | EX | 28 |
| 12 | Red | 26.4 | $ 19,713.00 | LX | 55 |
| 13 | Black | 34.8 | $ 25,213.00 | EX | 2 |
| 14 | Silver | 35.9 | $ 24,467.00 | Touring | 33 |
| 15 | Black | 34.6 | $ 21,402.00 | LX | 17 |
| 16 | Black | 33.3 | $ 20,351.00 | LX | 14 |
| 17 | Grey | 33.1 | $ 23,732.00 | Touring | 1 |
| 18 | Red | 37.5 | $ 24,558.00 | Touring | 2 |
| 19 | Red | 27.8 | $ 19,167.00 | LX | 18 |
| 20 | Red | 36.1 | $ 19,903.00 | Touring | 22 |
| 21 | Blue | 28.8 | $ 22,140.00 | Touring | 19 |
| 22 | Red | 26.2 | $ 22,180.00 | EX | 41 |
| 23 | Silver | 27.4 | $ 23,120.00 | Touring | 33 |
| 24 | Black | 34.9 | $ 19,837.00 | Touring | 21 |
| 25 | Red | 36.5 | $ 24,666.00 | EX | 31 |
| 26 | Red | 26.3 | $ 19,446.00 | EX | 35 |
| 27 | Blue | 31.4 | $ 23,954.00 | Touring | 11 |
| 28 | Blue | 30.9 | $ 21,201.00 | LX | 3 |
| 29 | Red | 27.4 | $ 21,346.00 | EX | 26 |
| 30 | Red | 36 | $ 19,406.00 | EX | 31 |
Step by Step Solution
3.43 Rating (159 Votes )
There are 3 Steps involved in it
To solve this problem we will proceed through the following steps Step 1 Create a Frequency Table for MPG Classes First we need to decide the classes ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
609ab36e04cfb_30904.pdf
180 KBs PDF File
609ab36e04cfb_30904.docx
120 KBs Word File
