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.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 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