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 162 73 131.35 234.75 156 66.8 112.34 213.51 150 61 102.52 284.94 166.5 61.9 98.82 212.74 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 165 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 S 96.13 115.83 20 146.2 64.8 129.10 161.78Step 1: State the Null Hypothesis, Ho. Step 2: State the Alternative Hypothesis. Ha. Step 3: Set the level of signicance, U. Step 4: Set the criteria for a decision. Find the critical values or set the pvalue. Step 5: Calculate a test statistic. Step 6: Decide whether to reject or fail to reject the null hypothesis and the alternative hypothesis. Step 7: Make a conclusion. Answer the question asked in the