Question: Recall the car data set you identified in Week 2.You will want to calculate the average for your data set.(Be sure you use the numbers
Recall the car data set you identified in Week 2.You will want to calculate the average for your data set.(Be sure you use the numbers without the supercar outlier)Once you have the average count how many of your data points fall below the average. You will take that number and divide it by 10.This will be your p or "success" in your problem.Once you have p, calculate q.
If you were to find another random sample of 10 cars base

. . . X M22 X V fx L D E F G H K B Year Quantative Make Qualative Model Qualative Price Quantative MPG /city Qualative MPG /highway Qualative Drive type Qualitive 1 Vehicle type/class Qualative 33378 2017 Ford F150 33,378 17 23 Four weel drive 2 Truck 3 Truck 1500 SLT 30,500 15 22 Four weel drive 2020 RAM 24104.4444 4 Truck 2016 Toyota Tundra SR5 34,688 13 17 Four weel drive Mean 2017 GMC 27,497 1951.11781 Cayon SLE 17 24 Four weel drive Standard Error Truck 21 28 Four weel drive Median 22989 6 SUV 2017 Jeep Cherokee 20,989 Mode #N/A SUV 2018 Subaru Crosstrek 22,989 27 33 Four weel drive 20 27 Four weel drive Standard Deviation 5853.35344 8 SUV 2017 Infinity 2X60 24.989 2017 Mazda Mazda3 17,585 27 36 2 Weel Drive Sample Variance 34261746.5 9 Car 2017 Honda Civic 18,500 32 42 2 Weel Drive Kurtosis 0.5054809 10 Car 35 2 Weel Drive 0.7086691 11 Car 2017 Acura ILX 19,203 25 Skewness Range 17103 12 Minimum 17585 13 Maximum 3468 8 14 Sum 216940 15 Count 9 16 17 Model Qualative Price Quantative MPG /city Qualative MPG /highway Qualative Drive type Qualitive 18 Vehicle type/class Qualative Year Quantative Make Qualative 33378 19 Truck 2017 Ford F150 33,378 17 23 Four weel drive 30,500 15 22 Four weel drive 20 Truck 2020 RAM 1500 SLT 13 17 Four weel drive 21 Truck 34,688 Mean 40834 2016 Toyota Tundra SR5 24 Four weel drive Standard Error 16820.3305 22 Truck 2017 GMC Cayon SLE 27,497 17 28 Four weel drive Median 23989 23 SUV 2017 Jeep Cherokee 20,989 21 Mode #N/A 24 SUV 2018 Subaru Crosstrek 22,989 27 33 Four weel drive 24.989 20 27 Four weel drive Standard Deviation 53190.5553 25 SUV 2017 Infinity 2X60 Mazda3 17,585 27 36 2 Weel Drive Sample Variance 2829235177 26 Car 2017 Mazda 32 42 2 Weel Drive Kurtosis 9.70437758 27 Car 2017 Honda Civic 18,500 25 35 2 Weel Drive Skewness 3.09947559 28 Car 2017 Acura ILX 19,203 Veyron 16.4 191,400 7 15 All Wheal Drive Range 173815 29 Super car 2011 Bugatti Minimum 17585 30 Maximum 191400 31 Sum 408340 32 Count 10 33 34 35 36 37 20 Sheet1 + 3:34 PM lenovo O U X N P W Show hidden icons 12/24/2020
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
