Rough Draft - Data Manipulation
2024-11-08
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.1 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── 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 errorslibrary(dplyr)
library(readxl)
data <- read_excel("~/Desktop/grad school/Research II/data selection/district.xls")
head(data)## # A tibble: 6 × 137
## DISTNAME DISTRICT DZCNTYNM REGION DZRATING DZCAMPUS DPETALLC DPETBLAP DPETHISP
## <chr> <chr> <chr> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 CAYUGA … 001902 001 AND… 07 A 3 574 4.4 11.5
## 2 ELKHART… 001903 001 AND… 07 A 4 1150 4 11.8
## 3 FRANKST… 001904 001 AND… 07 A 3 808 8.5 11.3
## 4 NECHES … 001906 001 AND… 07 A 2 342 8.2 13.5
## 5 PALESTI… 001907 001 AND… 07 B 6 3360 25.1 42.9
## 6 WESTWOO… 001908 001 AND… 07 B 4 1332 19.7 26.2
## # ℹ 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>, …#(also by the time i turn this in to help keep the document from being a million lines long, i am deleting all my "errored" or incorrect codes/data sets/objects)Cleaning the data up
#Clean up (first by checkign for NA's)
summary(data)## DISTNAME DISTRICT DZCNTYNM REGION
## Length:1207 Length:1207 Length:1207 Length:1207
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## DZRATING DZCAMPUS DPETALLC DPETBLAP
## Length:1207 Min. : 1.000 Min. : 4.0 Min. : 0.000
## Class :character 1st Qu.: 2.000 1st Qu.: 337.5 1st Qu.: 0.700
## Mode :character Median : 3.000 Median : 884.0 Median : 2.900
## Mean : 7.428 Mean : 4476.3 Mean : 8.765
## 3rd Qu.: 5.000 3rd Qu.: 2746.0 3rd Qu.:10.750
## Max. :273.000 Max. :193727.0 Max. :98.100
##
## DPETHISP DPETWHIP DPETINDP DPETASIP
## Min. : 0.00 Min. : 0.00 Min. : 0.0000 Min. : 0.000
## 1st Qu.: 21.00 1st Qu.:18.55 1st Qu.: 0.0000 1st Qu.: 0.000
## Median : 37.90 Median :44.40 Median : 0.2000 Median : 0.400
## Mean : 43.29 Mean :43.15 Mean : 0.3283 Mean : 1.614
## 3rd Qu.: 61.90 3rd Qu.:67.75 3rd Qu.: 0.4000 3rd Qu.: 1.000
## Max. :100.00 Max. :97.10 Max. :19.8000 Max. :54.300
##
## DPETPCIP DPETTWOP DPETECOP DPETLEPP
## Min. : 0.0000 Min. : 0.000 Min. : 0.00 Min. : 0.00
## 1st Qu.: 0.0000 1st Qu.: 1.200 1st Qu.: 47.95 1st Qu.: 2.90
## Median : 0.0000 Median : 2.400 Median : 61.90 Median : 7.50
## Mean : 0.1005 Mean : 2.758 Mean : 60.75 Mean : 12.69
## 3rd Qu.: 0.1000 3rd Qu.: 3.900 3rd Qu.: 77.15 3rd Qu.: 17.00
## Max. :14.5000 Max. :15.000 Max. :100.00 Max. :100.00
##
## DPETSPEP DPETBILP DPETVOCP DPETGIFP
## Min. : 0.00 Min. : 0.00 Min. : 0.00 Min. : 0.000
## 1st Qu.: 9.90 1st Qu.: 2.90 1st Qu.:23.00 1st Qu.: 3.100
## Median :12.10 Median : 7.30 Median :27.80 Median : 5.400
## Mean :12.27 Mean : 12.58 Mean :26.47 Mean : 5.574
## 3rd Qu.:14.20 3rd Qu.: 16.80 3rd Qu.:32.90 3rd Qu.: 7.500
## Max. :51.70 Max. :100.00 Max. :82.80 Max. :100.000
##
## DA0AT21R DA0912DR21R DAGC4X21R DAGC5X20R
## Min. : -1.00 Min. :-1.000 Min. : -1.00 Min. : -1.00
## 1st Qu.: 94.05 1st Qu.: 0.000 1st Qu.: 93.20 1st Qu.: 95.50
## Median : 95.40 Median : 0.400 Median : 96.90 Median : 98.30
## Mean : 94.76 Mean : 1.243 Mean : 93.91 Mean : 95.76
## 3rd Qu.: 96.40 3rd Qu.: 1.400 3rd Qu.:100.00 3rd Qu.:100.00
## Max. :100.00 Max. :50.500 Max. :100.00 Max. :100.00
## NA's :4 NA's :112 NA's :133 NA's :141
## DAGC6X19R DA0GR21N DA0GS21N DDA00A001S22R
## Min. : -1.00 Min. : 1.0 Min. : 0.0 Min. : 4.00
## 1st Qu.: 95.20 1st Qu.: 29.0 1st Qu.: 26.0 1st Qu.: 68.00
## Median : 98.20 Median : 69.0 Median : 61.0 Median : 76.00
## Mean : 95.72 Mean : 331.6 Mean : 278.9 Mean : 74.77
## 3rd Qu.:100.00 3rd Qu.: 208.0 3rd Qu.: 167.0 3rd Qu.: 83.00
## Max. :100.00 Max. :11588.0 Max. :9607.0 Max. :100.00
## NA's :149 NA's :126 NA's :126 NA's :5
## DDA00A001222R DDA00A001322R DDA00AR01S22R DDA00AR01222R
## Min. : 0.00 Min. : 0.00 Min. : -1.00 Min. : -1.00
## 1st Qu.:37.00 1st Qu.:15.00 1st Qu.: 70.00 1st Qu.: 43.00
## Median :46.00 Median :20.00 Median : 77.00 Median : 52.00
## Mean :46.48 Mean :21.05 Mean : 76.22 Mean : 52.12
## 3rd Qu.:55.00 3rd Qu.:26.00 3rd Qu.: 84.00 3rd Qu.: 61.00
## Max. :88.00 Max. :64.00 Max. :100.00 Max. :100.00
## NA's :5 NA's :5 NA's :5 NA's :5
## DDA00AR01322R DDA00AM01S22R DDA00AM01222R DDA00AM01322R
## Min. :-1.00 Min. : -1.00 Min. :-1.00 Min. :-1.00
## 1st Qu.:17.00 1st Qu.: 66.00 1st Qu.:30.00 1st Qu.:11.00
## Median :22.00 Median : 74.00 Median :40.00 Median :17.00
## Mean :23.64 Mean : 72.78 Mean :40.51 Mean :18.21
## 3rd Qu.:29.00 3rd Qu.: 82.00 3rd Qu.:50.00 3rd Qu.:23.00
## Max. :66.00 Max. :100.00 Max. :91.00 Max. :65.00
## NA's :5 NA's :5 NA's :5 NA's :5
## DDA00AC01S22R DDA00AC01222R DDA00AC01322R DDA00AS01S22R
## Min. : -1.00 Min. : -1.00 Min. :-1.00 Min. : -1.00
## 1st Qu.: 68.00 1st Qu.: 34.00 1st Qu.:10.00 1st Qu.: 66.00
## Median : 77.00 Median : 44.00 Median :16.00 Median : 75.00
## Mean : 75.04 Mean : 44.29 Mean :17.39 Mean : 73.09
## 3rd Qu.: 85.00 3rd Qu.: 55.00 3rd Qu.:23.00 3rd Qu.: 83.00
## Max. :100.00 Max. :100.00 Max. :56.00 Max. :100.00
## NA's :11 NA's :11 NA's :11 NA's :43
## DDA00AS01222R DDA00AS01322R DDB00A001S22R DDB00A001222R
## Min. : -1.0 Min. :-1.00 Min. : -1.00 Min. : -1.0
## 1st Qu.: 37.0 1st Qu.:17.00 1st Qu.: 50.00 1st Qu.: 21.0
## Median : 46.0 Median :24.00 Median : 63.00 Median : 31.0
## Mean : 45.7 Mean :25.29 Mean : 57.65 Mean : 31.5
## 3rd Qu.: 55.0 3rd Qu.:32.00 3rd Qu.: 74.50 3rd Qu.: 43.0
## Max. :100.0 Max. :77.00 Max. :100.00 Max. :100.0
## NA's :43 NA's :43 NA's :192 NA's :192
## DDB00A001322R DDH00A001S22R DDH00A001222R DDH00A001322R
## Min. :-1.00 Min. : -1.0 Min. : -1.00 Min. :-1.00
## 1st Qu.: 5.00 1st Qu.: 66.0 1st Qu.: 34.00 1st Qu.:12.00
## Median :11.00 Median : 73.0 Median : 41.00 Median :16.00
## Mean :12.45 Mean : 71.7 Mean : 41.63 Mean :16.86
## 3rd Qu.:17.00 3rd Qu.: 80.0 3rd Qu.: 49.00 3rd Qu.:21.00
## Max. :90.00 Max. :100.0 Max. :100.00 Max. :59.00
## NA's :192 NA's :6 NA's :6 NA's :6
## DDW00A001S22R DDW00A001222R DDW00A001322R DDI00A001S22R
## Min. : -1.00 Min. : -1.00 Min. :-1.00 Min. : -1.0
## 1st Qu.: 75.00 1st Qu.: 45.00 1st Qu.:19.00 1st Qu.: -1.0
## Median : 82.00 Median : 54.00 Median :26.00 Median : 66.0
## Mean : 78.69 Mean : 53.24 Mean :26.15 Mean : 50.8
## 3rd Qu.: 88.00 3rd Qu.: 63.00 3rd Qu.:33.00 3rd Qu.: 83.0
## Max. :100.00 Max. :100.00 Max. :79.00 Max. :100.0
## NA's :26 NA's :26 NA's :26 NA's :472
## DDI00A001222R DDI00A001322R DD300A001S22R DD300A001222R
## Min. : -1.00 Min. : -1.00 Min. : -1.0 Min. : -1.00
## 1st Qu.: -1.00 1st Qu.: -1.00 1st Qu.: 50.0 1st Qu.: 17.00
## Median : 35.00 Median : 11.00 Median : 89.0 Median : 67.00
## Mean : 32.08 Mean : 14.35 Mean : 67.8 Mean : 53.76
## 3rd Qu.: 54.00 3rd Qu.: 23.00 3rd Qu.: 96.0 3rd Qu.: 80.00
## Max. :100.00 Max. :100.00 Max. :100.0 Max. :100.00
## NA's :472 NA's :472 NA's :423 NA's :423
## DD300A001322R DD400A001S22R DD400A001222R DD400A001322R
## Min. : -1.00 Min. : -1.00 Min. : -1.00 Min. :-1.00
## 1st Qu.: 0.00 1st Qu.: -1.00 1st Qu.: -1.00 1st Qu.:-1.00
## Median : 37.00 Median : 60.00 Median : 22.50 Median : 0.00
## Mean : 33.08 Mean : 44.08 Mean : 29.23 Mean :14.05
## 3rd Qu.: 52.00 3rd Qu.: 83.00 3rd Qu.: 56.75 3rd Qu.:25.75
## Max. :100.00 Max. :100.00 Max. :100.00 Max. :83.00
## NA's :423 NA's :797 NA's :797 NA's :797
## DD200A001S22R DD200A001222R DD200A001322R DDE00A001S22R
## Min. : -1.00 Min. : -1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.: 64.00 1st Qu.: 33.00 1st Qu.: 10.00 1st Qu.: 63.00
## Median : 76.00 Median : 47.00 Median : 20.00 Median : 70.00
## Mean : 68.18 Mean : 43.98 Mean : 21.06 Mean : 69.68
## 3rd Qu.: 86.00 3rd Qu.: 60.00 3rd Qu.: 30.00 3rd Qu.: 77.00
## Max. :100.00 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :133 NA's :133 NA's :133 NA's :10
## DDE00A001222R DDE00A001322R DA0CT21R DA0CC21R
## Min. : -1.00 Min. :-1.0 Min. : -2.00 Min. :-1.00
## 1st Qu.: 32.00 1st Qu.:12.0 1st Qu.: 40.42 1st Qu.:12.90
## Median : 39.00 Median :15.0 Median : 63.05 Median :23.55
## Mean : 39.23 Mean :15.9 Mean : 60.76 Mean :26.10
## 3rd Qu.: 46.00 3rd Qu.:19.0 3rd Qu.: 85.38 3rd Qu.:37.08
## Max. :100.00 Max. :80.0 Max. :100.00 Max. :97.70
## NA's :10 NA's :10 NA's :125 NA's :147
## DA0CSA21R DA0CAA21R DPSATOFC DPSTTOFC
## Min. : -1.0 Min. :-1.00 Min. : 1.0 Min. : 0.00
## 1st Qu.: 887.0 1st Qu.:16.30 1st Qu.: 58.9 1st Qu.: 30.57
## Median : 973.0 Median :19.00 Median : 144.1 Median : 72.00
## Mean : 823.9 Mean :16.13 Mean : 622.5 Mean : 307.06
## 3rd Qu.:1039.0 3rd Qu.:21.20 3rd Qu.: 405.2 3rd Qu.: 196.50
## Max. :1344.0 Max. :31.40 Max. :23716.2 Max. :10619.50
## NA's :262 NA's :236 NA's :3 NA's :3
## DPSCTOFP DPSSTOFP DPSUTOFP DPSTTOFP
## Min. : 0.000 Min. : 0.00 Min. : 0.000 Min. : 0.00
## 1st Qu.: 1.200 1st Qu.: 2.60 1st Qu.: 4.100 1st Qu.:46.60
## Median : 1.800 Median : 3.10 Median : 6.600 Median :50.80
## Mean : 2.178 Mean : 3.58 Mean : 7.169 Mean :50.98
## 3rd Qu.: 2.600 3rd Qu.: 3.90 3rd Qu.: 9.800 3rd Qu.:54.80
## Max. :14.900 Max. :100.00 Max. :49.700 Max. :88.30
## NA's :3 NA's :3 NA's :3 NA's :3
## DPSETOFP DPSXTOFP DPSCTOSA DPSSTOSA
## Min. : 0.00 Min. : 0.00 Min. : -2 Min. : -2
## 1st Qu.: 9.70 1st Qu.:19.38 1st Qu.: 95459 1st Qu.: 73469
## Median :12.60 Median :23.65 Median :106674 Median : 78723
## Mean :12.95 Mean :23.14 Mean :108039 Mean : 79435
## 3rd Qu.:16.20 3rd Qu.:27.50 3rd Qu.:119540 3rd Qu.: 84944
## Max. :48.80 Max. :55.40 Max. :270000 Max. :192500
## NA's :3 NA's :3 NA's :10 NA's :11
## DPSUTOSA DPSTTOSA DPSAMIFP DPSAKIDR
## Min. : -2 Min. : 36081 Min. : 0.00 Min. : 0.100
## 1st Qu.: 57969 1st Qu.: 50439 1st Qu.: 13.30 1st Qu.: 5.400
## Median : 63015 Median : 53382 Median : 26.60 Median : 6.300
## Mean : 62424 Mean : 53971 Mean : 35.24 Mean : 6.734
## 3rd Qu.: 67941 3rd Qu.: 56919 3rd Qu.: 50.62 3rd Qu.: 7.300
## Max. :228972 Max. :110560 Max. :100.00 Max. :349.100
## NA's :54 NA's :4 NA's :3 NA's :3
## DPSTKIDR DPST05FP DPSTEXPA DPSTADFP
## Min. :-2.00 Min. : 0.00 Min. : 0.00 Min. : 0.00
## 1st Qu.:10.80 1st Qu.: 24.35 1st Qu.:10.07 1st Qu.:14.88
## Median :12.70 Median : 32.40 Median :12.00 Median :20.90
## Mean :12.56 Mean : 34.88 Mean :11.75 Mean :20.86
## 3rd Qu.:14.40 3rd Qu.: 41.65 3rd Qu.:13.90 3rd Qu.:26.12
## Max. :37.30 Max. :100.00 Max. :22.90 Max. :78.70
## NA's :3 NA's :3 NA's :3 NA's :3
## DPSTURNR DPSTBLFP DPSTHIFP DPSTWHFP
## Min. : 0.00 Min. : 0.00 Min. : 0.00 Min. : 0.00
## 1st Qu.: 14.80 1st Qu.: 0.00 1st Qu.: 4.20 1st Qu.: 58.67
## Median : 19.50 Median : 1.60 Median : 10.10 Median : 82.40
## Mean : 21.51 Mean : 6.99 Mean : 19.05 Mean : 71.57
## 3rd Qu.: 25.90 3rd Qu.: 6.20 3rd Qu.: 22.50 3rd Qu.: 92.60
## Max. :100.00 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :7 NA's :3 NA's :3 NA's :3
## DPSTINFP DPSTASFP DPSTPIFP DPSTTWFP
## Min. : 0.0000 Min. : 0.000 Min. :0.00000 Min. : 0.0000
## 1st Qu.: 0.0000 1st Qu.: 0.000 1st Qu.:0.00000 1st Qu.: 0.0000
## Median : 0.0000 Median : 0.000 Median :0.00000 Median : 0.0000
## Mean : 0.3566 Mean : 1.118 Mean :0.08206 Mean : 0.7566
## 3rd Qu.: 0.3000 3rd Qu.: 0.900 3rd Qu.:0.00000 3rd Qu.: 1.2000
## Max. :16.7000 Max. :94.800 Max. :7.80000 Max. :11.7000
## NA's :3 NA's :3 NA's :3 NA's :3
## DPSTREFP DPSTSPFP DPSTCOFP DPSTBIFP
## Min. : 0.00 Min. : 0.000 Min. : 0.000 Min. : 0.000
## 1st Qu.: 71.00 1st Qu.: 4.500 1st Qu.: 0.000 1st Qu.: 0.000
## Median : 76.90 Median : 7.000 Median : 3.350 Median : 0.000
## Mean : 76.87 Mean : 7.145 Mean : 4.131 Mean : 2.311
## 3rd Qu.: 82.42 3rd Qu.: 9.600 3rd Qu.: 6.125 3rd Qu.: 2.100
## Max. :100.00 Max. :22.800 Max. :32.500 Max. :94.300
## NA's :3 NA's :3 NA's :3 NA's :3
## DPSTVOFP DPSTGOFP DPFVTOTK DPFTADPR
## Min. : 0.000 Min. : 0.000 Min. : 0 Min. :0.0000
## 1st Qu.: 4.800 1st Qu.: 0.000 1st Qu.: 238299 1st Qu.:0.9892
## Median : 7.000 Median : 1.200 Median : 419144 Median :1.1670
## Mean : 7.154 Mean : 2.308 Mean : 665067 Mean :1.0212
## 3rd Qu.: 9.425 3rd Qu.: 3.700 3rd Qu.: 670248 3rd Qu.:1.3017
## Max. :71.900 Max. :30.800 Max. :26416597 Max. :1.7480
## NA's :3 NA's :3 NA's :5 NA's :5
## DPFRAALLT DPFRAALLK DPFRAOPRT DPFRASTAP
## Min. :6.428e+05 Min. : 8923 Min. :6.428e+05 Min. : 1.70
## 1st Qu.:5.828e+06 1st Qu.: 12953 1st Qu.:5.524e+06 1st Qu.: 33.85
## Median :1.381e+07 Median : 14653 Median :1.241e+07 Median : 51.00
## Mean :5.995e+07 Mean : 16365 Mean :5.129e+07 Mean : 49.05
## 3rd Qu.:3.805e+07 3rd Qu.: 17081 3rd Qu.:3.241e+07 3rd Qu.: 64.80
## Max. :2.619e+09 Max. :214078 Max. :2.213e+09 Max. :103.40
## NA's :5 NA's :5 NA's :5 NA's :5
## DZRVLOCP DPFRAFEDP DPFRAORVT DPFUNAB1T
## Min. :-6.20 Min. : 0.00 Min. : -655726 Min. : -746998
## 1st Qu.:21.10 1st Qu.: 8.70 1st Qu.: 98311 1st Qu.: 1226730
## Median :35.30 Median :12.30 Median : 1093332 Median : 3589384
## Mean :37.92 Mean :13.04 Mean : 8659622 Mean : 13498263
## 3rd Qu.:53.70 3rd Qu.:16.20 3rd Qu.: 4471240 3rd Qu.: 9357248
## Max. :97.60 Max. :49.00 Max. :405596099 Max. :662450197
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFUNA4T DPFEAALLT DPFEAOPFT DPFEAOPFK
## Min. : -7033092 Min. :6.229e+05 Min. :6.120e+05 Min. : 6755
## 1st Qu.: 0 1st Qu.:5.475e+06 1st Qu.:4.754e+06 1st Qu.: 10916
## Median : 0 Median :1.328e+07 Median :1.102e+07 Median : 12228
## Mean : 510514 Mean :6.597e+07 Mean :4.951e+07 Mean : 13121
## 3rd Qu.: 0 3rd Qu.:3.787e+07 3rd Qu.:3.038e+07 3rd Qu.: 14012
## Max. :126144201 Max. :2.656e+09 Max. :2.068e+09 Max. :178467
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFEAINSP DZEXADMP DZEXADSP DZEXPLAP
## Min. :18.50 Min. : 2.700 Min. : 0.000 Min. : 0.20
## 1st Qu.:52.00 1st Qu.: 7.125 1st Qu.: 4.900 1st Qu.:10.40
## Median :55.10 Median : 8.800 Median : 5.700 Median :11.80
## Mean :54.73 Mean : 9.606 Mean : 6.015 Mean :12.46
## 3rd Qu.:57.80 3rd Qu.:11.200 3rd Qu.: 6.400 3rd Qu.:13.50
## Max. :84.40 Max. :35.800 Max. :22.700 Max. :43.10
## NA's :5 NA's :5 NA's :5 NA's :5
## DZEXOTHP DPFEAINST DPFEAINSK DPFPAREGP
## Min. : 0.30 Min. :2.439e+05 Min. : 3122 Min. : 0.00
## 1st Qu.:15.30 1st Qu.:2.563e+06 1st Qu.: 6056 1st Qu.:35.12
## Median :18.00 Median :6.013e+06 Median : 6702 Median :39.70
## Mean :17.15 Mean :2.835e+07 Mean : 7074 Mean :39.80
## 3rd Qu.:20.00 3rd Qu.:1.683e+07 3rd Qu.: 7577 3rd Qu.:43.90
## Max. :69.30 Max. :1.177e+09 Max. :54954 Max. :79.10
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFPASPEP DPFPACOMP DPFPABILP DPFPAVOCP
## Min. : 0.000 Min. : 0.000 Min. : 0.0000 Min. : 0.00
## 1st Qu.: 5.800 1st Qu.: 6.500 1st Qu.: 0.1000 1st Qu.: 2.90
## Median : 8.900 Median : 9.200 Median : 0.4000 Median : 4.10
## Mean : 9.711 Mean : 9.883 Mean : 0.7496 Mean : 3.96
## 3rd Qu.:12.500 3rd Qu.:12.100 3rd Qu.: 1.0000 3rd Qu.: 5.20
## Max. :49.000 Max. :90.600 Max. :26.0000 Max. :19.80
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFPAGIFP DPFPAATHP DPFPAHSAP DPFPREKP
## Min. :0.0000 Min. :0.000 Min. :0.0000 Min. : 0.0000
## 1st Qu.:0.0000 1st Qu.:1.600 1st Qu.:0.0000 1st Qu.: 0.0000
## Median :0.2000 Median :2.900 Median :0.0000 Median : 0.6000
## Mean :0.3823 Mean :2.809 Mean :0.1578 Mean : 0.8909
## 3rd Qu.:0.4000 3rd Qu.:4.000 3rd Qu.:0.1000 3rd Qu.: 1.3000
## Max. :6.9000 Max. :9.000 Max. :3.4000 Max. :31.7000
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFPAOTHP DISTSIZE COMMTYPE PROPWLTH
## Min. : 3.50 Length:1207 Length:1207 Length:1207
## 1st Qu.:25.40 Class :character Class :character Class :character
## Median :28.70 Mode :character Mode :character Mode :character
## Mean :29.22
## 3rd Qu.:32.40
## Max. :76.30
## NA's :5
## TAXRATE
## Length:1207
## Class :character
## Mode :character
##
##
##
## #forgot that this has so many different variables, going to isolate what I need for my hypothesis
analysis_data <- data %>%
select(DA0CSA21R, # Average SAT score
DA0CAA21R, # Average ACT score
DPFPAREGP, # % Expenditures on Basic Education Services
DISTSIZE, # District size
COMMTYPE, # Community type
DPETECOP) # % Economically Disadvantaged
#Check again for NA's
summary(analysis_data)## DA0CSA21R DA0CAA21R DPFPAREGP DISTSIZE
## Min. : -1.0 Min. :-1.00 Min. : 0.00 Length:1207
## 1st Qu.: 887.0 1st Qu.:16.30 1st Qu.:35.12 Class :character
## Median : 973.0 Median :19.00 Median :39.70 Mode :character
## Mean : 823.9 Mean :16.13 Mean :39.80
## 3rd Qu.:1039.0 3rd Qu.:21.20 3rd Qu.:43.90
## Max. :1344.0 Max. :31.40 Max. :79.10
## NA's :262 NA's :236 NA's :5
## COMMTYPE DPETECOP
## Length:1207 Min. : 0.00
## Class :character 1st Qu.: 47.95
## Mode :character Median : 61.90
## Mean : 60.75
## 3rd Qu.: 77.15
## Max. :100.00
## #Removing rows with missing ACT/SAT Scores, and the same for % Expenditures
analysis_data <- analysis_data %>%
filter(!is.na(DA0CSA21R) & !is.na(DA0CAA21R))
analysis_data <- analysis_data %>% filter(!is.na(DPFPAREGP))
cleaned_data <- analysis_data
summary(cleaned_data)## DA0CSA21R DA0CAA21R DPFPAREGP DISTSIZE
## Min. : -1.0 Min. :-1.0 Min. : 3.30 Length:855
## 1st Qu.: 894.0 1st Qu.:16.4 1st Qu.:36.35 Class :character
## Median : 980.0 Median :19.3 Median :40.30 Mode :character
## Mean : 828.8 Mean :16.2 Mean :40.28
## 3rd Qu.:1041.5 3rd Qu.:21.5 3rd Qu.:44.20
## Max. :1344.0 Max. :31.4 Max. :79.10
## COMMTYPE DPETECOP
## Length:855 Min. : 0.20
## Class :character 1st Qu.: 45.70
## Mode :character Median : 59.10
## Mean : 58.11
## 3rd Qu.: 73.00
## Max. :100.00#I have to convert DISTSIZE and COMMTYPE to categorial data (or factors) -- i should of ask for help here but instead i stubornly looked all over the internet on how/why to do this and finally found an answer!!
cleaned_data$DISTSIZE <- as.factor(cleaned_data$DISTSIZE)
cleaned_data$COMMTYPE <- as.factor(cleaned_data$COMMTYPE)
# Check the structure and summary of cleaned data
str(cleaned_data)## tibble [855 × 6] (S3: tbl_df/tbl/data.frame)
## $ DA0CSA21R: num [1:855] 979 980 1007 1048 990 ...
## $ DA0CAA21R: num [1:855] -1 -1 18.8 21 -1 -1 22.3 23.1 23.5 23.4 ...
## $ DPFPAREGP: num [1:855] 44 42.5 40.3 43.2 36.8 40.6 41.6 35.7 41.2 36.2 ...
## $ DISTSIZE : Factor w/ 9 levels "1,000 to 1,599",..: 1 8 9 5 1 9 5 2 6 2 ...
## $ COMMTYPE : Factor w/ 9 levels "Charters","Independent Town",..: 6 9 9 2 6 9 8 6 2 6 ...
## $ DPETECOP : num [1:855] 45.4 54.2 54.1 81.6 74 46.8 49.6 50.1 85.8 58.6 ...summary(cleaned_data)## DA0CSA21R DA0CAA21R DPFPAREGP DISTSIZE
## Min. : -1.0 Min. :-1.0 Min. : 3.30 500 to 999 :170
## 1st Qu.: 894.0 1st Qu.:16.4 1st Qu.:36.35 Under 500 :153
## Median : 980.0 Median :19.3 Median :40.30 1,000 to 1,599:131
## Mean : 828.8 Mean :16.2 Mean :40.28 1,600 to 2,999:119
## 3rd Qu.:1041.5 3rd Qu.:21.5 3rd Qu.:44.20 3,000 to 4,999: 87
## Max. :1344.0 Max. :31.4 Max. :79.10 5,000 to 9,999: 75
## (Other) :120
## COMMTYPE DPETECOP
## Rural :267 Min. : 0.20
## Non-metropolitan Stable :172 1st Qu.: 45.70
## Other Central City Suburban:161 Median : 59.10
## Major Suburban : 72 Mean : 58.11
## Charters : 62 3rd Qu.: 73.00
## Independent Town : 50 Max. :100.00
## (Other) : 71#Exploritory stats (correlation)
cor(cleaned_data %>% select(DA0CSA21R, DA0CAA21R, DPFPAREGP, DPETECOP))## DA0CSA21R DA0CAA21R DPFPAREGP DPETECOP
## DA0CSA21R 1.0000000 0.1142632 0.2314007 -0.2031756
## DA0CAA21R 0.1142632 1.0000000 0.2019263 -0.2254148
## DPFPAREGP 0.2314007 0.2019263 1.0000000 -0.4918883
## DPETECOP -0.2031756 -0.2254148 -0.4918883 1.0000000# SAT & ACT: Weak positive correlation (0.114). Spending & Test Scores: Higher spending on basic education slightly improves SAT (0.231) and ACT (0.202) scores. Economic Disadvantage: Negatively impacts SAT (-0.203) and ACT (-0.225) scores. Spending vs. Disadvantage: somewhat stronger negative correlation (-0.492).#Basic Graphs!!
hist(cleaned_data$DA0CSA21R,
main = "Histogram of SAT Scores",
xlab = "SAT Scores")
hist(cleaned_data$DA0CAA21R,
main = "Histogram of ACT Scores",
xlab = "ACT Scores")
# This showed me that there are zero's reported in the average scores that still need to be cleaned out..... I had to have AI help me write that code! - Pls take this as my citation to them !
cleaned_data <- analysis_data %>%
filter(!is.na(DA0CSA21R) & !is.na(DA0CAA21R) & !is.na(DPFPAREGP) &
!is.na(DISTSIZE) & !is.na(COMMTYPE) & !is.na(DPETECOP)) %>%
filter(DA0CSA21R > 0 & DA0CAA21R > 0)
str(cleaned_data)## tibble [568 × 6] (S3: tbl_df/tbl/data.frame)
## $ DA0CSA21R: num [1:568] 1007 1048 1041 1109 942 ...
## $ DA0CAA21R: num [1:568] 18.8 21 22.3 23.1 23.5 23.4 21.4 18.3 21.9 19.6 ...
## $ DPFPAREGP: num [1:568] 40.3 43.2 41.6 35.7 41.2 36.2 37.1 42.4 52.9 46.5 ...
## $ DISTSIZE : chr [1:568] "Under 500" "3,000 to 4,999" "3,000 to 4,999" "1,600 to 2,999" ...
## $ COMMTYPE : chr [1:568] "Rural" "Independent Town" "Other Central City Suburban" "Non-metropolitan Stable" ...
## $ DPETECOP : num [1:568] 54.1 81.6 49.6 50.1 85.8 58.6 66.9 41.1 24.7 30 ...summary(cleaned_data)## DA0CSA21R DA0CAA21R DPFPAREGP DISTSIZE
## Min. : 780 Min. :13.80 Min. :17.40 Length:568
## 1st Qu.: 957 1st Qu.:18.60 1st Qu.:37.20 Class :character
## Median :1010 Median :20.50 Median :40.80 Mode :character
## Mean :1013 Mean :20.63 Mean :41.13
## 3rd Qu.:1064 3rd Qu.:22.40 3rd Qu.:44.80
## Max. :1344 Max. :31.40 Max. :79.10
## COMMTYPE DPETECOP
## Length:568 Min. : 0.20
## Class :character 1st Qu.: 42.08
## Mode :character Median : 57.95
## Mean : 56.24
## 3rd Qu.: 72.90
## Max. :100.00#basic graphs prt 2!
hist(cleaned_data$DA0CSA21R,
main = "Histogram of SAT Scores",
xlab = "SAT Scores")
hist(cleaned_data$DA0CAA21R,
main = "Histogram of ACT Scores",
xlab = "ACT Scores")
#they come out much better!!!#more basic graphs
boxplot(DA0CSA21R ~ DISTSIZE, data = cleaned_data,
main = "SAT Scores by District Size",
xlab = "District Size",
ylab = "SAT Scores")
boxplot(DA0CAA21R ~ COMMTYPE, data = cleaned_data,
main = "ACT Scores by Community Type",
xlab = "Community Type",
ylab = "ACT Scores")
#still working on understanding everything there is to understand about box plots, but they are there!#Starting to do more complex measures. first look how the test scores are varied with a ggplot (lots of graphs)
#SAT scores then ACT scores
ggplot(cleaned_data, aes(x = DA0CSA21R)) + geom_histogram() + labs(title = "Distribution of SAT Scores", x = "SAT Score", y = "Frequency")## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.
ggplot(cleaned_data, aes(x = DA0CAA21R)) + geom_histogram() + labs(title = "Distribution of ACT Scores", x = "ACT Score", y = "Frequency")## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.
#looks fairly normal distribution? more normal than the data looked in the past
# look at economically SAT/ACT test
ggplot(cleaned_data, aes(x = DPETECOP, y = DA0CSA21R)) +
geom_point() + labs(title = "SAT Scores vs % Economically Disadvantaged", x = "% Economically Disadvantaged", y = "SAT Score")
ggplot(cleaned_data, aes(x = DPETECOP, y = DA0CAA21R)) +
geom_point() + labs(title = "ACT Scores vs % Economically Disadvantaged", x = "% Economically Disadvantaged", y = "ACT Score")
#maybe a very light cor
#SAT/ACT scores by district size
ggplot(cleaned_data, aes(x = DISTSIZE, y = DA0CSA21R)) + geom_boxplot() + labs(title = "SAT Scores by District Size", x = "District Size", y = "SAT Score")
ggplot(cleaned_data, aes(x = DISTSIZE, y = DA0CAA21R)) + geom_boxplot() + labs(title = "ACT Scores by District Size", x = "District Size", y = "ACT Score")
#again, working to understand all the graphs, but it is getting there. #lm time
#lm fo SAT
sat_model <- lm(DA0CSA21R ~ DPFPAREGP * DISTSIZE * COMMTYPE + DPETECOP, data = cleaned_data)
# Summary
summary(sat_model)##
## Call:
## lm(formula = DA0CSA21R ~ DPFPAREGP * DISTSIZE * COMMTYPE + DPETECOP,
## data = cleaned_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -197.225 -40.509 -5.273 37.278 218.242
##
## Coefficients: (75 not defined because of singularities)
## Estimate
## (Intercept) 1024.8913
## DPFPAREGP 2.8452
## DISTSIZE1,600 to 2,999 -466.2506
## DISTSIZE10,000 to 24,999 183.5792
## DISTSIZE25,000 to 49,999 -89.8235
## DISTSIZE3,000 to 4,999 127.9581
## DISTSIZE5,000 to 9,999 21.5959
## DISTSIZE50,000 and over -185.3062
## DISTSIZE500 to 999 -82.8590
## DISTSIZEUnder 500 -185.4692
## COMMTYPEIndependent Town -77.9169
## COMMTYPEMajor Suburban -54.8255
## COMMTYPEMajor Urban 342.9107
## COMMTYPENon-metropolitan Fast Growing 605.8629
## COMMTYPENon-metropolitan Stable 61.9079
## COMMTYPEOther Central City 502.4323
## COMMTYPEOther Central City Suburban 173.0938
## COMMTYPERural 132.0182
## DPETECOP -2.4191
## DPFPAREGP:DISTSIZE1,600 to 2,999 8.5166
## DPFPAREGP:DISTSIZE10,000 to 24,999 -2.7811
## DPFPAREGP:DISTSIZE25,000 to 49,999 2.3429
## DPFPAREGP:DISTSIZE3,000 to 4,999 -1.3150
## DPFPAREGP:DISTSIZE5,000 to 9,999 -0.5306
## DPFPAREGP:DISTSIZE50,000 and over 7.5550
## DPFPAREGP:DISTSIZE500 to 999 1.9445
## DPFPAREGP:DISTSIZEUnder 500 2.8861
## DPFPAREGP:COMMTYPEIndependent Town 3.2051
## DPFPAREGP:COMMTYPEMajor Suburban -1.6108
## DPFPAREGP:COMMTYPEMajor Urban -11.2849
## DPFPAREGP:COMMTYPENon-metropolitan Fast Growing -15.3483
## DPFPAREGP:COMMTYPENon-metropolitan Stable -1.1679
## DPFPAREGP:COMMTYPEOther Central City -13.2453
## DPFPAREGP:COMMTYPEOther Central City Suburban -4.5422
## DPFPAREGP:COMMTYPERural -2.0470
## DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 717.3896
## DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 319.0819
## DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 214.0103
## DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 408.4804
## DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 81.3612
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban -156.9897
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 112.5764
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban -190.7515
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban -107.4731
## DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 368.1933
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 366.2372
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing -513.8873
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing -2063.6258
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing -409.2645
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 613.8203
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 101.9593
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable 174.1005
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 119.4997
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City -335.0545
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City -19.4112
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City 68.6426
## DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 318.8107
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban -305.6763
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban -27.8907
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban -159.2372
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban -142.7855
## DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DISTSIZE500 to 999:COMMTYPEOther Central City Suburban -349.3517
## DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DISTSIZE50,000 and over:COMMTYPERural NA
## DISTSIZE500 to 999:COMMTYPERural 29.9058
## DISTSIZEUnder 500:COMMTYPERural NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town -14.5807
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town -10.7297
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town -8.1578
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town -10.4596
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 1.8300
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 5.1549
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban -0.3492
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 7.4857
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 5.3319
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban -7.4248
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing -4.0065
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 11.4209
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 45.5576
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 9.8290
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable -12.3081
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable -4.3750
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable -3.1729
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 8.6819
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 2.3236
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban -4.6575
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 6.3183
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 2.7651
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 4.0442
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 7.8013
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPERural NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPERural -1.7759
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPERural NA
## Std. Error
## (Intercept) 157.7946
## DPFPAREGP 2.8739
## DISTSIZE1,600 to 2,999 636.8804
## DISTSIZE10,000 to 24,999 218.8976
## DISTSIZE25,000 to 49,999 415.0627
## DISTSIZE3,000 to 4,999 253.2193
## DISTSIZE5,000 to 9,999 215.0365
## DISTSIZE50,000 and over 566.5881
## DISTSIZE500 to 999 170.9609
## DISTSIZEUnder 500 191.8705
## COMMTYPEIndependent Town 406.0521
## COMMTYPEMajor Suburban 631.7595
## COMMTYPEMajor Urban 620.1166
## COMMTYPENon-metropolitan Fast Growing 244.3055
## COMMTYPENon-metropolitan Stable 168.8951
## COMMTYPEOther Central City 473.4663
## COMMTYPEOther Central City Suburban 198.5885
## COMMTYPERural 128.4262
## DPETECOP 0.1769
## DPFPAREGP:DISTSIZE1,600 to 2,999 12.0944
## DPFPAREGP:DISTSIZE10,000 to 24,999 4.0370
## DPFPAREGP:DISTSIZE25,000 to 49,999 9.2302
## DPFPAREGP:DISTSIZE3,000 to 4,999 5.0932
## DPFPAREGP:DISTSIZE5,000 to 9,999 4.1266
## DPFPAREGP:DISTSIZE50,000 and over 15.8016
## DPFPAREGP:DISTSIZE500 to 999 3.2740
## DPFPAREGP:DISTSIZEUnder 500 3.4897
## DPFPAREGP:COMMTYPEIndependent Town 10.6205
## DPFPAREGP:COMMTYPEMajor Suburban 17.1825
## DPFPAREGP:COMMTYPEMajor Urban 16.9356
## DPFPAREGP:COMMTYPENon-metropolitan Fast Growing 5.8848
## DPFPAREGP:COMMTYPENon-metropolitan Stable 3.3357
## DPFPAREGP:COMMTYPEOther Central City 12.9260
## DPFPAREGP:COMMTYPEOther Central City Suburban 4.0696
## DPFPAREGP:COMMTYPERural 2.5215
## DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 763.2766
## DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 748.2720
## DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 485.5891
## DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 643.3365
## DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 1103.1974
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 661.0616
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 780.6485
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 750.7370
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 633.3875
## DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 1383.8508
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 887.3174
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 370.7842
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 2150.3942
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 287.8513
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 645.8286
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 306.3310
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable 101.4604
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 211.1003
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 524.2551
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 670.9789
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City 172.2543
## DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 653.2668
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 271.8990
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban 88.9384
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 294.5715
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 261.6458
## DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 574.8587
## DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DISTSIZE50,000 and over:COMMTYPERural NA
## DISTSIZE500 to 999:COMMTYPERural 163.0409
## DISTSIZEUnder 500:COMMTYPERural NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 16.6407
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 18.0098
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 12.2966
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 16.4404
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 25.9078
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 17.6297
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 20.0047
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 19.9422
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 17.0969
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 34.9986
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 18.8412
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 8.1420
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 45.3915
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 6.8840
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 12.4174
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 6.6110
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 4.5906
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 13.7791
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 16.7502
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 12.5783
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 5.4627
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 6.2259
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 5.4429
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 12.5118
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPERural NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPERural 3.4748
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPERural NA
## t value
## (Intercept) 6.495
## DPFPAREGP 0.990
## DISTSIZE1,600 to 2,999 -0.732
## DISTSIZE10,000 to 24,999 0.839
## DISTSIZE25,000 to 49,999 -0.216
## DISTSIZE3,000 to 4,999 0.505
## DISTSIZE5,000 to 9,999 0.100
## DISTSIZE50,000 and over -0.327
## DISTSIZE500 to 999 -0.485
## DISTSIZEUnder 500 -0.967
## COMMTYPEIndependent Town -0.192
## COMMTYPEMajor Suburban -0.087
## COMMTYPEMajor Urban 0.553
## COMMTYPENon-metropolitan Fast Growing 2.480
## COMMTYPENon-metropolitan Stable 0.367
## COMMTYPEOther Central City 1.061
## COMMTYPEOther Central City Suburban 0.872
## COMMTYPERural 1.028
## DPETECOP -13.676
## DPFPAREGP:DISTSIZE1,600 to 2,999 0.704
## DPFPAREGP:DISTSIZE10,000 to 24,999 -0.689
## DPFPAREGP:DISTSIZE25,000 to 49,999 0.254
## DPFPAREGP:DISTSIZE3,000 to 4,999 -0.258
## DPFPAREGP:DISTSIZE5,000 to 9,999 -0.129
## DPFPAREGP:DISTSIZE50,000 and over 0.478
## DPFPAREGP:DISTSIZE500 to 999 0.594
## DPFPAREGP:DISTSIZEUnder 500 0.827
## DPFPAREGP:COMMTYPEIndependent Town 0.302
## DPFPAREGP:COMMTYPEMajor Suburban -0.094
## DPFPAREGP:COMMTYPEMajor Urban -0.666
## DPFPAREGP:COMMTYPENon-metropolitan Fast Growing -2.608
## DPFPAREGP:COMMTYPENon-metropolitan Stable -0.350
## DPFPAREGP:COMMTYPEOther Central City -1.025
## DPFPAREGP:COMMTYPEOther Central City Suburban -1.116
## DPFPAREGP:COMMTYPERural -0.812
## DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 0.940
## DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 0.426
## DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 0.441
## DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 0.635
## DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 0.074
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban -0.237
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 0.144
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban -0.254
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban -0.170
## DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 0.266
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 0.413
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing -1.386
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing -0.960
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing -1.422
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 0.950
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 0.333
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable 1.716
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 0.566
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City -0.639
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City -0.029
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City 0.398
## DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 0.488
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban -1.124
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban -0.314
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban -0.541
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban -0.546
## DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DISTSIZE500 to 999:COMMTYPEOther Central City Suburban -0.608
## DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DISTSIZE50,000 and over:COMMTYPERural NA
## DISTSIZE500 to 999:COMMTYPERural 0.183
## DISTSIZEUnder 500:COMMTYPERural NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town -0.876
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town -0.596
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town -0.663
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town -0.636
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 0.071
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 0.292
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban -0.017
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 0.375
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 0.312
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban -0.212
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing -0.213
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 1.403
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 1.004
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 1.428
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable -0.991
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable -0.662
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable -0.691
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 0.630
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 0.139
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban -0.370
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 1.157
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 0.444
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 0.743
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 0.624
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPERural NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPERural -0.511
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPERural NA
## Pr(>|t|)
## (Intercept) 2.08e-10
## DPFPAREGP 0.32266
## DISTSIZE1,600 to 2,999 0.46447
## DISTSIZE10,000 to 24,999 0.40208
## DISTSIZE25,000 to 49,999 0.82876
## DISTSIZE3,000 to 4,999 0.61356
## DISTSIZE5,000 to 9,999 0.92005
## DISTSIZE50,000 and over 0.74377
## DISTSIZE500 to 999 0.62813
## DISTSIZEUnder 500 0.33421
## COMMTYPEIndependent Town 0.84791
## COMMTYPEMajor Suburban 0.93088
## COMMTYPEMajor Urban 0.58054
## COMMTYPENon-metropolitan Fast Growing 0.01348
## COMMTYPENon-metropolitan Stable 0.71412
## COMMTYPEOther Central City 0.28914
## COMMTYPEOther Central City Suburban 0.38385
## COMMTYPERural 0.30448
## DPETECOP < 2e-16
## DPFPAREGP:DISTSIZE1,600 to 2,999 0.48167
## DPFPAREGP:DISTSIZE10,000 to 24,999 0.49122
## DPFPAREGP:DISTSIZE25,000 to 49,999 0.79973
## DPFPAREGP:DISTSIZE3,000 to 4,999 0.79637
## DPFPAREGP:DISTSIZE5,000 to 9,999 0.89775
## DPFPAREGP:DISTSIZE50,000 and over 0.63278
## DPFPAREGP:DISTSIZE500 to 999 0.55284
## DPFPAREGP:DISTSIZEUnder 500 0.40864
## DPFPAREGP:COMMTYPEIndependent Town 0.76295
## DPFPAREGP:COMMTYPEMajor Suburban 0.92535
## DPFPAREGP:COMMTYPEMajor Urban 0.50551
## DPFPAREGP:COMMTYPENon-metropolitan Fast Growing 0.00939
## DPFPAREGP:COMMTYPENon-metropolitan Stable 0.72641
## DPFPAREGP:COMMTYPEOther Central City 0.30602
## DPFPAREGP:COMMTYPEOther Central City Suburban 0.26493
## DPFPAREGP:COMMTYPERural 0.41732
## DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 0.34775
## DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 0.66999
## DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 0.65961
## DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 0.52577
## DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 0.94124
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 0.81238
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 0.88540
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 0.79954
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 0.86533
## DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 0.79030
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 0.67998
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 0.16641
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 0.33771
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 0.15574
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 0.34237
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 0.73940
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable 0.08682
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 0.57160
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 0.52306
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 0.97693
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City 0.69044
## DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 0.62575
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 0.26148
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban 0.75396
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 0.58905
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 0.58551
## DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 0.54366
## DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DISTSIZE50,000 and over:COMMTYPERural NA
## DISTSIZE500 to 999:COMMTYPERural 0.85454
## DISTSIZEUnder 500:COMMTYPERural NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town 0.38136
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town 0.55161
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town 0.50738
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town 0.52494
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEIndependent Town NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban 0.94372
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban 0.77011
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban 0.98608
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban 0.70755
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban 0.75528
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban 0.83208
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Urban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing 0.83169
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing 0.16135
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing 0.31605
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing 0.15400
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable 0.32209
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable 0.50843
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable 0.48979
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City 0.52894
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City 0.88973
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban 0.71134
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban 0.24801
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban 0.65715
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban 0.45783
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City Suburban 0.53324
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City Suburban NA
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPERural NA
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPERural NA
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPERural 0.60954
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPERural NA
##
## (Intercept) ***
## DPFPAREGP
## DISTSIZE1,600 to 2,999
## DISTSIZE10,000 to 24,999
## DISTSIZE25,000 to 49,999
## DISTSIZE3,000 to 4,999
## DISTSIZE5,000 to 9,999
## DISTSIZE50,000 and over
## DISTSIZE500 to 999
## DISTSIZEUnder 500
## COMMTYPEIndependent Town
## COMMTYPEMajor Suburban
## COMMTYPEMajor Urban
## COMMTYPENon-metropolitan Fast Growing *
## COMMTYPENon-metropolitan Stable
## COMMTYPEOther Central City
## COMMTYPEOther Central City Suburban
## COMMTYPERural
## DPETECOP ***
## DPFPAREGP:DISTSIZE1,600 to 2,999
## DPFPAREGP:DISTSIZE10,000 to 24,999
## DPFPAREGP:DISTSIZE25,000 to 49,999
## DPFPAREGP:DISTSIZE3,000 to 4,999
## DPFPAREGP:DISTSIZE5,000 to 9,999
## DPFPAREGP:DISTSIZE50,000 and over
## DPFPAREGP:DISTSIZE500 to 999
## DPFPAREGP:DISTSIZEUnder 500
## DPFPAREGP:COMMTYPEIndependent Town
## DPFPAREGP:COMMTYPEMajor Suburban
## DPFPAREGP:COMMTYPEMajor Urban
## DPFPAREGP:COMMTYPENon-metropolitan Fast Growing **
## DPFPAREGP:COMMTYPENon-metropolitan Stable
## DPFPAREGP:COMMTYPEOther Central City
## DPFPAREGP:COMMTYPEOther Central City Suburban
## DPFPAREGP:COMMTYPERural
## DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town
## DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town
## DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town
## DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town
## DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town
## DISTSIZE50,000 and over:COMMTYPEIndependent Town
## DISTSIZE500 to 999:COMMTYPEIndependent Town
## DISTSIZEUnder 500:COMMTYPEIndependent Town
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban
## DISTSIZE50,000 and over:COMMTYPEMajor Suburban
## DISTSIZE500 to 999:COMMTYPEMajor Suburban
## DISTSIZEUnder 500:COMMTYPEMajor Suburban
## DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban
## DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban
## DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban
## DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban
## DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban
## DISTSIZE50,000 and over:COMMTYPEMajor Urban
## DISTSIZE500 to 999:COMMTYPEMajor Urban
## DISTSIZEUnder 500:COMMTYPEMajor Urban
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing
## DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable
## DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable
## DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable
## DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable
## DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable .
## DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable
## DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable
## DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City
## DISTSIZE50,000 and over:COMMTYPEOther Central City
## DISTSIZE500 to 999:COMMTYPEOther Central City
## DISTSIZEUnder 500:COMMTYPEOther Central City
## DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban
## DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban
## DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban
## DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban
## DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban
## DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban
## DISTSIZE500 to 999:COMMTYPEOther Central City Suburban
## DISTSIZEUnder 500:COMMTYPEOther Central City Suburban
## DISTSIZE1,600 to 2,999:COMMTYPERural
## DISTSIZE10,000 to 24,999:COMMTYPERural
## DISTSIZE25,000 to 49,999:COMMTYPERural
## DISTSIZE3,000 to 4,999:COMMTYPERural
## DISTSIZE5,000 to 9,999:COMMTYPERural
## DISTSIZE50,000 and over:COMMTYPERural
## DISTSIZE500 to 999:COMMTYPERural
## DISTSIZEUnder 500:COMMTYPERural
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEIndependent Town
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Suburban
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEMajor Urban
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Fast Growing
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPENon-metropolitan Stable
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPEOther Central City Suburban
## DPFPAREGP:DISTSIZE1,600 to 2,999:COMMTYPERural
## DPFPAREGP:DISTSIZE10,000 to 24,999:COMMTYPERural
## DPFPAREGP:DISTSIZE25,000 to 49,999:COMMTYPERural
## DPFPAREGP:DISTSIZE3,000 to 4,999:COMMTYPERural
## DPFPAREGP:DISTSIZE5,000 to 9,999:COMMTYPERural
## DPFPAREGP:DISTSIZE50,000 and over:COMMTYPERural
## DPFPAREGP:DISTSIZE500 to 999:COMMTYPERural
## DPFPAREGP:DISTSIZEUnder 500:COMMTYPERural
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 66.54 on 480 degrees of freedom
## Multiple R-squared: 0.5042, Adjusted R-squared: 0.4144
## F-statistic: 5.612 on 87 and 480 DF, p-value: < 2.2e-16#ahhhhhhh, way too much info, going to edit to only look at DPFPAREGP, % Expenditures on Basic Education Services and DPETECOP % Economically Disadvantaged, within each tests model, as not to overwhelm the model# Simple model - SAT
sat_simple_model <- lm(DA0CSA21R ~ DPETECOP + DPFPAREGP, data = cleaned_data)
summary(sat_simple_model)##
## Call:
## lm(formula = DA0CSA21R ~ DPETECOP + DPFPAREGP, data = cleaned_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -214.811 -46.807 -7.844 42.841 234.443
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1060.8642 25.4665 41.657 < 2e-16 ***
## DPETECOP -2.1725 0.1533 -14.176 < 2e-16 ***
## DPFPAREGP 1.8061 0.4802 3.761 0.000187 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 67.75 on 565 degrees of freedom
## Multiple R-squared: 0.3951, Adjusted R-squared: 0.3929
## F-statistic: 184.5 on 2 and 565 DF, p-value: < 2.2e-16#Findings: Basically, for every 1% increase in students from economically disadvantaged backgrounds, the average SAT score drops by about 2.17 points. For every 1% increase in spending on essential educational services, SAT scores rise by about 1.81 points. The two factors together explain about 40% of the differences in SAT scores between districts. The model is statistically significant, meaning these findings are unlikely to be due to chance.#ACT
act_simple_model <- lm(DA0CAA21R ~ DPETECOP + DPFPAREGP, data = cleaned_data)
summary(act_simple_model)##
## Call:
## lm(formula = DA0CAA21R ~ DPETECOP + DPFPAREGP, data = cleaned_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -5.3043 -1.5750 -0.1363 1.3366 7.8642
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 20.866719 0.831739 25.088 < 2e-16 ***
## DPETECOP -0.064925 0.005005 -12.971 < 2e-16 ***
## DPFPAREGP 0.082967 0.015682 5.291 1.75e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.213 on 565 degrees of freedom
## Multiple R-squared: 0.3924, Adjusted R-squared: 0.3902
## F-statistic: 182.4 on 2 and 565 DF, p-value: < 2.2e-16#Findings: For every 1% increase in economically disadvantaged students, the average ACT score drops by about 0.065 points.For every 1% increase in spending on essential education services, ACT scores rise by about 0.083 points. The two factors explain about 39% of the differences in ACT scores between districts.The model is statistically significant, meaning the findings are reliable and unlikely to be due to chance.#check assumptions of the models
# Linearity and Homoscedasticity
plot(sat_simple_model, which = 1, main = "Residuals vs Fitted (SAT Model)")
library(lmtest)## Loading required package: zoo##
## Attaching package: 'zoo'## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numericbptest(sat_simple_model)##
## studentized Breusch-Pagan test
##
## data: sat_simple_model
## BP = 0.011898, df = 2, p-value = 0.9941#normality
qqnorm(residuals(sat_simple_model), main = "Normal Q-Q Plot (SAT Model)")
qqline(residuals(sat_simple_model), col = "blue", lwd = 2)
# I actually think this model (ACT) actually might meet all the assumptions tested# Linearity and Homoscedasticity
plot(act_simple_model, which = 1, main = "Residuals vs Fitted (ACT Model)")
library(lmtest)
bptest(act_simple_model)##
## studentized Breusch-Pagan test
##
## data: act_simple_model
## BP = 15.363, df = 2, p-value = 0.0004613# normality
qqnorm(residuals(act_simple_model), main = "Normal Q-Q Plot (ACT Model)")
qqline(residuals(act_simple_model), col = "blue", lwd = 2)
#same with act, there is some outliers but nothing crazy