Wooldridge Source: Leslie Papke, an economics professor at MSU, collected these data from Michigan Department of Education web site, www.michigan.gov/mde. These are district-level data, which Professor Papke kindly provided. She has used building-level data in “The Effects of Spending on Test Pass Rates: Evidence from Michigan” (2005), Journal of Public Economics 89, 821-839. Data loads lazily.
data('mathpnl')A data.frame with 3850 observations on 52 variables:
distid: district identifier
intid: intermediate school district
lunch: percent eligible for free lunch
enrol: school enrollment
ptr: pupil/teacher: 1995-98
found: foundation grant, $: 1995-98
expp: expenditure per pupil
revpp: revenue per pupil
avgsal: average teacher salary
drop: high school dropout rate, percent
grad: high school grad. rate, percent
math4: percent satisfactory, 4th grade math
math7: percent satisfactory, 7th grade math
choice: number choice students
psa: # public school academy studs.
year: 1992-1998
staff: staff per 1000 students
avgben: avg teacher fringe benefits
y92: =1 if year == 1992
y93: =1 if year == 1993
y94: =1 if year == 1994
y95: =1 if year == 1995
y96: =1 if year == 1996
y97: =1 if year == 1997
y98: =1 if year == 1998
lexpp: log(expp)
lfound: log(found)
lexpp_1: lexpp[_n-1]
lfnd_1: lfnd[_n-1]
lenrol: log(enrol)
lenrolsq: lenrol^2
lunchsq: lunch^2
lfndsq: lfnd^2
math4_1: math4[_n-1]
cmath4: math4 - math4_1
gexpp: lexpp - lexpp_1
gexpp_1: gexpp[_n-1
gfound: lfound - lfnd_1
gfnd_1: gfound[_n-1]
clunch: lunch - lunch[_n-1]
clnchsq: lunchsq - lunchsq[_n-1]
genrol: lenrol - lenrol[_n-1]
genrolsq: genrol^2
expp92: expp in 1992
lexpp92: log(expp92)
math4_92: math4 in 1992
cpi: consumer price index
rexpp: real spending per pupil, 1997$
lrexpp: log(rexpp)
lrexpp_1: lrexpp[_n-1]
grexpp: lrexpp - lrexpp_1
grexpp_1: grexpp[_n-1]
https://www.cengage.com/cgi-wadsworth/course_products_wp.pl?fid=M20b&product_isbn_issn=9781111531041
pages 479-480, 505-506
str(mathpnl)
#> 'data.frame': 3850 obs. of 52 variables:
#> $ distid : num 1010 1010 1010 1010 1010 1010 1010 2010 2010 2010 ...
#> $ intid : int 4 4 4 4 4 4 4 52 52 52 ...
#> $ lunch : num 36.3 39.2 38.6 37.4 40.8 ...
#> $ enrol : num 1089 1100 1011 995 1008 ...
#> $ ptr : num NA NA NA 20.4 19.1 ...
#> $ found : int NA NA NA 5245 5398 5553 5707 NA NA NA ...
#> $ expp : int 4227 4809 5214 6019 6155 6134 6476 3445 3446 3583 ...
#> $ revpp : int NA NA NA 7186 7374 6859 7094 NA NA NA ...
#> $ avgsal : num 31854 34361 32351 44852 46603 ...
#> $ drop : num 7 10.1 12.3 1.73 7.37 ...
#> $ grad : num 75.2 64.7 58.6 94.8 77.4 ...
#> $ math4 : num 28.8 32.3 39.1 68 68.4 ...
#> $ math7 : num 43.4 49.3 36.5 54.7 55.4 ...
#> $ choice : int NA NA NA NA NA 0 0 NA NA NA ...
#> $ psa : int NA NA NA 0 0 NA NA NA NA NA ...
#> $ year : int 1992 1993 1994 1995 1996 1997 1998 1992 1993 1994 ...
#> $ staff : num 101.2 99.7 110.8 NA NA ...
#> $ avgben : int 6098 8532 9983 NA NA NA NA 6042 7136 6276 ...
#> $ y92 : int 1 0 0 0 0 0 0 1 0 0 ...
#> $ y93 : int 0 1 0 0 0 0 0 0 1 0 ...
#> $ y94 : int 0 0 1 0 0 0 0 0 0 1 ...
#> $ y95 : int 0 0 0 1 0 0 0 0 0 0 ...
#> $ y96 : int 0 0 0 0 1 0 0 0 0 0 ...
#> $ y97 : int 0 0 0 0 0 1 0 0 0 0 ...
#> $ y98 : int 0 0 0 0 0 0 1 0 0 0 ...
#> $ lexpp : num 8.35 8.48 8.56 8.7 8.73 ...
#> $ lfound : num NA NA NA 8.57 8.59 ...
#> $ lexpp_1 : num NA 8.35 8.48 8.56 8.7 ...
#> $ lfnd_1 : num NA NA NA NA 8.57 ...
#> $ lenrol : num 6.99 7 6.92 6.9 6.92 ...
#> $ lenrolsq: num 48.9 49 47.9 47.6 47.8 ...
#> $ lunchsq : num 1318 1537 1490 1400 1664 ...
#> $ lfndsq : num NA NA NA 73.4 73.9 ...
#> $ math4_1 : num NA 28.8 32.3 39.1 68 ...
#> $ cmath4 : num NA 3.5 6.8 28.9 0.4 ...
#> $ gexpp : num NA 0.129 0.0809 0.1436 0.0223 ...
#> $ gexpp_1 : num NA NA 0.129 0.0809 0.1436 ...
#> $ gfound : num NA NA NA NA 0.0288 ...
#> $ gfnd_1 : num NA NA NA NA NA ...
#> $ clunch : num NA 2.9 -0.6 -1.19 3.38 ...
#> $ clnchsq : num NA 219 -46.7 -90.5 264.3 ...
#> $ genrol : num NA 0.0101 -0.0844 -0.016 0.013 ...
#> $ genrolsq: num NA 0.141 -1.175 -0.22 0.179 ...
#> $ expp92 : int NA 4227 4227 4227 4227 4227 4227 NA 3445 3445 ...
#> $ lexpp92 : num NA 8.35 8.35 8.35 8.35 ...
#> $ math4_92: num NA 28.8 28.8 28.8 28.8 ...
#> $ cpi : num 1.4 1.45 1.48 1.52 1.57 ...
#> $ rexpp : num 4836 5341 5647 6339 6296 ...
#> $ lrexpp : num 8.48 8.58 8.64 8.75 8.75 ...
#> $ lrexpp_1: num NA 8.48 8.58 8.64 8.75 ...
#> $ grexpp : num NA 0.0995 0.05558 0.11563 -0.00676 ...
#> $ grexpp_1: num NA NA 0.0995 0.0556 0.1156 ...
#> - attr(*, "time.stamp")= chr "25 Jun 2011 23:03"