Econometrics

  

Please make note of the following:

1) Submit the word document with your answers pasted here. 

2) Upload the output file with a .spv extension. 

3) Please add comments on what regression is being run. For example: Regression #1 in table. 

Variable description:

  

observation_number

Observation Number

 

dist_cod

District Code

 

county

County

 

district

District

 

gr_span

Grade span of district 

 

enrl_tot

Total enrollment

 

teachers

Number of Teachers

 

calw_pct

Percentage of students in the public assistance   program, CalWorks

 

meal_pct

Percentage of students that qualify for a   reduced-price lunch

 

computer

Number of computers

 

testscr

Average Test scores (read_scr+math_scr)/2

 

comp_stu

Computer per student

 

expn_stu

Expenditure per student

 

str

Student-Teacher Ratio

 

avginc

Average district income

 

el_pct

Percentage of students that are English Learners

 

read_scr

Average reading score

 

math_scr

Average math score

  

Before starting, ensure you have 420 observations. Do not delete any observations.

The dependent variable for all regressions is testscr. In the Economic Control variables table, Y indicates it was included and N indicates that the variable was not included while running the regression. The numbers reported in the top portion of the table are parameter estimates, while those in brackets are the standard errors. 

Questions:

1. Replicate the regressions in the table on the next page. Report the SER and R-square as well. Please arrange your results in the same format. (7 regression x 1=7 points)

2. For Model 6, run and interpret the hypothesis tests in the lower portion of the table. (3 tests x 1 point = 3 points)