This is ANOVA

GROUP ACTIVITY with a maximum of 6 members.

Solve the given problem. Show solutions if solved manually or show the Excel computation results.

Researchers would like to determine if the height and weight of elders can predict their glucose and cholesterol levels. They gather these information from 20 elders and data are as follows.

Elders Height Weight Glucose Cholesterol

1 143.5 45.6 127.21 148.65

2 158 43 86.13 199.23

3 161 75.2 143.87 220.08

4 157.5 70.5 140.90 152.12

5 162 73 131.35 234.75

6 156 66.8 112.34 213.51

7 150 61 102.52 284.94

8 166.5 61.9 98.82 212.74

9 154.2 52.4 75.50 233.98

10 162 68.4 125.60 147.49

11 151 57.6 81.26 121.24

12 166 57.5 75.86 220.85

13 146.3 53.4 90.09 173.36

14 165 55.7 75.50 258.30

15 154 58.2 80.72 196.91

16 143.1 53.8 118.02 178.76

17 158 57 93.51 125.10

18 157 66.5 125.05 133.20

19 146.2 42.3 96.13 115.83

20 146.2 64.8 129.10 161.78

Questions:

1. What is the degree of relationship of the height, weight, glucose and cholesterol levels of the elders.

2. Which of the independent variables can significantly predict the glucose level of the elders?

3. Which of the independent factors have a significant effect on the cholesterol level of the elders?

4. What is the linear regression equation in predicting the glucose level?

5. What is the linear regression equation in predicting the cholesterol level?

6. Please explain in the predicting capability of the predictors to the glucose and cholesterol level.