Week2.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 |
| Price |
| Mean |
50736.9 |
| Standard Error |
4895.5742086319 |
| Median |
52449.5 |
| Mode |
ERROR:#N/A |
| Standard Deviation |
15481.1649536533 |
| Sample Variance |
239666468.322222 |
| Kurtosis |
0.1383361392 |
| Skewness |
0.3594925362 |
| Range |
53004 |
| Minimum |
26995 |
| Maximum |
79999 |
| Sum |
507369 |
| Count |
10 |
| Confidence Level(95.0%) |
11074.5582620669 |
Sheet2
| Price |
| Mean |
50736.9 |
| Standard Error |
4895.5742086319 |
| Median |
52449.5 |
| Mode |
ERROR:#N/A |
| Standard Deviation |
15481.1649536533 |
| Sample Variance |
239666468.322222 |
| Kurtosis |
0.1383361392 |
| Skewness |
0.3594925362 |
| Range |
53004 |
| Minimum |
26995 |
| Maximum |
79999 |
| Sum |
507369 |
| Count |
10 |
| Confidence Level(95.0%) |
11074.5582620669 |
Lmessiah
