Question: Using the data in the Excel file consumer transportation Survey.xls, test the following hypothesis:

a) Individuals spend at least 10 hrs per week in their vehicles

b) Individuals drive an average of 450 miles per week

c) The average age of SUV drivers is no greater than 35

d) At least 75% of individuals are satisfied with their vehicles

e) The percentage of males who are satisfied with their is the same as the percentage of females