Econ 107 Lab Exercise 1: Basic Regression Analysis

Dataset

Go to Stock and Watson textbook data website

http://wps.aw.com/aw_stock_ie_3/178/45691/11696965.cw/

\( \rightarrow \) Replication Files

\( \rightarrow \) Datasets for Replicating Empirical Results

\( \rightarrow \) Download California Test Score Data in Stata format.

Also, you can download the data discription to understand the meanings of all the variables in dataset.

Question Part

How are school characteristics related to test scores?

Run 6 regressions. For each regression, your dependent variable will be the test score in a district (y-variable). In your first regression, regress test score on the student-teacher ratio in the district. Repeat this process 5 more times using percent of English learners, computers per student, expenditures per student, average income and any other variable of your choice as your x-variable. Use the outreg2 command to create a table of results that includes the coefficient values, the \( R^2 \) value, number of observations and the mean of your X-variable.

mean Variable 1 Variable 2 ......

Question Part

After you create your table. Create a word document that has your table at the top. Explain what your table is showing. This means interpreting at least two regression results in detail. Considering the means of the x-and y-variables, which x-variables affect the test score most?

Email subject: 

Econ 107+Assignment name+your name+your student id

Email: Name+ID of all the group members

Assignment email: econ107lab@gmail.com