Please show work as well

Thanks!

Using the data in the worksheet Consumer Transportation Survey, develop a contingency table for Gender and Vehicle Driven; then answer the following questions. You must have three pivottables: the contingency table, the joint probability table, and the conditional probability table. What is the probability that respondent is female? [Choose ] What is the probability that a respondent drives an SUV? [Choose ] What is the probability that a respondent is male and drives a minivan? [ Choose ] What is the probability that a female respondent drives either a truck or an SUV? [Choose ] [ Choose ] If it is known that an individual drives a car, what is the probability that the individual is female? If it is known that an individual is male, what is the probability that he drives an SUV? [ Choose ] [ Choose ] Determine whether the random variables "gender" and the event "vehicle driven" are statistically independent. Gender mt no 0009 4 5 6 7 8 Satisfaction with vehicle Yes Yes No No Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes No No Yes Yes No Yes Yes Yes Vehicle Type Driven Truck Domestic Truck Domestic Truck Foreign Truck Domestic SUV Domestic SUV Foreign SUV Domestic SUV Foreign SUV Domestic SUV Domestic SUV Foreign SUV Domestic SUV Foreign SUV Foreign SUV Foreign SUV Domestic SUV Domestic SUV Domestic SUV Domestic Mini Van Domestic Mini Van Domestic Mini Van Domestic Mini Van Foreign Mini Van Foreign Mini Van Domestic Mini Van Domestic Mini Van Foreign Mini Van Foreign Car Domestic Car Domestic Car Domestic Car Foreign Car Domestic Car Domestic Car Domestic Car Domestic Car Domestic Car Foreign Car Foreign Car Domestic Car Domestic Car Foreign Foreign Car Foreign Car Domestic Car Foreign Car Foreign Car Domestic Car Domestic Car Foreign 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 No Male Male Male Male Male Male Male Male Male Male Male Male Female Female Female Male Female Female Male Female Female Female Female Female Male Female Female Female Female Female Female Male Male Female Female Male Male Female Female Female Female Female Male Male Female Female Female Female Female Female Yes Yes Yes Yes No Yes Yes No Yes Yes No No No Yes No Yes Yes Yes Yes Yes Yes Yes No Car Yes No PLEASE clearly label every rell/column in your Put the pivot table (contingency table) here Joint probability table Conditional probability table here