Administration Case Study
1) Is there a relationship between product (level of treadmill) and gender? Test at the 5% level of significance, and show all 6 steps of the hypothesis testing procedure. In step 6, be sure to indicate why the company would want to know if there is such a relationship! HINT: first make a pivot table with product in the rows and gender in the columns. Those are your observed frequencies. Then find the expected frequencies and your chi-square. NOTE: do you understand why this is chapter 12 material and not chapter 13 material?
2) Is there a relationship between a person’s age and the number of miles they intend to walk/run on the treadmill each week? And can you predict the number of miles a 27-year-old would walk/run? Here’s what I’d like you to do.
· First form a scatter diagram. Does there seem to be a linear relationship between age and miles?
· Now run the regression procedure that can use age as a predictor of miles. Remember, all of this is to be done using Excel…no hand calculations are necessary!
· Interpret the correlation coefficient and the coefficient of determination in practical form.
· Predict the number of miles a 27-year-old would walk/run
· Interpret the slope
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
