For all of the questions below you will need to use excel file titled “Statistics Example” that is available on the website.
1. First describe the data - what are the variables and the descriptive statistics?
2. Do hypothesis testing comparing the two means on the following:
Your answer should include clearly state hypotheses, calculations, and conclusions.
3. Perform simple Chi2 tests
4. Prepare a scatter plot between BMI and Exercise that includes a trend line. Is there a correlation between the two variables? Explain.
5. Run the following regression
Report your results and explain the meaning of coefficients
Below is the data that you will need for this problem set.
In order to save it on your computer and use it in excel, please open the file, the click on File => Download As => Microsoft Excel (.xlsx) and save it on your computer.