library(readxl)
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 errors
district<-read_excel("District.xls")
summary(district)
## DISTNAME DISTRICT DZCNTYNM REGION
## Length:1204 Length:1204 Length:1204 Length:1204
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## DZRATING DZCAMPUS DPETALLC DPETBLAP
## Length:1204 Min. : 1.000 Min. : 5.0 Min. : 0.000
## Class :character 1st Qu.: 2.000 1st Qu.: 336.8 1st Qu.: 0.700
## Mode :character Median : 3.000 Median : 879.0 Median : 2.900
## Mean : 7.342 Mean : 4451.0 Mean : 8.807
## 3rd Qu.: 5.000 3rd Qu.: 2685.0 3rd Qu.:11.000
## Max. :274.000 Max. :196550.0 Max. :99.100
##
## DPETHISP DPETWHIP DPETINDP DPETASIP
## Min. : 0.90 Min. : 0.00 Min. : 0.0000 Min. : 0.000
## 1st Qu.: 20.38 1st Qu.:18.27 1st Qu.: 0.0000 1st Qu.: 0.000
## Median : 37.85 Median :44.85 Median : 0.2000 Median : 0.400
## Mean : 42.94 Mean :43.61 Mean : 0.3316 Mean : 1.581
## 3rd Qu.: 61.70 3rd Qu.:67.95 3rd Qu.: 0.4000 3rd Qu.: 1.000
## Max. :100.00 Max. :97.80 Max. :22.1000 Max. :60.100
##
## DPETPCIP DPETTWOP DPETECOP DPETLEPP
## Min. : 0.00000 Min. : 0.000 Min. : 0.00 Min. : 0.000
## 1st Qu.: 0.00000 1st Qu.: 1.100 1st Qu.: 46.70 1st Qu.: 2.775
## Median : 0.00000 Median : 2.400 Median : 61.45 Median : 7.000
## Mean : 0.09468 Mean : 2.628 Mean : 60.13 Mean :11.978
## 3rd Qu.: 0.10000 3rd Qu.: 3.700 3rd Qu.: 75.33 3rd Qu.:16.025
## Max. :16.80000 Max. :15.500 Max. :100.00 Max. :90.500
##
## DPETSPEP DPETBILP DPETVOCP DPETGIFP DA0AT20R
## Min. : 0.000 Min. : 0.00 Min. :0 Min. : 0.00 Min. : -1.00
## 1st Qu.: 9.575 1st Qu.: 2.60 1st Qu.:0 1st Qu.: 3.10 1st Qu.: 98.30
## Median :11.500 Median : 6.75 Median :0 Median : 5.40 Median : 98.70
## Mean :11.723 Mean :11.93 Mean :0 Mean : 5.49 Mean : 98.34
## 3rd Qu.:13.600 3rd Qu.:16.05 3rd Qu.:0 3rd Qu.: 7.50 3rd Qu.: 99.00
## Max. :43.300 Max. :98.30 Max. :0 Max. :80.80 Max. :100.00
## NA's :4
## DA0912DR20R DAGC4X20R DAGC5X19R DAGC6X18R
## Min. :-1.0000 Min. : -1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.: 0.0000 1st Qu.: 94.00 1st Qu.: 94.92 1st Qu.: 94.80
## Median : 0.3000 Median : 97.10 Median : 98.00 Median : 98.00
## Mean : 0.8312 Mean : 94.55 Mean : 95.53 Mean : 95.41
## 3rd Qu.: 0.9000 3rd Qu.:100.00 3rd Qu.:100.00 3rd Qu.:100.00
## Max. :47.5000 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :112 NA's :138 NA's :146 NA's :149
## DA0GR20N DA0GS20N DDA00A001S21R DDA00A001221R
## Min. : 1.0 Min. : 0.0 Min. :-1.00 Min. :-1.00
## 1st Qu.: 31.0 1st Qu.: 25.0 1st Qu.:60.00 1st Qu.:31.00
## Median : 72.0 Median : 63.0 Median :71.00 Median :41.00
## Mean : 335.0 Mean : 287.7 Mean :68.79 Mean :40.53
## 3rd Qu.: 214.2 3rd Qu.: 185.0 3rd Qu.:78.00 3rd Qu.:49.00
## Max. :11433.0 Max. :9640.0 Max. :98.00 Max. :92.00
## NA's :130 NA's :130 NA's :9 NA's :9
## DDA00A001321R DDA00AR01S21R DDA00AR01221R DDA00AR01321R
## Min. :-1.0 Min. : -1.00 Min. :-1.00 Min. :-1.00
## 1st Qu.:11.0 1st Qu.: 62.00 1st Qu.:35.00 1st Qu.:11.00
## Median :16.0 Median : 70.00 Median :43.00 Median :16.00
## Mean :16.8 Mean : 69.48 Mean :43.82 Mean :17.27
## 3rd Qu.:21.0 3rd Qu.: 78.00 3rd Qu.:52.00 3rd Qu.:22.00
## Max. :57.0 Max. :100.00 Max. :93.00 Max. :60.00
## NA's :9 NA's :9 NA's :9 NA's :9
## DDA00AW01S21R DDA00AW01221R DDA00AW01321R DDA00AM01S21R
## Min. : -1.00 Min. :-1.00 Min. :-1.000 Min. : -1.00
## 1st Qu.: 49.75 1st Qu.:19.00 1st Qu.: 3.000 1st Qu.: 58.00
## Median : 60.00 Median :28.00 Median : 6.000 Median : 70.00
## Mean : 59.40 Mean :29.38 Mean : 7.464 Mean : 67.51
## 3rd Qu.: 70.00 3rd Qu.:38.00 3rd Qu.:10.000 3rd Qu.: 79.00
## Max. :100.00 Max. :85.00 Max. :43.000 Max. :100.00
## NA's :36 NA's :36 NA's :36 NA's :9
## DDA00AM01221R DDA00AM01321R DDA00AC01S21R DDA00AC01221R
## Min. :-1.00 Min. :-1.00 Min. : -1.00 Min. :-1.00
## 1st Qu.:26.00 1st Qu.: 9.00 1st Qu.: 64.00 1st Qu.:30.00
## Median :37.00 Median :15.00 Median : 75.00 Median :43.00
## Mean :37.31 Mean :16.59 Mean : 71.61 Mean :41.49
## 3rd Qu.:49.00 3rd Qu.:22.00 3rd Qu.: 82.00 3rd Qu.:53.00
## Max. :84.00 Max. :62.00 Max. :100.00 Max. :95.00
## NA's :9 NA's :9 NA's :13 NA's :13
## DDA00AC01321R DDA00AS01S21R DDA00AS01221R DDA00AS01321R
## Min. :-1.00 Min. : -1.00 Min. :-1.00 Min. :-1.00
## 1st Qu.: 9.00 1st Qu.: 65.00 1st Qu.:36.00 1st Qu.:16.00
## Median :15.00 Median : 74.00 Median :47.00 Median :24.00
## Mean :16.38 Mean : 72.32 Mean :46.01 Mean :24.71
## 3rd Qu.:22.00 3rd Qu.: 82.00 3rd Qu.:57.00 3rd Qu.:33.00
## Max. :60.00 Max. :100.00 Max. :96.00 Max. :81.00
## NA's :13 NA's :47 NA's :47 NA's :47
## DDB00A001S21R DDB00A001221R DDB00A001321R DDH00A001S21R
## Min. : -1.00 Min. : -1.0 Min. :-1.000 Min. : -1.0
## 1st Qu.: 43.00 1st Qu.: 17.0 1st Qu.: 2.000 1st Qu.: 57.0
## Median : 56.00 Median : 26.0 Median : 7.000 Median : 66.0
## Mean : 52.34 Mean : 27.1 Mean : 9.439 Mean : 64.9
## 3rd Qu.: 67.25 3rd Qu.: 36.0 3rd Qu.:13.000 3rd Qu.: 74.0
## Max. :100.00 Max. :100.0 Max. :83.000 Max. :100.0
## NA's :192 NA's :192 NA's :192 NA's :10
## DDH00A001221R DDH00A001321R DDW00A001S21R DDW00A001221R
## Min. :-1.00 Min. :-1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.:27.00 1st Qu.: 8.00 1st Qu.: 69.25 1st Qu.: 40.00
## Median :35.00 Median :12.00 Median : 77.00 Median : 48.00
## Mean :35.25 Mean :13.03 Mean : 74.87 Mean : 48.06
## 3rd Qu.:43.00 3rd Qu.:16.75 3rd Qu.: 84.00 3rd Qu.: 58.00
## Max. :95.00 Max. :48.00 Max. :100.00 Max. :100.00
## NA's :10 NA's :10 NA's :34 NA's :34
## DDW00A001321R DDI00A001S21R DDI00A001221R DDI00A001321R
## Min. :-1.00 Min. : -1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.:15.00 1st Qu.: -1.00 1st Qu.: -1.00 1st Qu.: -1.00
## Median :21.00 Median : 60.00 Median : 28.50 Median : 7.00
## Mean :21.45 Mean : 46.98 Mean : 28.21 Mean : 11.11
## 3rd Qu.:27.00 3rd Qu.: 79.00 3rd Qu.: 49.00 3rd Qu.: 19.00
## Max. :59.00 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :34 NA's :462 NA's :462 NA's :462
## DD300A001S21R DD300A001221R DD300A001321R DD400A001S21R
## Min. : -1.00 Min. : -1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.: 59.50 1st Qu.: 26.50 1st Qu.: 0.00 1st Qu.: -1.00
## Median : 85.00 Median : 61.00 Median : 31.00 Median : 47.00
## Mean : 67.76 Mean : 51.17 Mean : 28.84 Mean : 39.56
## 3rd Qu.: 94.00 3rd Qu.: 74.00 3rd Qu.: 44.00 3rd Qu.: 74.00
## Max. :100.00 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :421 NA's :421 NA's :421 NA's :815
## DD400A001221R DD400A001321R DD200A001S21R DD200A001221R
## Min. : -1.00 Min. : -1.00 Min. : -1.00 Min. : -1.00
## 1st Qu.: -1.00 1st Qu.: -1.00 1st Qu.: 56.00 1st Qu.: 26.00
## Median : 13.00 Median : 0.00 Median : 70.00 Median : 40.00
## Mean : 24.22 Mean : 10.81 Mean : 63.14 Mean : 38.49
## 3rd Qu.: 44.00 3rd Qu.: 18.00 3rd Qu.: 81.00 3rd Qu.: 53.00
## Max. :100.00 Max. :100.00 Max. :100.00 Max. :100.00
## NA's :815 NA's :815 NA's :142 NA's :142
## DD200A001321R DDE00A001S21R DDE00A001221R DDE00A001321R
## Min. :-1.0 Min. : -1.00 Min. :-1.00 Min. :-1.00
## 1st Qu.: 6.0 1st Qu.: 55.50 1st Qu.:26.00 1st Qu.: 8.00
## Median :15.0 Median : 64.00 Median :32.00 Median :11.00
## Mean :16.6 Mean : 62.78 Mean :33.08 Mean :11.91
## 3rd Qu.:25.0 3rd Qu.: 71.00 3rd Qu.:39.00 3rd Qu.:15.00
## Max. :90.0 Max. :100.00 Max. :85.00 Max. :54.00
## NA's :142 NA's :13 NA's :13 NA's :13
## DA0CT20R DA0CC20R DA0CSA20R DA0CAA20R
## Min. : -2.0 Min. :-1.0 Min. : -1.0 Min. :-1.00
## 1st Qu.: 51.1 1st Qu.:15.2 1st Qu.: 915.0 1st Qu.:17.50
## Median : 68.2 Median :26.7 Median : 997.0 Median :19.50
## Mean : 67.5 Mean :28.6 Mean : 866.6 Mean :17.68
## 3rd Qu.: 87.8 3rd Qu.:39.5 3rd Qu.:1057.0 3rd Qu.:21.30
## Max. :100.0 Max. :96.3 Max. :1352.0 Max. :29.90
## NA's :127 NA's :135 NA's :207 NA's :178
## DPSATOFC DPSTTOFC DPSCTOFP DPSSTOFP
## Min. : 1.0 Min. : 0.0 Min. : 0.000 Min. : 0.000
## 1st Qu.: 57.7 1st Qu.: 30.5 1st Qu.: 1.200 1st Qu.: 2.600
## Median : 139.0 Median : 71.9 Median : 1.800 Median : 3.100
## Mean : 619.5 Mean : 307.1 Mean : 2.246 Mean : 3.615
## 3rd Qu.: 396.6 3rd Qu.: 197.8 3rd Qu.: 2.600 3rd Qu.: 4.000
## Max. :24419.6 Max. :11254.4 Max. :50.000 Max. :100.000
## NA's :1 NA's :1 NA's :1 NA's :1
## DPSUTOFP DPSTTOFP DPSETOFP DPSXTOFP
## Min. : 0.000 Min. : 0.00 Min. : 0.00 Min. : 0.0
## 1st Qu.: 4.000 1st Qu.:47.00 1st Qu.: 9.20 1st Qu.:20.0
## Median : 6.300 Median :51.20 Median :12.20 Median :24.3
## Mean : 6.935 Mean :51.31 Mean :12.29 Mean :23.6
## 3rd Qu.: 9.500 3rd Qu.:55.10 3rd Qu.:15.20 3rd Qu.:27.9
## Max. :45.500 Max. :87.00 Max. :41.10 Max. :50.6
## NA's :1 NA's :1 NA's :1 NA's :1
## DPSCTOSA DPSSTOSA DPSUTOSA DPSTTOSA
## Min. : -2 Min. : -2 Min. : -2 Min. :17084
## 1st Qu.: 93058 1st Qu.: 72249 1st Qu.:56936 1st Qu.:49732
## Median :103860 Median : 77465 Median :61587 Median :52240
## Mean :104955 Mean : 78154 Mean :60930 Mean :52787
## 3rd Qu.:115835 3rd Qu.: 83843 3rd Qu.:66526 3rd Qu.:55713
## Max. :276336 Max. :270000 Max. :99258 Max. :74424
## NA's :4 NA's :12 NA's :53 NA's :3
## DPSAMIFP DPSAKIDR DPSTKIDR DPST05FP
## Min. : 0.00 Min. : 0.900 Min. :-2.00 Min. : 0.00
## 1st Qu.: 12.90 1st Qu.: 5.500 1st Qu.:10.70 1st Qu.: 23.70
## Median : 25.40 Median : 6.400 Median :12.70 Median : 31.70
## Mean : 34.54 Mean : 8.266 Mean :12.64 Mean : 34.22
## 3rd Qu.: 49.45 3rd Qu.: 7.300 3rd Qu.:14.40 3rd Qu.: 41.50
## Max. :100.00 Max. :1524.000 Max. :40.60 Max. :100.00
## NA's :1 NA's :1 NA's :1 NA's :1
## DPSTEXPA DPSTADFP DPSTURNR DPSTBLFP
## Min. : 0.00 Min. : 0.00 Min. : 0.00 Min. : 0.000
## 1st Qu.:10.20 1st Qu.:14.60 1st Qu.: 11.70 1st Qu.: 0.000
## Median :12.10 Median :20.20 Median : 15.80 Median : 1.600
## Mean :11.85 Mean :20.58 Mean : 17.76 Mean : 6.752
## 3rd Qu.:13.90 3rd Qu.:26.10 3rd Qu.: 21.90 3rd Qu.: 6.300
## Max. :27.60 Max. :79.50 Max. :100.00 Max. :100.000
## NA's :1 NA's :1 NA's :7 NA's :1
## DPSTHIFP DPSTWHFP DPSTINFP DPSTASFP
## Min. : 0.00 Min. : 0.00 Min. : 0.0000 Min. : 0.000
## 1st Qu.: 3.95 1st Qu.: 61.65 1st Qu.: 0.0000 1st Qu.: 0.000
## Median : 9.40 Median : 83.30 Median : 0.0000 Median : 0.000
## Mean : 18.58 Mean : 72.25 Mean : 0.3382 Mean : 1.072
## 3rd Qu.: 21.60 3rd Qu.: 92.40 3rd Qu.: 0.3000 3rd Qu.: 0.850
## Max. :100.00 Max. :100.00 Max. :10.8000 Max. :94.100
## NA's :1 NA's :1 NA's :1 NA's :1
## DPSTPIFP DPSTTWFP DPSTREFP DPSTSPFP
## Min. : 0.00000 Min. : 0.000 Min. : 0.0 Min. : 0.000
## 1st Qu.: 0.00000 1st Qu.: 0.000 1st Qu.: 71.4 1st Qu.: 4.400
## Median : 0.00000 Median : 0.000 Median : 77.3 Median : 7.000
## Mean : 0.09742 Mean : 0.749 Mean : 77.0 Mean : 7.018
## 3rd Qu.: 0.00000 3rd Qu.: 1.200 3rd Qu.: 82.7 3rd Qu.: 9.600
## Max. :10.90000 Max. :14.500 Max. :100.0 Max. :24.900
## NA's :1 NA's :1 NA's :1 NA's :1
## DPSTCOFP DPSTBIFP DPSTVOFP DPSTGOFP
## Min. : 0.000 Min. : 0.000 Min. : 0.000 Min. : 0.000
## 1st Qu.: 0.000 1st Qu.: 0.000 1st Qu.: 4.800 1st Qu.: 0.000
## Median : 3.200 Median : 0.100 Median : 6.900 Median : 1.100
## Mean : 3.863 Mean : 2.503 Mean : 7.106 Mean : 2.346
## 3rd Qu.: 5.650 3rd Qu.: 2.350 3rd Qu.: 9.450 3rd Qu.: 3.850
## Max. :40.100 Max. :94.400 Max. :69.500 Max. :33.800
## NA's :1 NA's :1 NA's :1 NA's :1
## DPFVTOTK DPFTADPR DPFRAALLT DPFRAALLK
## Min. : 0 Min. :0.000 Min. : -13046302 Min. :-12058
## 1st Qu.: 221083 1st Qu.:1.040 1st Qu.: 5696178 1st Qu.: 12041
## Median : 391200 Median :1.204 Median : 13294423 Median : 13553
## Mean : 623486 Mean :1.049 Mean : 57167786 Mean : 15033
## 3rd Qu.: 631718 3rd Qu.:1.330 3rd Qu.: 36386472 3rd Qu.: 15709
## Max. :21142016 Max. :1.661 Max. :2573062031 Max. :125639
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFRAOPRT DPFRASTAP DZRVLOCP DPFRAFEDP
## Min. : -20756772 Min. :-32.50 Min. :-31.80 Min. :-16.10
## 1st Qu.: 5320585 1st Qu.: 34.25 1st Qu.: 21.80 1st Qu.: 6.40
## Median : 11909879 Median : 52.40 Median : 35.90 Median : 9.70
## Mean : 49399479 Mean : 50.49 Mean : 39.07 Mean : 10.45
## 3rd Qu.: 31287249 3rd Qu.: 66.70 3rd Qu.: 55.60 3rd Qu.: 13.35
## Max. :2197175975 Max. :130.80 Max. :148.60 Max. : 49.40
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFRAORVT DPFUNAB1T DPFUNA4T DPFEAALLT
## Min. : -72916 Min. : -1895264 Min. :-8254969 Min. :4.215e+05
## 1st Qu.: 93502 1st Qu.: 1109211 1st Qu.: 0 1st Qu.:5.428e+06
## Median : 939740 Median : 3346331 Median : 0 Median :1.319e+07
## Mean : 7768307 Mean : 12756027 Mean : 438197 Mean :6.423e+07
## 3rd Qu.: 3802042 3rd Qu.: 9215692 3rd Qu.: 0 3rd Qu.:3.714e+07
## Max. :375886056 Max. :661759126 Max. :97852402 Max. :2.903e+09
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFEAOPFT DPFEAOPFK DPFEAINSP DZEXADMP
## Min. :4.215e+05 Min. : 6491 Min. :36.00 Min. : 2.800
## 1st Qu.:4.629e+06 1st Qu.:10206 1st Qu.:52.35 1st Qu.: 7.100
## Median :1.076e+07 Median :11404 Median :55.30 Median : 8.700
## Mean :4.755e+07 Mean :12188 Mean :55.02 Mean : 9.456
## 3rd Qu.:2.879e+07 3rd Qu.:13131 3rd Qu.:58.10 3rd Qu.:11.200
## Max. :2.034e+09 Max. :74959 Max. :78.90 Max. :33.500
## NA's :5 NA's :5 NA's :5 NA's :5
## DZEXADSP DZEXPLAP DZEXOTHP DPFEAINST
## Min. : 0.000 Min. : 0.10 Min. : 0.30 Min. :2.523e+05
## 1st Qu.: 5.100 1st Qu.:10.10 1st Qu.:15.20 1st Qu.:2.499e+06
## Median : 5.700 Median :11.50 Median :18.20 Median :5.929e+06
## Mean : 6.073 Mean :12.11 Mean :17.35 Mean :2.709e+07
## 3rd Qu.: 6.400 3rd Qu.:13.20 3rd Qu.:20.20 3rd Qu.:1.585e+07
## Max. :21.600 Max. :34.80 Max. :31.70 Max. :1.155e+09
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFEAINSK DPFPAREGP DPFPASPEP DPFPACOMP
## Min. : 3044 Min. : 0.00 Min. : 0.000 Min. : 0.000
## 1st Qu.: 5684 1st Qu.:36.40 1st Qu.: 5.700 1st Qu.: 6.300
## Median : 6261 Median :40.80 Median : 8.700 Median : 8.800
## Mean : 6645 Mean :41.00 Mean : 9.554 Mean : 9.451
## 3rd Qu.: 7150 3rd Qu.:45.05 3rd Qu.:12.400 3rd Qu.:11.600
## Max. :33649 Max. :81.40 Max. :47.600 Max. :90.200
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFPABILP DPFPAVOCP DPFPAGIFP DPFPAATHP
## Min. : 0.0000 Min. : 0.000 Min. :0.0000 Min. :0.000
## 1st Qu.: 0.1000 1st Qu.: 2.900 1st Qu.:0.1000 1st Qu.:1.700
## Median : 0.4000 Median : 4.000 Median :0.2000 Median :2.900
## Mean : 0.7319 Mean : 4.006 Mean :0.4117 Mean :2.798
## 3rd Qu.: 0.9000 3rd Qu.: 5.200 3rd Qu.:0.4000 3rd Qu.:3.900
## Max. :21.0000 Max. :30.400 Max. :7.6000 Max. :9.300
## NA's :5 NA's :5 NA's :5 NA's :5
## DPFPAHSAP DPFPREKP DPFPAOTHP DISTSIZE
## Min. :0.0000 Min. : 0.0000 Min. : 5.90 Length:1204
## 1st Qu.:0.0000 1st Qu.: 0.0000 1st Qu.:25.20 Class :character
## Median :0.1000 Median : 0.7000 Median :28.10 Mode :character
## Mean :0.3475 Mean : 0.9762 Mean :28.83
## 3rd Qu.:0.5000 3rd Qu.: 1.4000 3rd Qu.:31.90
## Max. :7.5000 Max. :36.3000 Max. :55.50
## NA's :5 NA's :5 NA's :5
## COMMTYPE PROPWLTH TAXRATE
## Length:1204 Length:1204 Length:1204
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
##
##
##
##
summary(district$DA0AT20R)
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## -1.00 98.30 98.70 98.34 99.00 100.00 4
district_clean<-district%>%filter(complete.cases(.))
str(district)
## tibble [1,204 × 140] (S3: tbl_df/tbl/data.frame)
## $ DISTNAME : chr [1:1204] "CAYUGA ISD" "ELKHART ISD" "FRANKSTON ISD" "NECHES ISD" ...
## $ DISTRICT : chr [1:1204] "001902" "001903" "001904" "001906" ...
## $ DZCNTYNM : chr [1:1204] "001 ANDERSON" "001 ANDERSON" "001 ANDERSON" "001 ANDERSON" ...
## $ REGION : chr [1:1204] "07" "07" "07" "07" ...
## $ DZRATING : chr [1:1204] "Not Rated: Declared State of Disaster" "Not Rated: Declared State of Disaster" "Not Rated: Declared State of Disaster" "Not Rated: Declared State of Disaster" ...
## $ DZCAMPUS : num [1:1204] 3 4 3 2 6 4 2 6 3 5 ...
## $ DPETALLC : num [1:1204] 535 1200 768 338 3398 ...
## $ DPETBLAP : num [1:1204] 4.1 4.4 10.3 7.1 26 19.8 0.8 0.8 14.9 7.4 ...
## $ DPETHISP : num [1:1204] 9.7 11.4 8.1 13.3 42.5 24.6 8.5 69.1 29.9 27.5 ...
## $ DPETWHIP : num [1:1204] 80.6 79.3 76.2 74.9 26.3 49.9 86.1 27.8 50.3 61 ...
## $ DPETINDP : num [1:1204] 0 0.3 0.4 0.3 0.3 0.7 0 0.4 0.2 0.4 ...
## $ DPETASIP : num [1:1204] 0.6 0.2 1.2 0.3 0.8 0.4 0.5 0.3 1.1 1.1 ...
## $ DPETPCIP : num [1:1204] 0 0.1 0 0 0.1 0 0 0 0.1 0 ...
## $ DPETTWOP : num [1:1204] 5 4.3 3.9 4.1 4.1 4.4 4.1 1.7 3.5 2.6 ...
## $ DPETECOP : num [1:1204] 37.8 47.6 55.6 49.7 80.2 68.6 41.5 46.6 50.8 52.3 ...
## $ DPETLEPP : num [1:1204] 0.4 2 3.1 2.1 15.7 6.7 0.3 12.8 4.9 6.7 ...
## $ DPETSPEP : num [1:1204] 14.6 12.3 12.8 9.2 12.9 14.3 13.9 9.4 10.4 10.7 ...
## $ DPETBILP : num [1:1204] 0.4 1.9 3.1 2.1 16 6.1 0.3 13.9 4.9 5.7 ...
## $ DPETVOCP : num [1:1204] 0 0 0 0 0 0 0 0 0 0 ...
## $ DPETGIFP : num [1:1204] 6.5 4.2 8.1 5 2.5 2.9 3.3 6.4 9.3 5.7 ...
## $ DA0AT20R : num [1:1204] 98.9 98.8 98.9 99 98.7 98.5 99.4 98.6 98.9 99 ...
## $ DA0912DR20R : num [1:1204] 0 0 0 0 0.1 0.4 0 0.9 0 0.8 ...
## $ DAGC4X20R : num [1:1204] 97.4 98.9 98 97 98.3 97 96.3 94.8 100 94.6 ...
## $ DAGC5X19R : num [1:1204] 96 98.8 33.3 100 98.1 97.4 100 96 100 95.9 ...
## $ DAGC6X18R : num [1:1204] 100 100 96.7 95.8 99.5 99 100 98.3 97.9 98.5 ...
## $ DA0GR20N : num [1:1204] 41 92 51 34 230 99 26 241 57 204 ...
## $ DA0GS20N : num [1:1204] 37 65 46 24 209 84 23 209 51 173 ...
## $ DDA00A001S21R: num [1:1204] 85 83 79 83 66 60 81 71 75 84 ...
## $ DDA00A001221R: num [1:1204] 60 54 52 53 38 32 49 42 49 58 ...
## $ DDA00A001321R: num [1:1204] 30 25 23 23 16 11 20 17 24 28 ...
## $ DDA00AR01S21R: num [1:1204] 83 83 76 78 64 56 83 70 75 83 ...
## $ DDA00AR01221R: num [1:1204] 64 57 52 52 39 32 57 44 50 57 ...
## $ DDA00AR01321R: num [1:1204] 32 28 21 22 15 10 25 16 23 26 ...
## $ DDA00AW01S21R: num [1:1204] 76 78 67 73 51 48 79 61 57 70 ...
## $ DDA00AW01221R: num [1:1204] 42 52 32 38 23 19 42 29 33 37 ...
## $ DDA00AW01321R: num [1:1204] 13 23 4 7 4 2 9 5 10 13 ...
## $ DDA00AM01S21R: num [1:1204] 89 84 85 89 69 60 77 74 78 87 ...
## $ DDA00AM01221R: num [1:1204] 67 50 55 58 37 28 35 42 49 64 ...
## $ DDA00AM01321R: num [1:1204] 37 23 25 26 17 11 14 19 26 33 ...
## $ DDA00AC01S21R: num [1:1204] 86 80 80 93 71 70 85 71 79 90 ...
## $ DDA00AC01221R: num [1:1204] 52 53 52 57 43 41 52 42 51 62 ...
## $ DDA00AC01321R: num [1:1204] 21 21 24 31 18 13 16 18 24 28 ...
## $ DDA00AS01S21R: num [1:1204] 81 91 81 81 70 75 86 72 76 88 ...
## $ DDA00AS01221R: num [1:1204] 54 64 62 51 45 41 64 47 54 60 ...
## $ DDA00AS01321R: num [1:1204] 26 32 43 23 24 17 31 27 32 34 ...
## $ DDB00A001S21R: num [1:1204] 59 49 63 68 52 50 -1 62 57 72 ...
## $ DDB00A001221R: num [1:1204] 31 21 34 41 24 24 -1 28 31 34 ...
## $ DDB00A001321R: num [1:1204] 10 4 6 23 7 9 -1 8 9 10 ...
## $ DDH00A001S21R: num [1:1204] 87 80 72 88 68 58 78 66 73 80 ...
## $ DDH00A001221R: num [1:1204] 50 53 44 58 38 30 47 37 40 53 ...
## $ DDH00A001321R: num [1:1204] 24 27 20 23 14 9 17 14 17 22 ...
## $ DDW00A001S21R: num [1:1204] 85 85 83 85 76 65 82 80 82 88 ...
## $ DDW00A001221R: num [1:1204] 63 56 57 54 51 36 50 53 60 64 ...
## $ DDW00A001321R: num [1:1204] 31 26 27 24 26 12 21 25 32 33 ...
## $ DDI00A001S21R: num [1:1204] NA 100 -1 -1 72 50 NA 77 100 48 ...
## $ DDI00A001221R: num [1:1204] NA 100 -1 -1 56 38 NA 62 100 24 ...
## $ DDI00A001321R: num [1:1204] NA 40 -1 -1 22 25 NA 35 80 0 ...
## $ DD300A001S21R: num [1:1204] 83 -1 72 -1 92 -1 -1 100 100 97 ...
## $ DD300A001221R: num [1:1204] 50 -1 17 -1 70 -1 -1 80 90 76 ...
## $ DD300A001321R: num [1:1204] 0 -1 6 -1 43 -1 -1 55 60 58 ...
## $ DD400A001S21R: num [1:1204] NA NA NA NA -1 NA NA NA -1 NA ...
## $ DD400A001221R: num [1:1204] NA NA NA NA -1 NA NA NA -1 NA ...
## $ DD400A001321R: num [1:1204] NA NA NA NA -1 NA NA NA -1 NA ...
## $ DD200A001S21R: num [1:1204] 80 75 60 86 60 61 71 86 63 83 ...
## $ DD200A001221R: num [1:1204] 57 48 38 57 40 30 38 61 38 49 ...
## $ DD200A001321R: num [1:1204] 30 21 23 14 17 9 4 32 16 20 ...
## $ DDE00A001S21R: num [1:1204] 79 75 74 81 63 55 73 62 70 76 ...
## $ DDE00A001221R: num [1:1204] 49 42 43 48 34 27 37 31 40 45 ...
## $ DDE00A001321R: num [1:1204] 21 15 18 14 13 9 13 11 16 17 ...
## $ DA0CT20R : num [1:1204] 31.7 59.8 96.1 73.5 36.5 47.5 50 71.4 42.1 60.3 ...
## $ DA0CC20R : num [1:1204] 30.8 27.3 26.5 32 46.4 21.3 69.2 22.7 33.3 62.6 ...
## $ DA0CSA20R : num [1:1204] 971 1005 984 1020 1042 ...
## $ DA0CAA20R : num [1:1204] -1 21 -1 -1 20.9 15.6 -1 18.8 -1 23 ...
## $ DPSATOFC : num [1:1204] 102.7 183.7 132.6 65.4 545.8 ...
## $ DPSTTOFC : num [1:1204] 47.6 102.2 65.4 35.5 261.6 ...
## $ DPSCTOFP : num [1:1204] 2.5 0.5 1.5 2.3 1.9 1.1 3 1.6 3.9 0.7 ...
## $ DPSSTOFP : num [1:1204] 4.1 2.9 3.8 4.6 3.2 3.5 3.6 2.7 3.1 3.9 ...
## $ DPSUTOFP : num [1:1204] 6.6 4.9 3.8 1.5 8.5 5.6 4.5 6.2 10.3 5.7 ...
## $ DPSTTOFP : num [1:1204] 46.3 55.6 49.3 54.2 47.9 47.9 53.6 51.3 52 49.8 ...
## $ DPSETOFP : num [1:1204] 13.7 17.2 15.1 12.2 19.5 17.7 10.1 13.3 11.6 7.8 ...
## $ DPSXTOFP : num [1:1204] 26.8 18.9 26.5 25.1 19 24.2 25.2 25 19.2 32.1 ...
## $ DPSCTOSA : num [1:1204] 79500 121000 97250 88657 98067 ...
## $ DPSSTOSA : num [1:1204] 71006 70164 69246 79291 78085 ...
## $ DPSUTOSA : num [1:1204] 56649 57372 54797 72643 63021 ...
## $ DPSTTOSA : num [1:1204] 55335 47689 50207 53700 48850 ...
## $ DPSAMIFP : num [1:1204] 14.4 10.1 11.5 16.8 30.5 25.2 2.9 40.7 22.5 18.1 ...
## $ DPSAKIDR : num [1:1204] 5.2 6.5 5.8 5.2 6.2 5.1 5.5 7.4 7.7 6.7 ...
## $ DPSTKIDR : num [1:1204] 11.2 11.7 11.7 9.5 13 10.7 10.2 14.3 14.8 13.4 ...
## $ DPST05FP : num [1:1204] 14.3 23.5 29.6 16.9 38.5 59.8 11.8 23.8 35.4 23.9 ...
## $ DPSTEXPA : num [1:1204] 16.7 13.7 13 14 11.3 7.7 16.9 13.4 10.2 13.6 ...
## $ DPSTADFP : num [1:1204] 10.2 19.3 24.3 7 18.5 18.1 18.4 23.2 21.6 19.6 ...
## $ DPSTURNR : num [1:1204] 12.9 21.7 15.7 17.4 14.6 34.5 10.6 12.2 12.4 6.9 ...
## $ DPSTBLFP : num [1:1204] 8.2 1 7.6 5.6 10.3 9.4 0 1.7 7.4 0.5 ...
## $ DPSTHIFP : num [1:1204] 2 6.8 0 0 13 4.7 0 26.3 8.9 5.2 ...
## $ DPSTWHFP : num [1:1204] 89.8 92.2 92.4 94.4 74.4 84.3 97.2 68.2 83.7 93.8 ...
## $ DPSTINFP : num [1:1204] 0 0 0 0 0.4 0.8 0 0.3 0 0 ...
## $ DPSTASFP : num [1:1204] 0 0 0 0 0 0 0 0.7 0 0 ...
## $ DPSTPIFP : num [1:1204] 0 0 0 0 0 0 0 0 0 0 ...
## $ DPSTTWFP : num [1:1204] 0 0 0 0 1.9 0.8 2.8 2.8 0 0.5 ...
## [list output truncated]
mean(district_clean$DA0AT20R)
## [1] 98.42844
table(district$DA0AT20R)
##
## -1 86.3 87.8 88.5 89.4 89.8 90.5 90.8 91.6 92.1 92.7 93.5 93.6 93.7 93.8 93.9
## 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 94 94.4 94.9 95.2 95.3 95.4 95.6 95.8 96 96.2 96.4 96.5 96.6 96.7 96.8 96.9
## 1 1 1 2 1 1 1 2 2 2 1 2 2 2 4 3
## 97 97.1 97.2 97.3 97.4 97.5 97.6 97.7 97.8 97.9 98 98.1 98.2 98.3 98.4 98.5
## 4 5 6 8 6 16 14 20 23 30 27 30 42 53 73 56
## 98.6 98.7 98.8 98.9 99 99.1 99.2 99.3 99.4 99.5 99.6 99.7 99.8 100
## 73 102 96 97 97 82 65 50 33 23 18 3 1 2
obj1<-table(district$DA0AT20R)
data <-c (-1.00,98.30,98.70,98.34,99.00,100.00,4)
hist(x=district$DA0AT20R)
plot(district$DA0AT20R,district$DAGC4X20R)
hist(district$DA0AT20R)
ggplot(district,aes(x=DA0AT20R))+geom_histogram()
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.
## Warning: Removed 4 rows containing non-finite outside the scale range
## (`stat_bin()`).
cor(district$DA0AT20R,district$DAGC4X20R)
## [1] NA
cor(district$DA0AT20R,district$DA0GR20N)
## [1] NA
mean(district$DAGC4X20R)
## [1] NA
compare_two<-district%>%select(DA0AT20R,PROPWLTH)
compare_two<-compare_two%>%filter(DA0AT20R>0)
ggplot(compare_two,aes(DA0AT20R,PROPWLTH))+geom_point()
cor(district_clean$DA0AT20R,district_clean$DA0GR20N)
## [1] -0.0682546