DescriptiveStatistics1.xlsx
Sheet1
|
| Year |
Make |
Model |
Price ($) |
MPG/C |
MPG/H |
Midsize |
Annual maintenance ($) |
|
| 2024 |
Toyota |
Camry |
25000 |
28 |
39 |
Midsize |
388 |
|
|
| Honda |
Accord |
24500 |
30 |
38 |
Midsize |
400 |
|
|
| Hyaunda |
Sonata |
24000 |
28 |
38 |
Midsize |
458 |
|
|
| Nissan |
Altima |
24300 |
28 |
39 |
Midsize |
483 |
|
|
| Ford |
Fusion |
23170 |
23 |
34 |
Midsize |
581 |
|
|
| Chevolett |
malibu |
23000 |
29 |
36 |
Midsize |
532 |
|
|
| Mazda |
6 |
24100 |
26 |
35 |
Midsize |
481 |
|
|
| Kia |
Optima |
23390 |
24 |
32 |
Midsize |
639 |
|
|
| Subaru |
Legacy |
23475 |
27 |
35 |
Midsize |
471 |
|
|
| Volkswagon |
Passat |
22995 |
24 |
36 |
Midsize |
563 |
|
|
| Bugatti |
Chiron |
3,900,000 |
|
|
|
|
|
|
|
|
| Descriptive Statistics |
|
|
|
|
|
|
|
|
| Mean |
23793.00 |
|
|
|
|
|
|
|
|
| Standard Error |
217.77 |
|
|
| Column1 |
|
|
|
|
| Median |
23737.50 |
|
|
|
|
|
|
|
|
| Mode |
ERROR:#N/A |
|
|
| Mean |
376175.454545455 |
|
|
|
| Standard Deviation |
688.650854933 |
|
|
| Standard Error |
352382.509601334 |
|
|
|
| Sample Variance |
474240 |
|
|
| Median |
24000 |
|
|
|
| Kurtosis |
-1.0036452782 |
|
|
| Mode |
ERROR:#N/A |
|
|
|
| Skewness |
0.3970704861 |
|
|
| Standard Deviation |
1168720.56703143 |
|
|
|
| Range |
2005 |
|
|
| Sample Variance |
1365907763802.27 |
|
|
|
| Minimum |
22995 |
|
|
| Kurtosis |
10.9999908339 |
|
|
|
| Maximum |
25000 |
|
|
| Skewness |
3.3166228904 |
|
|
|
| Sum |
237930 |
|
|
| Range |
3877005 |
|
|
|
| Count |
10 |
|
|
| Minimum |
22995 |
|
|
| Maximum |
3900000 |
|
|
| Sum |
4137930 |
|
|
| Count |
11 |
Gman 21$
