library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.5
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ ggplot2   3.5.2     ✔ tibble    3.3.0
## ✔ lubridate 1.9.4     ✔ tidyr     1.3.1
## ✔ purrr     1.1.0     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(readxl)
library(tidyverse)
library(lmtest)
## Loading required package: zoo
## 
## Attaching package: 'zoo'
## 
## The following objects are masked from 'package:base':
## 
##     as.Date, as.Date.numeric
library(MASS)
## 
## Attaching package: 'MASS'
## 
## The following object is masked from 'package:dplyr':
## 
##     select
library(readxl)
district<-read_excel("district.xls")
district_data <-district
district_data<-lm(DA0GR21N~DPSTURNR+DPSTTOSA+DPSTADFP,data=district)
plot(district_data,which=1)

raintest(district_data)
## 
##  Rainbow test
## 
## data:  district_data
## Rain = 0.79774, df1 = 539, df2 = 535, p-value = 0.9955
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
durbinWatsonTest(district_data)
##  lag Autocorrelation D-W Statistic p-value
##    1       0.1061114       1.78761    0.01
##  Alternative hypothesis: rho != 0
plot(district_data,which=3)

bptest(district_data)
## 
##  studentized Breusch-Pagan test
## 
## data:  district_data
## BP = 37.448, df = 3, p-value = 3.7e-08
shapiro.test(district_data$residuals)
## 
##  Shapiro-Wilk normality test
## 
## data:  district_data$residuals
## W = 0.55805, p-value < 2.2e-16
district_data_1_robust<-rlm(DA0GR21N~DPSTADFP,data=district)


summary(district_data_1_robust)
## 
## Call: rlm(formula = DA0GR21N ~ DPSTADFP, data = district)
## Residuals:
##      Min       1Q   Median       3Q      Max 
##  -271.82   -71.75   -28.74    98.40 11464.69 
## 
## Coefficients:
##             Value   Std. Error t value
## (Intercept) 30.5710 10.3930     2.9415
## DPSTADFP     3.9803  0.4554     8.7397
## 
## Residual standard error: 111.6 on 1077 degrees of freedom
##   (128 observations deleted due to missingness)
summary(district_data_1_robust)
## 
## Call: rlm(formula = DA0GR21N ~ DPSTADFP, data = district)
## Residuals:
##      Min       1Q   Median       3Q      Max 
##  -271.82   -71.75   -28.74    98.40 11464.69 
## 
## Coefficients:
##             Value   Std. Error t value
## (Intercept) 30.5710 10.3930     2.9415
## DPSTADFP     3.9803  0.4554     8.7397
## 
## Residual standard error: 111.6 on 1077 degrees of freedom
##   (128 observations deleted due to missingness)
kitchen_sink<-lm(DA0GR21N~DPSTURNR+DPSTTOSA+DPSTADFP,data=district)
vif(kitchen_sink)
## DPSTURNR DPSTTOSA DPSTADFP 
## 1.051593 1.188830 1.135042
plot(district_data,which=2)

district_clean<-district %>% drop_na()

district_data_log<-lm(log(DA0GR21N)~log(DPSTADFP),data=district_clean)

plot(district_data_log,which=2)

