library(MASS)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.2.1 ✔ readr 2.2.0
## ✔ forcats 1.0.1 ✔ stringr 1.6.0
## ✔ ggplot2 4.0.3 ✔ tibble 3.3.1
## ✔ lubridate 1.9.5 ✔ tidyr 1.3.2
## ✔ purrr 1.2.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ✖ dplyr::select() masks MASS::select()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(dplyr)
library(pastecs)
##
## Attaching package: 'pastecs'
##
## The following objects are masked from 'package:dplyr':
##
## first, last
##
## The following object is masked from 'package:tidyr':
##
## extract
library(lmtest)
## Loading required package: zoo
##
## Attaching package: 'zoo'
##
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
library(car)
## Loading required package: carData
##
## Attaching package: 'car'
##
## The following object is masked from 'package:dplyr':
##
## recode
##
## The following object is masked from 'package:purrr':
##
## some
tea_data <- read.csv("bexar_tea_clean_2025_2026.csv")
comptroller_data <- read.csv("bexar_comptroller_tefa_oct2026.csv")
tea_data
## district_id district_name enrollment_2526 pct_econ_dis
## 1 15915 NORTHSIDE ISD 98333 51.36
## 2 15910 NORTH EAST ISD 53732 51.41
## 3 15907 SAN ANTONIO ISD 42548 86.90
## 4 15916 JUDSON ISD 22620 68.83
## 5 15912 SOUTHWEST ISD 14868 79.53
## 6 15911 EAST CENTRAL ISD 11829 66.49
## 7 15904 HARLANDALE ISD 11114 85.41
## 8 15905 EDGEWOOD ISD 7694 NA
## 9 15908 SOUTH SAN ANTONIO ISD 7084 NA
## 10 15917 SOUTHSIDE ISD 6093 85.80
## 11 15901 ALAMO HEIGHTS ISD 4735 16.52
## 12 15909 SOMERSET ISD 4178 84.80
## 13 15914 FT SAM HOUSTON ISD 1545 22.59
## 14 15906 RANDOLPH FIELD ISD 1405 6.76
## 15 15913 LACKLAND ISD 967 30.40
## sped_unmasked_count pct_sped_lb
## 1 18161 18.47
## 2 9552 17.78
## 3 8482 19.94
## 4 4788 21.17
## 5 3039 20.44
## 6 2148 18.16
## 7 1691 15.22
## 8 1327 17.25
## 9 1256 17.73
## 10 1249 20.50
## 11 720 15.21
## 12 686 16.42
## 13 259 16.76
## 14 93 6.62
## 15 126 13.03
comptroller_data
## district_id district_name tefa_funded_oct2026
## 1 15915 NORTHSIDE ISD 3284
## 2 15910 NORTH EAST ISD 2101
## 3 15907 SAN ANTONIO ISD 1182
## 4 15916 JUDSON ISD 952
## 5 15911 EAST CENTRAL ISD 526
## 6 15912 SOUTHWEST ISD 314
## 7 15908 SOUTH SAN ANTONIO ISD 190
## 8 15905 EDGEWOOD ISD 179
## 9 15904 HARLANDALE ISD 169
## 10 15917 SOUTHSIDE ISD 127
## 11 15914 FT SAM HOUSTON ISD 50
## 12 15901 ALAMO HEIGHTS ISD 49
## 13 15909 SOMERSET ISD 47
## 14 15906 RANDOLPH FIELD ISD NA
## 15 15913 LACKLAND ISD NA
Merging Datasets for Comptroller and TEA data sets
sb2_master <- tea_data %>%
left_join(comptroller_data %>% dplyr::select(district_id, tefa_funded_oct2026), by = "district_id") %>%
mutate(
tefa_pct = round((tefa_funded_oct2026 / enrollment_2526) * 100, 2),
proj_outflow_dollars = tefa_funded_oct2026 * 10474,
proj_loss_per_pupil = round(proj_outflow_dollars / enrollment_2526, 2),
log_enrollment = log(enrollment_2526)
)
sb2_master
## district_id district_name enrollment_2526 pct_econ_dis
## 1 15915 NORTHSIDE ISD 98333 51.36
## 2 15910 NORTH EAST ISD 53732 51.41
## 3 15907 SAN ANTONIO ISD 42548 86.90
## 4 15916 JUDSON ISD 22620 68.83
## 5 15912 SOUTHWEST ISD 14868 79.53
## 6 15911 EAST CENTRAL ISD 11829 66.49
## 7 15904 HARLANDALE ISD 11114 85.41
## 8 15905 EDGEWOOD ISD 7694 NA
## 9 15908 SOUTH SAN ANTONIO ISD 7084 NA
## 10 15917 SOUTHSIDE ISD 6093 85.80
## 11 15901 ALAMO HEIGHTS ISD 4735 16.52
## 12 15909 SOMERSET ISD 4178 84.80
## 13 15914 FT SAM HOUSTON ISD 1545 22.59
## 14 15906 RANDOLPH FIELD ISD 1405 6.76
## 15 15913 LACKLAND ISD 967 30.40
## sped_unmasked_count pct_sped_lb tefa_funded_oct2026 tefa_pct
## 1 18161 18.47 3284 3.34
## 2 9552 17.78 2101 3.91
## 3 8482 19.94 1182 2.78
## 4 4788 21.17 952 4.21
## 5 3039 20.44 314 2.11
## 6 2148 18.16 526 4.45
## 7 1691 15.22 169 1.52
## 8 1327 17.25 179 2.33
## 9 1256 17.73 190 2.68
## 10 1249 20.50 127 2.08
## 11 720 15.21 49 1.03
## 12 686 16.42 47 1.12
## 13 259 16.76 50 3.24
## 14 93 6.62 NA NA
## 15 126 13.03 NA NA
## proj_outflow_dollars proj_loss_per_pupil log_enrollment
## 1 34396616 349.80 11.496115
## 2 22005874 409.55 10.891764
## 3 12380268 290.97 10.658388
## 4 9971248 440.82 10.026590
## 5 3288836 221.20 9.606967
## 6 5509324 465.75 9.378309
## 7 1770106 159.27 9.315961
## 8 1874846 243.68 8.948196
## 9 1990060 280.92 8.865594
## 10 1330198 218.32 8.714896
## 11 513226 108.39 8.462737
## 12 492278 117.83 8.337588
## 13 523700 338.96 7.342779
## 14 NA NA 7.247793
## 15 NA NA 6.874198
Stats for data bases combined and LOG
pastecs::stat.desc(sb2_master %>% dplyr::select(enrollment_2526, pct_econ_dis, pct_sped_lb, tefa_funded_oct2026, tefa_pct, proj_loss_per_pupil))
## enrollment_2526 pct_econ_dis pct_sped_lb tefa_funded_oct2026
## nbr.val 1.500000e+01 13.0000000 15.0000000 1.300000e+01
## nbr.null 0.000000e+00 0.0000000 0.0000000 0.000000e+00
## nbr.na 0.000000e+00 2.0000000 0.0000000 2.000000e+00
## min 9.670000e+02 6.7600000 6.6200000 4.700000e+01
## max 9.833300e+04 86.9000000 21.1700000 3.284000e+03
## range 9.736600e+04 80.1400000 14.5500000 3.237000e+03
## sum 2.887450e+05 736.8000000 254.7000000 9.170000e+03
## median 7.694000e+03 66.4900000 17.7300000 1.900000e+02
## mean 1.924967e+04 56.6769231 16.9800000 7.053846e+02
## SE.mean 6.899427e+03 8.0690231 0.9388245 2.718540e+02
## CI.mean.0.95 1.479780e+04 17.5808911 2.0135783 5.923191e+02
## var 7.140314e+08 846.4187397 13.2208714 9.607601e+05
## std.dev 2.672137e+04 29.0932765 3.6360516 9.801837e+02
## coef.var 1.388147e+00 0.5133179 0.2141373 1.389573e+00
## tefa_pct proj_loss_per_pupil
## nbr.val 13.0000000 1.300000e+01
## nbr.null 0.0000000 0.000000e+00
## nbr.na 2.0000000 2.000000e+00
## min 1.0300000 1.083900e+02
## max 4.4500000 4.657500e+02
## range 3.4200000 3.573600e+02
## sum 34.8000000 3.645460e+03
## median 2.6800000 2.809200e+02
## mean 2.6769231 2.804200e+02
## SE.mean 0.3106535 3.247508e+01
## CI.mean.0.95 0.6768559 7.075712e+01
## var 1.2545731 1.371020e+04
## std.dev 1.1200773 1.170906e+02
## coef.var 0.4184197 4.175542e-01
District Enrollment LOG
hist(sb2_master$enrollment_2526, main = "Raw 2025-2026 District Enrollment", xlab = "Students")
hist(sb2_master$log_enrollment, main = "Log-Transformed District Enrollment", xlab = "Log(Students)")
Correlation & Non-Parametric Robustness Checks
cor.test(sb2_master$pct_sped_lb, sb2_master$tefa_pct, method = "kendall")
##
## Kendall's rank correlation tau
##
## data: sb2_master$pct_sped_lb and sb2_master$tefa_pct
## T = 53, p-value = 0.09998
## alternative hypothesis: true tau is not equal to 0
## sample estimates:
## tau
## 0.3589744
cor.test(sb2_master$enrollment_2526, sb2_master$tefa_pct, method = "kendall")
##
## Kendall's rank correlation tau
##
## data: sb2_master$enrollment_2526 and sb2_master$tefa_pct
## T = 54, p-value = 0.07632
## alternative hypothesis: true tau is not equal to 0
## sample estimates:
## tau
## 0.3846154
cor.test(sb2_master$pct_econ_dis, sb2_master$tefa_pct, method = "kendall")
##
## Kendall's rank correlation tau
##
## data: sb2_master$pct_econ_dis and sb2_master$tefa_pct
## T = 26, p-value = 0.8793
## alternative hypothesis: true tau is not equal to 0
## sample estimates:
## tau
## -0.05454545
OLS Linear Regreassion Models
# Model 1: Predicting Year-1 TEFA Participation Rate (n = 13 unmasked districts)
sb2_model1 <- lm(tefa_pct ~ log_enrollment + pct_sped_lb, data = sb2_master)
summary(sb2_model1)
##
## Call:
## lm(formula = tefa_pct ~ log_enrollment + pct_sped_lb, data = sb2_master)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.08771 -0.81978 -0.05704 0.74787 1.76063
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -3.5773 3.0940 -1.156 0.274
## log_enrollment 0.2935 0.2860 1.026 0.329
## pct_sped_lb 0.1935 0.1671 1.158 0.274
##
## Residual standard error: 1.032 on 10 degrees of freedom
## (2 observations deleted due to missingness)
## Multiple R-squared: 0.2924, Adjusted R-squared: 0.1509
## F-statistic: 2.067 on 2 and 10 DF, p-value: 0.1773
# Model 2: Adding Economically Disadvantaged Share (n = 11 complete districts)
sb2_model2 <- lm(tefa_pct ~ log_enrollment + pct_sped_lb + pct_econ_dis, data = sb2_master)
summary(sb2_model2)
##
## Call:
## lm(formula = tefa_pct ~ log_enrollment + pct_sped_lb + pct_econ_dis,
## data = sb2_master)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.4263 -0.4891 -0.2524 0.5711 1.8420
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -4.52109 3.44281 -1.313 0.231
## log_enrollment 0.33875 0.30940 1.095 0.310
## pct_sped_lb 0.29245 0.19373 1.510 0.175
## pct_econ_dis -0.02044 0.01536 -1.330 0.225
##
## Residual standard error: 1.099 on 7 degrees of freedom
## (4 observations deleted due to missingness)
## Multiple R-squared: 0.4333, Adjusted R-squared: 0.1904
## F-statistic: 1.784 on 3 and 7 DF, p-value: 0.2376
OLS Assumption Checks
# 1. Linearity check (Residuals vs Fitted)
plot(sb2_model1, which = 1)
plot(sb2_model2, which = 1)
Shapiro - Wilk Test
# 2. Normality of residuals check (Q-Q Plot + Shapiro-Wilk test)
plot(sb2_model1, which = 2)
shapiro.test(residuals(sb2_model1))
##
## Shapiro-Wilk normality test
##
## data: residuals(sb2_model1)
## W = 0.90915, p-value = 0.1785
shapiro.test(residuals(sb2_model2))
##
## Shapiro-Wilk normality test
##
## data: residuals(sb2_model2)
## W = 0.97401, p-value = 0.9239
# 3. Homoscedasticity check (Scale-Location Plot + Breusch-Pagan test)
plot(sb2_model1, which = 3)
bptest(sb2_model1)
##
## studentized Breusch-Pagan test
##
## data: sb2_model1
## BP = 1.7799, df = 2, p-value = 0.4107
bptest(sb2_model2)
##
## studentized Breusch-Pagan test
##
## data: sb2_model2
## BP = 1.5611, df = 3, p-value = 0.6682
# 4. Multicollinearity check (Variance Inflation Factors)
vif(sb2_model1)
## log_enrollment pct_sped_lb
## 1.216885 1.216885
vif(sb2_model2)
## log_enrollment pct_sped_lb pct_econ_dis
## 1.211578 1.412382 1.259294
# 5. Independence of errors check (Durbin-Watson test)
durbinWatsonTest(sb2_model1)
## lag Autocorrelation D-W Statistic p-value
## 1 -0.4509952 2.712891 0.378
## Alternative hypothesis: rho != 0
durbinWatsonTest(sb2_model2)
## lag Autocorrelation D-W Statistic p-value
## 1 -0.2080539 2.316344 0.738
## Alternative hypothesis: rho != 0
# 6. Robust regression check (MASS::rlm)
sb2_model1_rlm <- rlm(tefa_pct ~ log_enrollment + pct_sped_lb, data = sb2_master)
summary(sb2_model1_rlm)
##
## Call: rlm(formula = tefa_pct ~ log_enrollment + pct_sped_lb, data = sb2_master)
## Residuals:
## Min 1Q Median 3Q Max
## -1.07449 -0.80805 -0.04474 0.76121 1.77310
##
## Coefficients:
## Value Std. Error t value
## (Intercept) -3.5865 3.3329 -1.0761
## log_enrollment 0.2938 0.3081 0.9536
## pct_sped_lb 0.1932 0.1800 1.0729
##
## Residual standard error: 1.198 on 10 degrees of freedom
## (2 observations deleted due to missingness)