'Relationship between class performance and test scores'

Explain how you would conduct an empirical analysis on the above topic using the 'caschool'

data set and data description PDF posted with this assignment. You must carefully read the data

description PDF; the answer must include the following.

- Population regression equation

_cons -18.81099 10.67507 -1.76 0.079 -39.78119 2.159201

age -.3258317 .2637932 -1.24 0.217 -.8440291 .1923657

exp .5316884 .1453557 3.66 0.000 .2461505 .8172263

s 2.130208 .2803125 7.60 0.000 1.57956 2.680856

asvabc .263501 .0753906 3.50 0.001 .1154032 .4115988

earnings Coef. Std. Err. t P>|t| [95% Conf. Interval]

Total 114916.961 539 213.20401 Root MSE = 12.962

Adj R-squared = 0.2120

Residual 89883.9509 535 168.007385 R-squared = 0.2178

Model 25033.0104 4 6258.25261 Prob > F = 0.0000

F(4, 535) = 37.25

Source SS df MS Number of obs = 540

. reg earnings asvabc s exp age

- Variables you need to use

- Detailed description of the steps you need to carry out in STATA

- Estimated regression equation

- You do not need to show STATA results

PDF

THE CALIFORNIA TEST SCORE DATA SET

The California Standardized Testing and Reporting (STAR)) dataset contains data

on test performance, school characteristics and student demographic backgrounds. The

data used here are from all 420 K-6 and K-8 districts in California with data available for

1998 and 1999. Test scores are the average of the reading and math scores on the

Stanford 9 standardized test administered to 5th grade students. School characteristics

(averaged across the district) include enrollment, number of teachers (measured as "full-

time-equivalents"), number of computers per classroom, and expenditures per student.

The student-teacher ratio used here is the number of full-time equivalent teachers in the

district, divided by the number of students. Demographic variables for the students also

are averaged across the district. The demographic variables include the percentage of

students in the public assistance program CalWorks (formerly AFDC), the percentage of

students that qualify for a reduced price lunch, and the percentage of students that are

English Learners (that is, students for whom English is a second language). All of these

data were obtained from the California Department of Education (www.cde.ca.gov).

Series in Data Set:

DIST_CODE: DISTRICT CODE;

READ_SCR: AVG READING SCORE;

MATH_SCR: AVG MATH SCORE;

COUNTY : COUNTY;

DISTRICT: DISTRICT;

GR_SPAN: GRADE SPAN OF DISTRICT;

ENRL_TOT : TOTAL ENROLLMENT;

TEACHERS: NUMBER OF TEACHERS;

COMPUTER: NUMBER OF COMPUTERS;

TESTSCR: AVG TEST SCORE (= (READ_SCR+MATH_SCR)/2 );

COMP_STU: COMPUTERS PER STUDENT ( = COMPUTER/ENRL_TOT);

EXPN_STU: EXPENTITURES PER STUDENT ($'S);

STR: STUDENT TEACHER RATIO (ENRL_TOT/TEACHERS);

EL_PCT: PERCENT OF ENGLISH LEARNERS;

MEAL_PCT: PERCENT QUALIFYING FOR REDUCED-PRICE LUNCH;

CALW_PCT: PERCENT QUALIFYING FOR CALWORKS;

AVGINC: DISTRICT AVERAGE INCOME (IN $1000'S);