# 306 HW02.F19 (1).docx - Homework 2 100 points 1(50 points...

• Homework Help
• 2

This preview shows page 1 - 2 out of 2 pages.

Homework 2 100 points 1) (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. c) (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? d)