Statistic 6
edwin.villa
Car_data_2.xlsxSheet1
| Vehicle type/class | Year | Make | Model | Price | MPG (City) | MPG (hwy) | Max Seating |
| SUV | 2020 | BMW | X3 | $42,945 | 25 | 29 | 5 |
| Sedan | 2019 | Chevrolet | Cruze | $18,870 | 28 | 38 | 5 |
| SUV | 2021 | Chevrolet | Tahoe | $55,095 | 16 | 20 | 9 |
| Coupe | 2020 | Chevrolet | Camaro | $26,495 | 20 | 30 | 4 |
| SUV | 2020 | Ford | Edge | $32,345 | 21 | 29 | 5 |
| SUV | 2020 | Ford | Explorer | $34,010 | 21 | 28 | 7 |
| Luxury | 2020 | Porsche | 911 | $111,550 | 18 | 24 | 4 |
| Van/Minivan | 2020 | Toyota | Sienna | $32,760 | 19 | 26 | 7 |
| Sedan | 2020 | Dodge | Charger | $31,390 | 19 | 30 | 5 |
| Van/Minivan | 2019 | Dodge | Grand Caravan | $27,595 | 17 | 25 | 7 |
| Luxury | 2020 | Bugati | Veyron | $1,800,000 | 2 | ||
| Qualitative | Qualitative | Qualitative | Qualitative | Quantitative | Quantitative | Quantitative | Quantitative |
| Descriptive statistics for original price data | |||||||
| Mean | $41,306 | ||||||
| Median | $32,553 | ||||||
| Standard deviation | $26,546.95 | ||||||
| Descriptive statistics for price data when an 11th vehicle is included | |||||||
| Mean | $201,187 | ||||||
| Median | $32,760 | ||||||
| Standard deviation | $530,864.07 |
