Gloster week 7.xlsx - Vehicle type/class SUV SUV COUPE...

Year Make Model Price
SUV 2021 DODGE Duranago 33,260 22
SUV 2021 GMC Yukon 51,995 16
COUPE 2021 Chevrolet Corvette 59,900 15
COUPE 2021 Lexus RC F 65,975 16
SEDAN 2021 BMW 8 Series 85,995 22
SEDAN 2021 Porche Panamera 88,500 18
COUPE 2021 Porche 911 106,500 18
COUPE 2021 Nissan GT-R 113,540 16
COUPE 2021 Aston Martin Vantage 139,000 14
COUPE 2021 Audi R8 142,700 14
SUPERCAR 2021 Bugat Veyron 3,199,000
Vehicle type/class MPG (c)

seating capacity
30 5
20 9
27 2
24 4
29 5
24 4
24 4
22 4
21 2
23 2
MPG (h)

Price Price
33,260 33,260
51,995 51,995
88,500 88,500
85,995 85,995
113,540 113,540
106,500 106,500
139,000 139,000
65,975 65,975
142,700 142,700
59,900 59,900
3,199,000
Mean 88,737
Median 87,248 Mean 371,488
SD 36748.42 Median 88,500
Sample size 10 SD 938427.5
Sample size 11

Price 33260
Mean 88736.5 Mean 405310.5
Standard Error 11620.869901 Standard Error 310566.2
Median 87247.5 Median 97500
Mode #N/A Mode #N/A
Standard Deviation 36748.417279 Standard Deviation 982096.6
Sample Variance 1350446172.5 Sample Variance 9.65E+11
Kurtosis -1.0368121493 Kurtosis 9.97233
Skewness 0.1367675734 Skewness 3.156322
Range 109440 Range 3147005
Minimum 33260 Minimum 51995
Maximum 142700 Maximum 3199000
Sum 887365 Sum 4053105
Count 10 Count 10
Confidence Level(95.0%) 26288.234084 Confidence Level(95.0%) 702549.6

Dif
316574
298945.4
#N/A
945348.2

Price
33,260
51,995
88,500
85,995
113,540
106,500
139,000
65,975
142,700
59,900
Mean 88,737
p 0.6
q 0.4
P(x=5) 11%
p(x < 5)
5%
p(x > 6)
35%
p(x >=4) 99%

Year Make Model Price ating capac
SUV 2021 DODGE Duranago 33,260 22