View the step-by-step solution to:

# Consumer Transportation Survey Vehicle Driven Truck Truck Truck Truck SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV Mini Van Mini Van

Refer to the data in the Excel file “Consumer Transportation Survey” that is posted on our course’s Moodle page.
a) Create a table with the values in a probability mass function and cumulative distribution function for the variables “Satisfaction with Vehicle” and “Number of Children”.
b) Using Excel, graph your results from the tables in part (a) above. Hint: Refer to the online session “Excel Session 1” posted on Moodle.

c) What is the probability that an individual from this survey is not satisfied with the vehicle?
d) What is the probability that an individual from this survey has less than two children?
e) What is the probability that an individual from this survey has at least two children?
f) What is the probability that an individual from this survey has five or more children?
Consumer Transportation Survey Vehicle Driven Type Satisfaction with vehicle Gender Age # of hours per week in vehicle Miles driven per week Number of Children Average number of riders Miles from work Truck Domestic Yes Male 31 10 450 0 1 30 Truck Domestic Yes Male 29 5 370 1 1 22 Truck Foreign No Male 26 12 580 0 1 15 Truck Domestic No Male 18 6 300 0 1 20 SUV Domestic Yes Male 49 21 1000 0 1 22 SUV Foreign Yes Male 50 16 840 2 1 45 SUV Domestic Yes Male 48 15 1400 3 4 25 SUV Foreign Yes Male 45 5 300 2 2 20 SUV Domestic Yes Male 45 15 850 0 1 25 SUV Domestic Yes Male 44 10 700 2 1 40 SUV Foreign Yes Male 41 5 350 1 1 20 SUV Domestic Yes Male 41 30 1500 4 3 15 SUV Foreign No Female 39 6 280 1 1 17 SUV Foreign Yes Female 36 4 400 0 1 20 SUV Foreign Yes Female 33 3 420 0 1 25 SUV Domestic Yes Male 31 10 675 0 1 35 SUV Domestic No Female 31 15 800 1 1 50 SUV Domestic No Female 29 4 300 1 1 20 SUV Domestic Yes Male 28 3 400 1 1 15 Mini Van Domestic Yes Female 55 8 400 0 2 0 Mini Van Domestic No Female 43 10 700 2 3 0 Mini Van Domestic Yes Female 41 10 720 1 2 15 Mini Van Foreign Yes Female 38 10 450 4 5 0 Mini Van Foreign Yes Female 39 15 1000 1 2 0 Mini Van Domestic No Male 35 5 350 2 2 0 Mini Van Domestic Yes Female 33 10 800 2 3 0 Mini Van Foreign Yes Female 32 2 200 4 5 5 Mini Van Foreign Yes Female 28 8 350 3 4 0 Car Domestic Yes Female 21 4 150 0 1 0 Car Domestic No Female 62 5 175 0 2 0 Car Domestic Yes Female 61 5 355 0 1 15 Car Foreign Yes Male 60 5 150 0 1 10 Car Domestic No Male 58 10 600 0 1 35 Car Domestic Yes Female 51 11 600 0 1 40 Car Domestic Yes Female 47 4 300 0 1 21 Car Domestic No Male 46 4 275 0 1 18 Car Domestic No Male 44 6 285 2 3 16 Car Foreign No Female 42 5 400 2 3 22 Car Foreign Yes Female 41 5 350 2 2 23 Car Domestic No Female 41 10 600 1 2 34 Car Domestic Yes Female 39 10 700 1 2 45 Car Foreign Yes Female 34 10 600 1 2 16 Car Foreign Yes Male 33 5 400 1 2 22 Car Foreign Yes Male 30 5 350 1 2 18 Car Domestic Yes Female 29 5 250 0 1 19 Car Foreign Yes Female 27 6 355 0 2 23 Car Foreign Yes Female 26 5 175 0 1 11 Car Domestic No Female 24 5 300 0 1 4 Car Domestic Yes Female 22 5 350 0 1 3 Car Foreign No Female 19 5 500 0 2 4

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question