(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.
(10) Which variable do you think should be chosen to be the X variable, and which the Y variable?
Briefly explain your
(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.
(10) If a student studied for 15 hours, what is the predicted score?
If one student studied five hours more than another student,
what is the predicted difference in score?