Week1Cars.xlsx
Sheet1
| Vehicle type/class |
Year |
Make |
Model |
Price |
MPG (city) |
MPG (highway) |
Engine size |
| suv |
2018 |
jeep |
GC SRT |
64999 |
13 |
19 |
6.4 |
| sedan |
2018 |
Dodge |
Charger SRT |
52999 |
13 |
22 |
6.4 |
| sedan |
2018 |
Dodoge |
Challenger SRT |
51999 |
13 |
22 |
6.4 |
| sedan |
2010 |
BMW |
M5 |
59980 |
13 |
21 |
5 |
| sedan |
2018 |
Chrysler |
300s |
36500 |
19 |
30 |
3.6 |
| sedan |
2011 |
BMW |
M3 |
26995 |
14 |
21 |
4 |
| truck |
2020 |
Ram |
2500 |
52,900 |
14 |
24 |
6.7 |
| truck |
2020 |
Ram |
Rebel |
43999 |
22 |
32 |
5.7 |
| suv |
2021 |
Tesla |
Model x |
79999 |
328e |
371e |
emotor |
| sedan |
2021 |
Honda |
Civic R |
36999 |
22 |
28 |
2 |
|
|
|
| Descriptive statistics |
|
|
|
| Mean: |
50736.9 |
|
|
|
| Median: |
52449.5 |
|
|
|
| SD: |
15481.1649536533 |
|
|
|
| sample size: |
10 |
| Super Car |
2019 |
Buggati |
Chiron |
3,799,000 |
9 |
14 |
8L |
|
|
|
| Descriptive statistics |
|
|
|
| Mean |
1,924,868 |
|
|
|
| Median |
1,925,725 |
|
|
|
| SD |
2675351.8250083 |
|
|
|
| Sample Size |
11 |
Lmessiah
