Ryan Greenberg - ECON306 Homework 2.docx - Homework 2 100...

This preview shows page 1 - 2 out of 5 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture