Question: Simple Linear Regression Assignment Research Question : Is there a linear relationship between minutes per week spent exercising and BMI? A cross-sectional survey was given
Simple Linear Regression Assignment
Research Question: Is there a linear relationship between minutes per week spent exercising and BMI?
A cross-sectional survey was given to 15 individuals, in which they were asked their weight, height, and on average how many minutes per week they spent exercising, The results are shown in the table below.
| ID | BMI Score | Exercise (min/wk.) |
| 1 | 42 | 10 |
| 2 | 33 | 25 |
| 3 | 18 | 180 |
| 4 | 22 | 120 |
| 5 | 35 | 30 |
| 6 | 34 | 60 |
| 7 | 22 | 150 |
| 8 | 18.5 | 145 |
| 9 | 17 | 180 |
| 10 | 30 | 70 |
| 11 | 37 | 35 |
| 12 | 38 | 60 |
| 13 | 30 | 80 |
| 14 | 22 | 190 |
| 15 | 33 | 90 |
- What are the dependent and independent variables?
2. What is the mean BMI score among participants?
3. What is the mean mins per week spent exercising among participants?
4.Using excel, what is the correlation coefficient (r) between exercise and BMI score? Interpret the direction and magnitude of correlation coefficient.
5..What is the coefficient of determination (r2) for the relationship between minutes per week exercising and BMI score? Interpret this value.
6. Using the formulas below, estimate and write the simple linear regression equation. Show your work!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
