homework

Case3instructions1.docx

Home >Mathematics homework help >Statistics homework help >homework

ADMN 210 – Dr. Barbara Sirotnik

Case #3 of 3, Summer 2019

For the last time you will be dealing with the treadmill data set.

1) Download a clean copy of the file CardioGoodFitness.xlsx to your computer. Remember, don’t try to work on it by just clicking on the file name from Blackboard. You need to save it first.

2) 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?

3) 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

That’s it! Let me know if you have any trouble.