Mathematics In the Modern World

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 1-2 sentences the predicting capability of the predictors to the glucose and cholesterol level.B C D G H Elders Height Weight Glucose Cholesterol 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.9 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.5 233.98 10 162 68.4 125.6 147.49 11 151 57.6 81.26 121.24 13 12 166 57.5 75.86 220.85 13 146.3 53.4 90.09 173.36 15 14 165 55.7 75.5 258.3 15 154 58.2 80.72 196.91 17 16 143.1 53.8 118.02 178.76 18 17 158 57 93.51 125.1 19 18 157 66.5 125.05 133.2 20 19 146.2 42.3 96.13 115.83 21 20 146.2 64.8 129.1 161.78 22 23 24 25 SUMMARY OUTPUT 26 27 Regression Statistics 28 Multiple R 0. 453592475 29 R Square 0.205746133 30 Adjusted R Squa 0. 056823533 31 Standard Error 46.87737476 32 Observations 20 33 34 ANOVA 35 df SS MS F Significance F 136 Regression 3 9107.913352 3035.971117 1381564201 0.284386896 37 Residual 16 35159.81223 2197.488264 38 Total 19 44267.72558 39 40 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 41 Intercept -11.89722162 270. 1609957 -0.044037525 0.965419411 -584.612948 560.8185048 42 Height 1 162795677 1.904351098 0.610599421 0.550040734 -2.874248308 5.199839662 43 Weight 1.731052618 1896425118 0.91279777 0.37489849 -2.289189039 5.751294275 44 Glucose 0. 800470677 0.68991217 -1 160250119 0.262967467 -2.263019142 0.662077788 45