Important Instruction (Read carefully): Please answer the following question using the information in "Lectures 7,9,11_Combined_Spring 2023" excel file. Note that this excel file is created combining excel files of Lectures 7,9 and 11. Please Type your answers inside the green textbox if applicable. Problem Set \#1. Go to Lecture 7- Student Survey Worksheet [9 points] To solve questions in this problem you need to use regression results estimated using weight (dependent variable) and height (independent variable). Using the estimated regression equations, please provide answers to the following four questions. i. Which one is the estimated regression equation? [ 3 points] a. y^=153.98+16.95x b. y^=153+16.95x c. y^=45.35+37.64x ii. If a student has a height of 5.95 feet, what would be the predicted weight? [2 points] iii. Is it appropriate to use our regression equation to predict the weight of 2.5 feet tall person? Explain in a few sentences [ 2 points] iv. What value of R2 is obtained after "height-weight" regression analysis? Please explain its meaning. [2 points] Important Instruction (Read carefully): Please answer the following question using the information in "Lectures 7,9,11_Combined_Spring 2023" excel file. Note that this excel file is created combining excel files of Lectures 7,9 and 11. Please Type your answers inside the green textbox if applicable. Problem Set \#1. Go to Lecture 7- Student Survey Worksheet [9 points] To solve questions in this problem you need to use regression results estimated using weight (dependent variable) and height (independent variable). Using the estimated regression equations, please provide answers to the following four questions. i. Which one is the estimated regression equation? [ 3 points] a. y^=153.98+16.95x b. y^=153+16.95x c. y^=45.35+37.64x ii. If a student has a height of 5.95 feet, what would be the predicted weight? [2 points] iii. Is it appropriate to use our regression equation to predict the weight of 2.5 feet tall person? Explain in a few sentences [ 2 points] iv. What value of R2 is obtained after "height-weight" regression analysis? Please explain its meaning. [2 points]