Econometrics

ECON7020X:

Homework 3

Name: Fill in your name

Due: 11/16/2020 11:59 PM via Blackboard

Instructions:

Use the dataset on California Schools (CASchool) to attempt the questions below.

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)