summary(district_data_log)
## 
## Call:
## lm(formula = log(DA0GR21N) ~ log(DPSTADFP), data = district_clean)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -3.7864 -0.7354 -0.0380  0.7469  3.3715 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)    
## (Intercept)    0.07486    0.75668   0.099    0.921    
## log(DPSTADFP)  1.87755    0.23819   7.883 5.04e-14 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.166 on 321 degrees of freedom
## Multiple R-squared:  0.1622, Adjusted R-squared:  0.1596 
## F-statistic: 62.14 on 1 and 321 DF,  p-value: 5.043e-14
head(district_clean)
## # A tibble: 6 × 137
##   DISTNAME DISTRICT DZCNTYNM REGION DZRATING DZCAMPUS DPETALLC DPETBLAP DPETHISP
##   <chr>    <chr>    <chr>    <chr>  <chr>       <dbl>    <dbl>    <dbl>    <dbl>
## 1 PALESTI… 001907   001 AND… 07     B               6     3360     25.1     42.9
## 2 HUDSON … 003902   003 ANG… 07     A               5     2799      7.2     27.9
## 3 LUFKIN … 003903   003 ANG… 07     B              17     7318     28.7     43.1
## 4 HUNTING… 003904   003 ANG… 07     B               5     1612      2.4      6.6
## 5 ARANSAS… 004901   004 ARA… 02     B               4     3005      1.3     44.1
## 6 PLEASAN… 007905   007 ATA… 20     B               6     3374      0.7     69.6
## # ℹ 128 more variables: DPETWHIP <dbl>, DPETINDP <dbl>, DPETASIP <dbl>,
## #   DPETPCIP <dbl>, DPETTWOP <dbl>, DPETECOP <dbl>, DPETLEPP <dbl>,
## #   DPETSPEP <dbl>, DPETBILP <dbl>, DPETVOCP <dbl>, DPETGIFP <dbl>,
## #   DA0AT21R <dbl>, DA0912DR21R <dbl>, DAGC4X21R <dbl>, DAGC5X20R <dbl>,
## #   DAGC6X19R <dbl>, DA0GR21N <dbl>, DA0GS21N <dbl>, DDA00A001S22R <dbl>,
## #   DDA00A001222R <dbl>, DDA00A001322R <dbl>, DDA00AR01S22R <dbl>,
## #   DDA00AR01222R <dbl>, DDA00AR01322R <dbl>, DDA00AM01S22R <dbl>, …
summary(district_clean)
##    DISTNAME           DISTRICT           DZCNTYNM            REGION         
##  Length:323         Length:323         Length:323         Length:323        
##  Class :character   Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character   Mode  :character  
##                                                                             
##                                                                             
##                                                                             
##    DZRATING            DZCAMPUS         DPETALLC         DPETBLAP    
##  Length:323         Min.   :  1.00   Min.   :   317   Min.   : 0.10  
##  Class :character   1st Qu.:  5.00   1st Qu.:  2580   1st Qu.: 2.20  
##  Mode  :character   Median :  8.00   Median :  5457   Median : 7.30  
##                     Mean   : 19.38   Mean   : 13724   Mean   :10.98  
##                     3rd Qu.: 21.00   3rd Qu.: 15248   3rd Qu.:16.05  
##                     Max.   :273.00   Max.   :193727   Max.   :73.20  
##     DPETHISP        DPETWHIP        DPETINDP         DPETASIP     
##  Min.   : 3.30   Min.   : 0.60   Min.   :0.0000   Min.   : 0.000  
##  1st Qu.:26.25   1st Qu.:19.10   1st Qu.:0.2000   1st Qu.: 0.500  
##  Median :39.90   Median :36.10   Median :0.3000   Median : 1.100  
##  Mean   :43.36   Mean   :38.43   Mean   :0.3845   Mean   : 3.182  
##  3rd Qu.:58.90   3rd Qu.:56.90   3rd Qu.:0.4000   3rd Qu.: 2.850  
##  Max.   :98.90   Max.   :92.90   Max.   :4.2000   Max.   :54.300  
##     DPETPCIP          DPETTWOP         DPETECOP         DPETLEPP    
##  Min.   : 0.0000   Min.   : 0.000   Min.   :  0.20   Min.   : 0.20  
##  1st Qu.: 0.1000   1st Qu.: 2.100   1st Qu.: 42.05   1st Qu.: 5.90  
##  Median : 0.1000   Median : 3.100   Median : 58.60   Median :12.30  
##  Mean   : 0.2328   Mean   : 3.435   Mean   : 56.42   Mean   :15.38  
##  3rd Qu.: 0.2000   3rd Qu.: 4.500   3rd Qu.: 73.90   3rd Qu.:22.10  
##  Max.   :14.5000   Max.   :14.900   Max.   :100.00   Max.   :57.30  
##     DPETSPEP        DPETBILP        DPETVOCP        DPETGIFP     
##  Min.   : 3.90   Min.   : 0.00   Min.   : 8.20   Min.   : 0.000  
##  1st Qu.:10.30   1st Qu.: 5.75   1st Qu.:23.65   1st Qu.: 4.900  
##  Median :12.30   Median :12.40   Median :27.60   Median : 6.500  
##  Mean   :12.07   Mean   :15.52   Mean   :28.16   Mean   : 6.917  
##  3rd Qu.:13.60   3rd Qu.:22.05   3rd Qu.:31.30   3rd Qu.: 8.200  
##  Max.   :17.00   Max.   :69.60   Max.   :82.80   Max.   :24.600  
##     DA0AT21R      DA0912DR21R       DAGC4X21R        DAGC5X20R     
##  Min.   :68.30   Min.   : 0.000   Min.   : 19.50   Min.   : 32.90  
##  1st Qu.:93.75   1st Qu.: 0.300   1st Qu.: 92.30   1st Qu.: 94.60  
##  Median :95.20   Median : 1.000   Median : 95.20   Median : 97.10  
##  Mean   :94.82   Mean   : 1.362   Mean   : 94.02   Mean   : 95.99  
##  3rd Qu.:96.30   3rd Qu.: 1.800   3rd Qu.: 97.65   3rd Qu.: 98.90  
##  Max.   :98.60   Max.   :30.800   Max.   :100.00   Max.   :100.00  
##    DAGC6X19R         DA0GR21N          DA0GS21N      DDA00A001S22R  
##  Min.   : 40.10   Min.   :   17.0   Min.   :   0.0   Min.   :41.00  
##  1st Qu.: 94.45   1st Qu.:  162.5   1st Qu.: 136.5   1st Qu.:69.00  
##  Median : 97.10   Median :  346.0   Median : 301.0   Median :75.00  
##  Mean   : 96.00   Mean   :  918.6   Mean   : 767.7   Mean   :75.22  
##  3rd Qu.: 98.80   3rd Qu.:  993.5   3rd Qu.: 874.5   3rd Qu.:82.00  
##  Max.   :100.00   Max.   :11588.0   Max.   :9607.0   Max.   :97.00  
##  DDA00A001222R   DDA00A001322R   DDA00AR01S22R   DDA00AR01222R  
##  Min.   :12.00   Min.   : 2.00   Min.   :31.00   Min.   :12.00  
##  1st Qu.:40.00   1st Qu.:17.00   1st Qu.:70.00   1st Qu.:45.00  
##  Median :47.00   Median :21.00   Median :75.00   Median :52.00  
##  Mean   :48.35   Mean   :22.97   Mean   :75.85   Mean   :53.06  
##  3rd Qu.:55.00   3rd Qu.:28.00   3rd Qu.:82.00   3rd Qu.:60.00  
##  Max.   :88.00   Max.   :64.00   Max.   :97.00   Max.   :90.00  
##  DDA00AR01322R   DDA00AM01S22R   DDA00AM01222R   DDA00AM01322R   DDA00AC01S22R 
##  Min.   : 1.00   Min.   :29.00   Min.   : 3.00   Min.   : 1.00   Min.   :47.0  
##  1st Qu.:19.00   1st Qu.:67.00   1st Qu.:33.00   1st Qu.:13.00   1st Qu.:70.5  
##  Median :23.00   Median :73.00   Median :41.00   Median :18.00   Median :77.0  
##  Mean   :24.79   Mean   :73.35   Mean   :42.34   Mean   :19.92   Mean   :77.0  
##  3rd Qu.:30.00   3rd Qu.:81.00   3rd Qu.:51.00   3rd Qu.:24.00   3rd Qu.:84.0  
##  Max.   :62.00   Max.   :98.00   Max.   :87.00   Max.   :65.00   Max.   :97.0  
##  DDA00AC01222R   DDA00AC01322R   DDA00AS01S22R   DDA00AS01222R  
##  Min.   : 8.00   Min.   : 1.00   Min.   :51.00   Min.   :23.00  
##  1st Qu.:38.00   1st Qu.:14.00   1st Qu.:69.00   1st Qu.:41.00  
##  Median :48.00   Median :19.00   Median :76.00   Median :49.00  
##  Mean   :48.18   Mean   :20.88   Mean   :75.82   Mean   :49.71  
##  3rd Qu.:57.00   3rd Qu.:26.00   3rd Qu.:82.00   3rd Qu.:57.00  
##  Max.   :86.00   Max.   :56.00   Max.   :98.00   Max.   :91.00  
##  DDA00AS01322R   DDB00A001S22R    DDB00A001222R   DDB00A001322R  
##  Min.   : 5.00   Min.   : -1.00   Min.   :-1.00   Min.   :-1.00  
##  1st Qu.:21.00   1st Qu.: 58.50   1st Qu.:27.50   1st Qu.: 9.00  
##  Median :27.00   Median : 65.00   Median :35.00   Median :13.00  
##  Mean   :29.14   Mean   : 66.04   Mean   :36.94   Mean   :15.05  
##  3rd Qu.:35.00   3rd Qu.: 75.00   3rd Qu.:45.00   3rd Qu.:19.00  
##  Max.   :77.00   Max.   :100.00   Max.   :92.00   Max.   :60.00  
##  DDH00A001S22R   DDH00A001222R   DDH00A001322R   DDW00A001S22R  
##  Min.   :42.00   Min.   :11.00   Min.   : 1.00   Min.   :44.00  
##  1st Qu.:66.00   1st Qu.:36.00   1st Qu.:14.00   1st Qu.:76.00  
##  Median :72.00   Median :42.00   Median :17.00   Median :82.00  
##  Mean   :71.83   Mean   :42.68   Mean   :18.23   Mean   :81.69  
##  3rd Qu.:77.00   3rd Qu.:48.50   3rd Qu.:21.00   3rd Qu.:88.00  
##  Max.   :96.00   Max.   :82.00   Max.   :53.00   Max.   :97.00  
##  DDW00A001222R   DDW00A001322R   DDI00A001S22R    DDI00A001222R   
##  Min.   :20.00   Min.   : 3.00   Min.   : -1.00   Min.   : -1.00  
##  1st Qu.:49.00   1st Qu.:22.00   1st Qu.: 60.00   1st Qu.: 29.50  
##  Median :57.00   Median :28.00   Median : 75.00   Median : 45.00  
##  Mean   :57.14   Mean   :29.22   Mean   : 66.88   Mean   : 42.53  
##  3rd Qu.:66.00   3rd Qu.:35.00   3rd Qu.: 84.00   3rd Qu.: 60.00  
##  Max.   :87.00   Max.   :60.00   Max.   :100.00   Max.   :100.00  
##  DDI00A001322R    DD300A001S22R    DD300A001222R   DD300A001322R   
##  Min.   : -1.00   Min.   : -1.00   Min.   : -1.0   Min.   : -1.00  
##  1st Qu.:  8.00   1st Qu.: 85.50   1st Qu.: 63.0   1st Qu.: 33.00  
##  Median : 17.00   Median : 91.00   Median : 73.0   Median : 44.00  
##  Mean   : 18.92   Mean   : 84.28   Mean   : 67.5   Mean   : 41.67  
##  3rd Qu.: 26.00   3rd Qu.: 96.00   3rd Qu.: 81.0   3rd Qu.: 54.00  
##  Max.   :100.00   Max.   :100.00   Max.   :100.0   Max.   :100.00  
##  DD400A001S22R   DD400A001222R    DD400A001322R   DD200A001S22R   
##  Min.   : -1.0   Min.   : -1.00   Min.   :-1.00   Min.   : -1.00  
##  1st Qu.: -1.0   1st Qu.: -1.00   1st Qu.:-1.00   1st Qu.: 71.00  
##  Median : 67.0   Median : 35.00   Median :11.00   Median : 79.00  
##  Mean   : 50.1   Mean   : 33.16   Mean   :15.65   Mean   : 77.03  
##  3rd Qu.: 84.5   3rd Qu.: 59.00   3rd Qu.:29.00   3rd Qu.: 85.00  
##  Max.   :100.0   Max.   :100.00   Max.   :81.00   Max.   :100.00  
##  DD200A001222R  DD200A001322R   DDE00A001S22R   DDE00A001222R   DDE00A001322R  
##  Min.   :-1.0   Min.   :-1.00   Min.   :40.00   Min.   :12.00   Min.   : 2.00  
##  1st Qu.:42.0   1st Qu.:18.00   1st Qu.:63.00   1st Qu.:33.00   1st Qu.:12.00  
##  Median :50.0   Median :24.00   Median :68.00   Median :38.00   Median :15.00  
##  Mean   :51.2   Mean   :25.74   Mean   :68.51   Mean   :38.88   Mean   :15.94  
##  3rd Qu.:60.0   3rd Qu.:32.00   3rd Qu.:74.00   3rd Qu.:44.00   3rd Qu.:18.50  
##  Max.   :97.0   Max.   :68.00   Max.   :91.00   Max.   :69.00   Max.   :40.00  
##     DA0CT21R         DA0CC21R       DA0CSA21R        DA0CAA21R    
##  Min.   :  0.70   Min.   :-1.00   Min.   :  -1.0   Min.   :-1.00  
##  1st Qu.: 42.25   1st Qu.:20.45   1st Qu.: 944.5   1st Qu.:19.10  
##  Median : 67.00   Median :31.10   Median :1011.0   Median :20.90  
##  Mean   : 64.28   Mean   :33.20   Mean   : 973.6   Mean   :19.81  
##  3rd Qu.: 86.90   3rd Qu.:43.50   3rd Qu.:1065.5   3rd Qu.:23.10  
##  Max.   :100.00   Max.   :88.30   Max.   :1332.0   Max.   :29.00  
##     DPSATOFC          DPSTTOFC          DPSCTOFP        DPSSTOFP    
##  Min.   :   59.5   Min.   :   28.9   Min.   :0.200   Min.   :1.100  
##  1st Qu.:  381.8   1st Qu.:  188.0   1st Qu.:0.900   1st Qu.:2.600  
##  Median :  761.6   Median :  377.4   Median :1.300   Median :2.900  
##  Mean   : 1850.2   Mean   :  918.0   Mean   :1.367   Mean   :3.113  
##  3rd Qu.: 1962.0   3rd Qu.: 1010.4   3rd Qu.:1.700   3rd Qu.:3.400  
##  Max.   :23716.2   Max.   :10619.5   Max.   :4.800   Max.   :7.400  
##     DPSUTOFP         DPSTTOFP        DPSETOFP        DPSXTOFP    
##  Min.   : 2.600   Min.   :38.70   Min.   : 0.00   Min.   : 6.30  
##  1st Qu.: 7.900   1st Qu.:47.10   1st Qu.: 9.75   1st Qu.:20.40  
##  Median : 9.700   Median :50.00   Median :11.50   Median :24.10  
##  Mean   : 9.702   Mean   :50.34   Mean   :12.05   Mean   :23.43  
##  3rd Qu.:11.400   3rd Qu.:53.05   3rd Qu.:13.90   3rd Qu.:27.10  
##  Max.   :23.700   Max.   :68.60   Max.   :23.80   Max.   :38.90  
##     DPSCTOSA         DPSSTOSA         DPSUTOSA        DPSTTOSA    
##  Min.   : 53935   Min.   : 55788   Min.   :36142   Min.   :44144  
##  1st Qu.:105070   1st Qu.: 77254   1st Qu.:63388   1st Qu.:53363  
##  Median :117094   Median : 82343   Median :67480   Median :56808  
##  Mean   :118424   Mean   : 82870   Mean   :67085   Mean   :56964  
##  3rd Qu.:128924   3rd Qu.: 88420   3rd Qu.:71587   3rd Qu.:61180  
##  Max.   :224700   Max.   :107148   Max.   :85603   Max.   :71811  
##     DPSAMIFP        DPSAKIDR         DPSTKIDR        DPST05FP     
##  Min.   : 0.00   Min.   : 4.600   Min.   :-2.00   Min.   :  4.80  
##  1st Qu.:18.95   1st Qu.: 6.600   1st Qu.:13.40   1st Qu.: 27.45  
##  Median :31.80   Median : 7.100   Median :14.30   Median : 33.10  
##  Mean   :37.26   Mean   : 7.297   Mean   :14.38   Mean   : 34.27  
##  3rd Qu.:49.70   3rd Qu.: 7.900   3rd Qu.:15.25   3rd Qu.: 39.45  
##  Max.   :98.30   Max.   :25.200   Max.   :37.30   Max.   :100.00  
##     DPSTEXPA        DPSTADFP        DPSTURNR        DPSTBLFP     
##  Min.   : 0.00   Min.   : 9.50   Min.   : 1.10   Min.   : 0.000  
##  1st Qu.:10.20   1st Qu.:20.05   1st Qu.:15.20   1st Qu.: 1.100  
##  Median :11.40   Median :24.00   Median :18.40   Median : 3.900  
##  Mean   :11.36   Mean   :24.57   Mean   :18.93   Mean   : 7.989  
##  3rd Qu.:12.70   3rd Qu.:28.70   3rd Qu.:22.15   3rd Qu.:10.200  
##  Max.   :17.80   Max.   :65.00   Max.   :37.00   Max.   :80.200  
##     DPSTHIFP        DPSTWHFP         DPSTINFP         DPSTASFP     
##  Min.   : 0.00   Min.   :  1.90   Min.   :0.0000   Min.   : 0.000  
##  1st Qu.: 6.95   1st Qu.: 58.35   1st Qu.:0.0000   1st Qu.: 0.000  
##  Median :13.70   Median : 76.50   Median :0.3000   Median : 0.600  
##  Mean   :19.38   Mean   : 69.71   Mean   :0.3672   Mean   : 1.273  
##  3rd Qu.:23.20   3rd Qu.: 87.20   3rd Qu.:0.5000   3rd Qu.: 1.500  
##  Max.   :97.90   Max.   :100.00   Max.   :3.5000   Max.   :19.100  
##     DPSTPIFP         DPSTTWFP        DPSTREFP        DPSTSPFP     
##  Min.   :0.0000   Min.   :0.000   Min.   :37.60   Min.   : 0.000  
##  1st Qu.:0.0000   1st Qu.:0.400   1st Qu.:66.45   1st Qu.: 7.350  
##  Median :0.0000   Median :1.000   Median :72.70   Median : 9.300  
##  Mean   :0.1675   Mean   :1.109   Mean   :72.09   Mean   : 9.417  
##  3rd Qu.:0.1000   3rd Qu.:1.600   3rd Qu.:77.20   3rd Qu.:11.400  
##  Max.   :7.8000   Max.   :4.900   Max.   :96.30   Max.   :22.800  
##     DPSTCOFP         DPSTBIFP         DPSTVOFP         DPSTGOFP    
##  Min.   : 0.000   Min.   : 0.000   Min.   : 0.000   Min.   : 0.00  
##  1st Qu.: 1.400   1st Qu.: 0.700   1st Qu.: 4.500   1st Qu.: 1.70  
##  Median : 3.400   Median : 2.600   Median : 5.900   Median : 3.80  
##  Mean   : 3.856   Mean   : 4.362   Mean   : 5.923   Mean   : 4.35  
##  3rd Qu.: 5.550   3rd Qu.: 6.050   3rd Qu.: 7.200   3rd Qu.: 6.40  
##  Max.   :16.700   Max.   :42.400   Max.   :19.600   Max.   :30.80  
##     DPFVTOTK          DPFTADPR       DPFRAALLT           DPFRAALLK    
##  Min.   :      0   Min.   :0.000   Min.   :5.963e+06   Min.   : 8923  
##  1st Qu.: 337180   1st Qu.:1.170   1st Qu.:3.339e+07   1st Qu.:12380  
##  Median : 456871   Median :1.275   Median :7.206e+07   Median :13200  
##  Mean   : 562124   Mean   :1.189   Mean   :1.784e+08   Mean   :13806  
##  3rd Qu.: 655840   3rd Qu.:1.369   3rd Qu.:1.933e+08   3rd Qu.:14370  
##  Max.   :8108702   Max.   :1.586   Max.   :2.619e+09   Max.   :65613  
##    DPFRAOPRT           DPFRASTAP        DZRVLOCP       DPFRAFEDP    
##  Min.   :5.937e+06   Min.   : 3.60   Min.   : 0.10   Min.   : 1.50  
##  1st Qu.:3.018e+07   1st Qu.:27.00   1st Qu.:30.75   1st Qu.: 9.55  
##  Median :6.079e+07   Median :43.30   Median :43.40   Median :12.80  
##  Mean   :1.511e+08   Mean   :41.53   Mean   :45.22   Mean   :13.26  
##  3rd Qu.:1.614e+08   3rd Qu.:53.80   3rd Qu.:61.40   3rd Qu.:16.15  
##  Max.   :2.213e+09   Max.   :92.40   Max.   :90.80   Max.   :49.00  
##    DPFRAORVT           DPFUNAB1T            DPFUNA4T        
##  Min.   :  -135790   Min.   :        0   Min.   :        0  
##  1st Qu.:  2844668   1st Qu.:  7372314   1st Qu.:        0  
##  Median :  9614629   Median : 16289265   Median :        0  
##  Mean   : 27257245   Mean   : 38593565   Mean   :  1046271  
##  3rd Qu.: 29362016   3rd Qu.: 42269075   3rd Qu.:        0  
##  Max.   :405596099   Max.   :662450197   Max.   :126144201  
##    DPFEAALLT           DPFEAOPFT           DPFEAOPFK       DPFEAINSP    
##  Min.   :4.849e+06   Min.   :4.183e+06   Min.   : 7884   Min.   :42.00  
##  1st Qu.:3.334e+07   1st Qu.:2.786e+07   1st Qu.:10236   1st Qu.:54.75  
##  Median :7.904e+07   Median :5.643e+07   Median :11001   Median :57.00  
##  Mean   :2.006e+08   Mean   :1.476e+08   Mean   :11125   Mean   :56.72  
##  3rd Qu.:2.167e+08   3rd Qu.:1.564e+08   3rd Qu.:11810   3rd Qu.:58.75  
##  Max.   :2.656e+09   Max.   :2.068e+09   Max.   :19218   Max.   :84.40  
##     DZEXADMP         DZEXADSP         DZEXPLAP        DZEXOTHP    
##  Min.   : 3.200   Min.   : 1.700   Min.   : 4.20   Min.   : 5.90  
##  1st Qu.: 6.100   1st Qu.: 5.100   1st Qu.:10.05   1st Qu.:17.55  
##  Median : 7.300   Median : 5.600   Median :11.00   Median :19.00  
##  Mean   : 7.394   Mean   : 5.727   Mean   :11.37   Mean   :18.76  
##  3rd Qu.: 8.450   3rd Qu.: 6.000   3rd Qu.:12.20   3rd Qu.:20.25  
##  Max.   :14.500   Max.   :13.100   Max.   :29.10   Max.   :25.40  
##    DPFEAINST           DPFEAINSK       DPFPAREGP       DPFPASPEP    
##  Min.   :2.427e+06   Min.   : 3759   Min.   :22.00   Min.   : 2.70  
##  1st Qu.:1.469e+07   1st Qu.: 5806   1st Qu.:38.10   1st Qu.:10.40  
##  Median :3.124e+07   Median : 6222   Median :41.60   Median :12.60  
##  Mean   :8.549e+07   Mean   : 6294   Mean   :41.88   Mean   :12.76  
##  3rd Qu.:9.076e+07   3rd Qu.: 6696   3rd Qu.:45.65   3rd Qu.:15.00  
##  Max.   :1.177e+09   Max.   :11236   Max.   :72.50   Max.   :42.20  
##    DPFPACOMP        DPFPABILP        DPFPAVOCP        DPFPAGIFP     
##  Min.   : 0.100   Min.   :0.0000   Min.   : 0.000   Min.   :0.0000  
##  1st Qu.: 5.450   1st Qu.:0.3000   1st Qu.: 3.000   1st Qu.:0.2000  
##  Median : 8.100   Median :0.8000   Median : 3.800   Median :0.4000  
##  Mean   : 8.253   Mean   :0.9087   Mean   : 3.809   Mean   :0.6972  
##  3rd Qu.:10.450   3rd Qu.:1.3000   3rd Qu.: 4.500   3rd Qu.:0.8000  
##  Max.   :25.600   Max.   :4.4000   Max.   :14.400   Max.   :6.9000  
##    DPFPAATHP       DPFPAHSAP        DPFPREKP        DPFPAOTHP    
##  Min.   :0.000   Min.   :0.000   Min.   :0.0000   Min.   :10.30  
##  1st Qu.:1.700   1st Qu.:0.000   1st Qu.:0.1000   1st Qu.:22.85  
##  Median :2.400   Median :0.000   Median :0.6000   Median :25.40  
##  Mean   :2.445   Mean   :0.191   Mean   :0.7824   Mean   :25.58  
##  3rd Qu.:3.050   3rd Qu.:0.150   3rd Qu.:1.2000   3rd Qu.:27.90  
##  Max.   :7.200   Max.   :2.200   Max.   :6.4000   Max.   :41.70  
##    DISTSIZE           COMMTYPE           PROPWLTH           TAXRATE         
##  Length:323         Length:323         Length:323         Length:323        
##  Class :character   Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character   Mode  :character  
##                                                                             
##                                                                             
##