Using the data in the Excel file Consumer Transportation Survey, test the follow
ID: 3132961 • Letter: U
Question
Using the data in the Excel file Consumer Transportation Survey, test the following null hypotheses (significance level of 5%): solve using excel
a. Individuals spend at least 8 hours per week in their vehicles.
b. Individuals drive an average of 600 miles per week.
c. At least 80% of individuals are satisfied with their vehicles.
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 4Explanation / Answer
Given,
5 % significance level
95% confidence level, Z = 1.96
Since sample size > 30 , weuse Z-test
Null hypothesis : Our claim is correct , X= U if calculated Z < 1.96
Alternate hypothesis: Our claim is incorrect , X=! U if calculated Z> 1.96
population (N)= 50
a) Individuals spend at least 8 hours per week in their vehicles.
mean calculated (x) = 8.16
standard deviation (s)= 5.112
Z= (x-U)*sqrt(N)/s
=0.16/5.112 < 1.96
Claim is accepted (NULL)
-----------------------------------------------------------------------------------------------------------------
b. Individuals drive an average of 600 miles per week.
mean = 502
std.dev= 289.22
Z= (502-600)*sqrt(50)/289.22 = 2.399 > 1.96
Claim is rejected (Alternate)
----------------------------------------------------------------------------------------------------------------
c. At least 80% of individuals are satisfied with their vehicles
no of yes = 35 , i.e 70%, P0=0.7
p= 0.8, q= 0.2
s= sqrt(pq)
Z= (P-P0)*sqrt(N)/s
= 1.76 < 1.96
Claim is accepted (NULL)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.