Homework 2100 points1)(50 points) The file SAT.Study.xls contains 20 randomly selected observations of students. Each student reported the time spent Studying for the SAT math exam, and the Score on that exam.a)(10) Which variable do you think should be chosen to be the X variable, and which the Y variable? Briefly explain your reasoning.
b)(20) Regardless of your choice in part a, let Studying be the X variable, and SAT Score be the Y-variable. Calculate the slope and intercept estimators for a linear regression using EXCEL (or Google Spreadsheet). Do this calculation using the “by hand” method that was demonstrated in the lectures. Report your Betahats. Print your spreadsheet and be sure to indicate the intermediate calculations you used on your way to getting your answers.
See spreadsheet below for my work