Compare your preferred simple linear regression model

Perform certain calculations discussed in the assigned reading in order to derive an answer for each problem.use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.have each worksheet be clearly labeled to identify the associated problem.to show all calculations or other work performed to derive your answer(s) for each problem.have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.No credit will be granted for problems that are not completed using Excel, for which your Excel worksheet is not fully functional, or for which you have not shown all of the calculations or other work performed to derive your answer(s). You may refer to the course textbooks, supplemental reading materials, online information, and your own notes in conjunction with completing the homework assignments. Once you have completed the necessary calculations to solve each problem and answer the associated questions, select the hyperlink provided to submit your Excel spreadsheet for grading.A college Admissions Officer is interested in determining the extent to which a prospective student’s high school GPA and/or SAT score can be used as a basis for predicting his or her college freshman GPA. He believes that prospective students who have higher high school GPAs and SAT scores will have a higher college freshman GPA. He randomly selected fifty students who recently completed their freshman year and collected the information reflected in the following table.Student No.College Freshman GPAHigh School GPASAT Score12.613.2697822.402.9290532.953.52112543.343.88128053.403.86131363.563.95138372.592.82101483.093.29121793.683.841458102.912.971157112.483.091238122.342.85856132.382.84880142.583.00959152.703.061011162.542.82959172.893.141100183.023.211156193.333.461282203.163.231227212.603.251266222.653.231291233.273.891168242.893.361041252.913.311060262.853.161044273.653.971350283.543.771319293.833.991436303.053.111150313.153.941498322.352.861117333.063.651458343.253.781134353.493.971230363.023.361075372.913.161043383.483.701258393.093.221128403.663.731343412.312.891069422.493.041154432.422.881122442.783.231292452.983.381015463.073.411058472.993.251039483.743.981314492.732.85969503.023.081077Perform a simple linear regression with a 95% confidence level using college freshman GPA as the dependent variable and high school GPA as the independent variable.Evaluate the statistical significance of the regression model.Perform a simple linear regression with a 95% confidence using college freshman GPA as the dependent variable and SAT score as the independent variable.Evaluate the statistical significance of the regression model.Compare the two simple linear regression models and select your preferred simple regression model.Explain the basis for selecting your preferred model.Perform a multiple linear regression with a 95% confidence using college freshman GPA as the dependent variable and high school GPA and SAT score as the independent variables.Evaluate the statistical significance of the regression model as a whole.Evaluate the statistical significance of the linear relationship between the dependent variable and each independent variable.Discuss the extent to which there is evidence of multicollinearity between the independent variables.Compare your preferred simple linear regression model (i.e., the regression model you selected in step 3) to the multiple linear regression model and discuss whether the simple regression model or multiple regression model would be your overall preferred regression model, including discussing the basis for why it would be your preferred model.Discuss the contribution of each independent variable for your overall preferred regression model (i.e., the model you selected in step 5) to predicting the value of the dependent variable.Discuss the range of values for the independent variable(s) for your preferred regression model (i.e., the regression model you selected in step 5) for which the regression model is valid.Discuss the p-value for the coefficient for the y-intercept for your overall preferred regression model. Explain why a p-value that is not less than or equal to α = 0.05 would not be cause for rejecting the regression model. (Hint: Consider the range of values for the independent variables associated with the given data set.)Identify the regression equation associated with your overall preferred regression model and associated degree of error associated with using the model to predict a student’s college freshman GPA.Calculate the predicted college freshman GPA for a student with a high school GPA of 3.25 and an SAT score of 1115 using your overall preferred regression model.Identify the lower and upper limits associated with a 95% confidence level interval estimate for the predicted college freshman GPA for a student with a high school GPA of 3.25 and an SAT score of 1115 using your overall preferred regression model.