probabilities responses

profileislandbuilt
Response1.xlsx

Car Analysis

Vehicle Type/Class Year Make Model Price MPG (city) MPG (Highway) Horsepower
SUV 2021 Toyota 4Runner $ 45,012.00 16 19 270
SUV 2021 Chevrolet Tahoe $ 60,030.00 16 20 355
SUV 2020 Land Rover Range Rover $ 93,775.00 18 23 355
SUV 2021 Toyota Rav4 Prime $ 31,228.00 41 38 219
SUV 2021 Chevrolet Suburban $ 71,445.00 15 19 355
SUV 2021 Genesis GV80 $ 60,620.00 18 23 375
SUV 2021 Lexus UX $ 29,900.00 29 37 169
SUV 2020 Audi Q3 $ 29,688.00 19 27 228
SUV 2021 Kia Telluride $ 44,343.00 20 26 291
SUV 2020 Hyundai Palisade $ 32,995.00 19 26 291
Supercar 2021 McLaren F1 $ 19,800,000.00 18 24 600
Qualitative Quantitative Qualitative Qualitative Quantitative Quantitative Quantitative Quantitative
Average Price: $ 49,903.60 p=6/10=.60 q=1-.60=.40
p 0.6
q 0.4
P(x=4) 11.15% % of 10 Random Samples of Cars probability that exactly 4 of them will fall below the average
P(x<5) and P(x<=4) 16.62% % of 10 Random Samples of Cars probability that fewer than 5 of them will fall below the average
P(x>6) = 1 - P(x<=6)= 1 - P(x<=6) 38.23% % of 10 Random Samples of Cars probability that more than 6 of them will fall below the average
P(x>=4) = 1 - P(x<=4-1) = 1 - P(x<=3) 94.52% % of 10 Random Samples of Cars probability that at least 4 of them will fall below the average

10 Vehicles

Column1
Mean 49903.6
Standard Error 6753.1541325352
Median 44677.5
Mode ERROR:#N/A
Standard Deviation 21355.34844899
Sample Variance 456050907.377778
Kurtosis 0.35728503
Skewness 0.9811742596
Range 64087
Minimum 29688
Maximum 93775
Sum 499036
Count 10

11 Vehicles

Column1
Mean 1845366.90909091
Standard Error 1795473.70004346
Median 45012
Mode ERROR:#N/A
Standard Deviation 5954912.58399526
Sample Variance 35460983883025.1
Kurtosis 10.9996604096
Skewness 3.3165544515
Range 19770312
Minimum 29688
Maximum 19800000
Sum 20299036
Count 11