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)