Excel 3 | Numerical analysis homework help
1. Using the data in the Excel file Consumer Transportation Survey, develop a contingency table for Gender and Vehicle Driven; then convert this table into probabilities.
a. What is the probability that respondent is female?
b. What is the probability that a respondent drives an SUV?
c. What is the probability that a respondent is male and drives a minivan?
d. What is the probability that a female respondent drives either a truck or an SUV?
e. If it is known that an individual drives a car, what is the probability that the individual is female?
f. If it is known that an individual is male, what is the probability that he drives an SUV?
g. Determine whether the random variables “gender” and the event “vehicle driven” are statistically independent. What would this mean for advertisers?
How it Works
1
It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.
2
Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.
3
After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.
4
Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!