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.4 ✔ 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
library(readxl)
new_dist<-read.csv("ic2023_ay.csv")
summary(new_dist)
## UNITID XTUIT1 TUITION1 XFEE1
## Min. :100654 Length:3825 Length:3825 Length:3825
## 1st Qu.:156620 Class :character Class :character Class :character
## Median :198808 Mode :character Mode :character Mode :character
## Mean :236159
## 3rd Qu.:237987
## Max. :499662
## FEE1 XHRCHG1 HRCHG1 XTUIT2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## TUITION2 XFEE2 FEE2 XHRCHG2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## HRCHG2 XTUIT3 TUITION3 XFEE3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## FEE3 XHRCHG3 HRCHG3 XTUIT5
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## TUITION5 XFEE5 FEE5 XHRCHG5
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## HRCHG5 XTUIT6 TUITION6 XFEE6
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## FEE6 XHRCHG6 HRCHG6 XTUIT7
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## TUITION7 XFEE7 FEE7 XHRCHG7
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## HRCHG7 XISPRO1 ISPROF1 XISPFE1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE1 XOSPRO1 OSPROF1 XOSPFE1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE1 XISPRO2 ISPROF2 XISPFE2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE2 XOSPRO2 OSPROF2 XOSPFE2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE2 XISPRO3 ISPROF3 XISPFE3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE3 XOSPRO3 OSPROF3 XOSPFE3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE3 XISPRO4 ISPROF4 XISPFE4
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE4 XOSPRO4 OSPROF4 XOSPFE4
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE4 XISPRO5 ISPROF5 XISPFE5
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE5 XOSPRO5 OSPROF5 XOSPFE5
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE5 XISPRO6 ISPROF6 XISPFE6
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE6 XOSPRO6 OSPROF6 XOSPFE6
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE6 XISPRO7 ISPROF7 XISPFE7
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE7 XOSPRO7 OSPROF7 XOSPFE7
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE7 XISPRO8 ISPROF8 XISPFE8
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE8 XOSPRO8 OSPROF8 XOSPFE8
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE8 XISPRO9 ISPROF9 XISPFE9
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## ISPFEE9 XOSPRO9 OSPROF9 XOSPFE9
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## OSPFEE9 XCHG1AT0 CHG1AT0 XCHG1AF0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AF0 XCHG1AY0 CHG1AY0 XCHG1AT1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AT1 XCHG1AF1 CHG1AF1 XCHG1AY1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AY1 XCHG1AT2 CHG1AT2 XCHG1AF2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AF2 XCHG1AY2 CHG1AY2 XCHG1AT3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AT3 XCHG1AF3 CHG1AF3 XCHG1AY3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG1AY3 CHG1TGTD CHG1FGTD XCHG2AT0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AT0 XCHG2AF0 CHG2AF0 XCHG2AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AY0 XCHG2AT1 CHG2AT1 XCHG2AF1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AF1 XCHG2AY1 CHG2AY1 XCHG2AT2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AT2 XCHG2AF2 CHG2AF2 XCHG2AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AY2 XCHG2AT3 CHG2AT3 XCHG2AF3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2AF3 XCHG2AY3 CHG2AY3 CHG2TGTD
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG2FGTD XCHG3AT0 CHG3AT0 XCHG3AF0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AF0 XCHG3AY0 CHG3AY0 XCHG3AT1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AT1 XCHG3AF1 CHG3AF1 XCHG3AY1
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AY1 XCHG3AT2 CHG3AT2 XCHG3AF2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AF2 XCHG3AY2 CHG3AY2 XCHG3AT3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AT3 XCHG3AF3 CHG3AF3 XCHG3AY3
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG3AY3 CHG3TGTD CHG3FGTD XCHG4AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG4AY0 XCHG4AY1 CHG4AY1 XCHG4AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG4AY2 XCHG4AY3 CHG4AY3 XCHG5AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG5AY0 XCHG5AY1 CHG5AY1 XCHG5AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG5AY2 XCHG5AY3 CHG5AY3 XCHG6AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG6AY0 XCHG6AY1 CHG6AY1 XCHG6AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG6AY2 XCHG6AY3 CHG6AY3 XCHG7AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG7AY0 XCHG7AY1 CHG7AY1 XCHG7AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG7AY2 XCHG7AY3 CHG7AY3 XCHG8AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG8AY0 XCHG8AY1 CHG8AY1 XCHG8AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG8AY2 XCHG8AY3 CHG8AY3 XCHG9AY0
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG9AY0 XCHG9AY1 CHG9AY1 XCHG9AY2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## CHG9AY2 XCHG9AY3 CHG9AY3
## Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
##
##
##
colnames(new_dist)
## [1] "UNITID" "XTUIT1" "TUITION1" "XFEE1" "FEE1" "XHRCHG1"
## [7] "HRCHG1" "XTUIT2" "TUITION2" "XFEE2" "FEE2" "XHRCHG2"
## [13] "HRCHG2" "XTUIT3" "TUITION3" "XFEE3" "FEE3" "XHRCHG3"
## [19] "HRCHG3" "XTUIT5" "TUITION5" "XFEE5" "FEE5" "XHRCHG5"
## [25] "HRCHG5" "XTUIT6" "TUITION6" "XFEE6" "FEE6" "XHRCHG6"
## [31] "HRCHG6" "XTUIT7" "TUITION7" "XFEE7" "FEE7" "XHRCHG7"
## [37] "HRCHG7" "XISPRO1" "ISPROF1" "XISPFE1" "ISPFEE1" "XOSPRO1"
## [43] "OSPROF1" "XOSPFE1" "OSPFEE1" "XISPRO2" "ISPROF2" "XISPFE2"
## [49] "ISPFEE2" "XOSPRO2" "OSPROF2" "XOSPFE2" "OSPFEE2" "XISPRO3"
## [55] "ISPROF3" "XISPFE3" "ISPFEE3" "XOSPRO3" "OSPROF3" "XOSPFE3"
## [61] "OSPFEE3" "XISPRO4" "ISPROF4" "XISPFE4" "ISPFEE4" "XOSPRO4"
## [67] "OSPROF4" "XOSPFE4" "OSPFEE4" "XISPRO5" "ISPROF5" "XISPFE5"
## [73] "ISPFEE5" "XOSPRO5" "OSPROF5" "XOSPFE5" "OSPFEE5" "XISPRO6"
## [79] "ISPROF6" "XISPFE6" "ISPFEE6" "XOSPRO6" "OSPROF6" "XOSPFE6"
## [85] "OSPFEE6" "XISPRO7" "ISPROF7" "XISPFE7" "ISPFEE7" "XOSPRO7"
## [91] "OSPROF7" "XOSPFE7" "OSPFEE7" "XISPRO8" "ISPROF8" "XISPFE8"
## [97] "ISPFEE8" "XOSPRO8" "OSPROF8" "XOSPFE8" "OSPFEE8" "XISPRO9"
## [103] "ISPROF9" "XISPFE9" "ISPFEE9" "XOSPRO9" "OSPROF9" "XOSPFE9"
## [109] "OSPFEE9" "XCHG1AT0" "CHG1AT0" "XCHG1AF0" "CHG1AF0" "XCHG1AY0"
## [115] "CHG1AY0" "XCHG1AT1" "CHG1AT1" "XCHG1AF1" "CHG1AF1" "XCHG1AY1"
## [121] "CHG1AY1" "XCHG1AT2" "CHG1AT2" "XCHG1AF2" "CHG1AF2" "XCHG1AY2"
## [127] "CHG1AY2" "XCHG1AT3" "CHG1AT3" "XCHG1AF3" "CHG1AF3" "XCHG1AY3"
## [133] "CHG1AY3" "CHG1TGTD" "CHG1FGTD" "XCHG2AT0" "CHG2AT0" "XCHG2AF0"
## [139] "CHG2AF0" "XCHG2AY0" "CHG2AY0" "XCHG2AT1" "CHG2AT1" "XCHG2AF1"
## [145] "CHG2AF1" "XCHG2AY1" "CHG2AY1" "XCHG2AT2" "CHG2AT2" "XCHG2AF2"
## [151] "CHG2AF2" "XCHG2AY2" "CHG2AY2" "XCHG2AT3" "CHG2AT3" "XCHG2AF3"
## [157] "CHG2AF3" "XCHG2AY3" "CHG2AY3" "CHG2TGTD" "CHG2FGTD" "XCHG3AT0"
## [163] "CHG3AT0" "XCHG3AF0" "CHG3AF0" "XCHG3AY0" "CHG3AY0" "XCHG3AT1"
## [169] "CHG3AT1" "XCHG3AF1" "CHG3AF1" "XCHG3AY1" "CHG3AY1" "XCHG3AT2"
## [175] "CHG3AT2" "XCHG3AF2" "CHG3AF2" "XCHG3AY2" "CHG3AY2" "XCHG3AT3"
## [181] "CHG3AT3" "XCHG3AF3" "CHG3AF3" "XCHG3AY3" "CHG3AY3" "CHG3TGTD"
## [187] "CHG3FGTD" "XCHG4AY0" "CHG4AY0" "XCHG4AY1" "CHG4AY1" "XCHG4AY2"
## [193] "CHG4AY2" "XCHG4AY3" "CHG4AY3" "XCHG5AY0" "CHG5AY0" "XCHG5AY1"
## [199] "CHG5AY1" "XCHG5AY2" "CHG5AY2" "XCHG5AY3" "CHG5AY3" "XCHG6AY0"
## [205] "CHG6AY0" "XCHG6AY1" "CHG6AY1" "XCHG6AY2" "CHG6AY2" "XCHG6AY3"
## [211] "CHG6AY3" "XCHG7AY0" "CHG7AY0" "XCHG7AY1" "CHG7AY1" "XCHG7AY2"
## [217] "CHG7AY2" "XCHG7AY3" "CHG7AY3" "XCHG8AY0" "CHG8AY0" "XCHG8AY1"
## [223] "CHG8AY1" "XCHG8AY2" "CHG8AY2" "XCHG8AY3" "CHG8AY3" "XCHG9AY0"
## [229] "CHG9AY0" "XCHG9AY1" "CHG9AY1" "XCHG9AY2" "CHG9AY2" "XCHG9AY3"
## [235] "CHG9AY3"
str(new_dist)
## 'data.frame': 3825 obs. of 235 variables:
## $ UNITID : int 100654 100663 100690 100706 100724 100751 100760 100812 100830 100858 ...
## $ XTUIT1 : chr "R" "R" "R" "R" ...
## $ TUITION1: chr "8610" "8832" "9480" "10120" ...
## $ XFEE1 : chr "R" "R" "R" "R" ...
## $ FEE1 : chr "1414" "0" "990" "1758" ...
## $ XHRCHG1 : chr "R" "R" "R" "R" ...
## $ HRCHG1 : chr "287" "368" "455" "421" ...
## $ XTUIT2 : chr "R" "R" "R" "R" ...
## $ TUITION2: chr "8610" "8832" "9480" "10120" ...
## $ XFEE2 : chr "R" "R" "R" "R" ...
## $ FEE2 : chr "1414" "0" "990" "1758" ...
## $ XHRCHG2 : chr "R" "R" "R" "R" ...
## $ HRCHG2 : chr "287" "368" "455" "421" ...
## $ XTUIT3 : chr "R" "R" "R" "R" ...
## $ TUITION3: chr "17220" "21864" "9480" "23012" ...
## $ XFEE3 : chr "R" "R" "R" "R" ...
## $ FEE3 : chr "1414" "0" "990" "1758" ...
## $ XHRCHG3 : chr "R" "R" "R" "R" ...
## $ HRCHG3 : chr "574" "911" "455" "958" ...
## $ XTUIT5 : chr "R" "R" "R" "R" ...
## $ TUITION5: chr "10128" "8424" "11700" "10632" ...
## $ XFEE5 : chr "R" "R" "R" "R" ...
## $ FEE5 : chr "1414" "0" "1390" "1054" ...
## $ XHRCHG5 : chr "R" "R" "R" "R" ...
## $ HRCHG5 : chr "422" "468" "750" "708" ...
## $ XTUIT6 : chr "R" "R" "R" "R" ...
## $ TUITION6: chr "10128" "8424" "11700" "10632" ...
## $ XFEE6 : chr "R" "R" "R" "R" ...
## $ FEE6 : chr "1414" "0" "1390" "1054" ...
## $ XHRCHG6 : chr "R" "R" "R" "R" ...
## $ HRCHG6 : chr "422" "468" "750" "708" ...
## $ XTUIT7 : chr "R" "R" "R" "R" ...
## $ TUITION7: chr "20160" "20556" "11700" "24430" ...
## $ XFEE7 : chr "R" "R" "R" "R" ...
## $ FEE7 : chr "1414" "0" "1390" "1054" ...
## $ XHRCHG7 : chr "R" "R" "R" "R" ...
## $ HRCHG7 : chr "840" "1142" "750" "1628" ...
## $ XISPRO1 : chr "A" "Y" "A" "A" ...
## $ ISPROF1 : chr "." "." "." "." ...
## $ XISPFE1 : chr "A" "Y" "A" "A" ...
## $ ISPFEE1 : chr "." "." "." "." ...
## $ XOSPRO1 : chr "A" "Y" "A" "A" ...
## $ OSPROF1 : chr "." "." "." "." ...
## $ XOSPFE1 : chr "A" "Y" "A" "A" ...
## $ OSPFEE1 : chr "." "." "." "." ...
## $ XISPRO2 : chr "A" "R" "A" "A" ...
## $ ISPROF2 : chr "." "31902" "." "." ...
## $ XISPFE2 : chr "A" "R" "A" "A" ...
## $ ISPFEE2 : chr "." "0" "." "." ...
## $ XOSPRO2 : chr "A" "R" "A" "A" ...
## $ OSPROF2 : chr "." "74362" "." "." ...
## $ XOSPFE2 : chr "A" "R" "A" "A" ...
## $ OSPFEE2 : chr "." "0" "." "." ...
## $ XISPRO3 : chr "A" "R" "A" "A" ...
## $ ISPROF3 : chr "." "32134" "." "." ...
## $ XISPFE3 : chr "A" "R" "A" "A" ...
## $ ISPFEE3 : chr "." "0" "." "." ...
## $ XOSPRO3 : chr "A" "R" "A" "A" ...
## $ OSPROF3 : chr "." "62714" "." "." ...
## $ XOSPFE3 : chr "A" "R" "A" "A" ...
## $ OSPFEE3 : chr "." "0" "." "." ...
## $ XISPRO4 : chr "A" "R" "A" "A" ...
## $ ISPROF4 : chr "." "29841" "." "." ...
## $ XISPFE4 : chr "A" "R" "A" "A" ...
## $ ISPFEE4 : chr "." "0" "." "." ...
## $ XOSPRO4 : chr "A" "R" "A" "A" ...
## $ OSPROF4 : chr "." "54012" "." "." ...
## $ XOSPFE4 : chr "A" "R" "A" "A" ...
## $ OSPFEE4 : chr "." "0" "." "." ...
## $ XISPRO5 : chr "A" "Y" "A" "A" ...
## $ ISPROF5 : chr "." "." "." "." ...
## $ XISPFE5 : chr "A" "Y" "A" "A" ...
## $ ISPFEE5 : chr "." "." "." "." ...
## $ XOSPRO5 : chr "A" "Y" "A" "A" ...
## $ OSPROF5 : chr "." "." "." "." ...
## $ XOSPFE5 : chr "A" "Y" "A" "A" ...
## $ OSPFEE5 : chr "." "." "." "." ...
## $ XISPRO6 : chr "A" "Y" "A" "A" ...
## $ ISPROF6 : chr "." "." "." "." ...
## $ XISPFE6 : chr "A" "Y" "A" "A" ...
## $ ISPFEE6 : chr "." "." "." "." ...
## $ XOSPRO6 : chr "A" "Y" "A" "A" ...
## $ OSPROF6 : chr "." "." "." "." ...
## $ XOSPFE6 : chr "A" "Y" "A" "A" ...
## $ OSPFEE6 : chr "." "." "." "." ...
## $ XISPRO7 : chr "A" "Y" "A" "A" ...
## $ ISPROF7 : chr "." "." "." "." ...
## $ XISPFE7 : chr "A" "Y" "A" "A" ...
## $ ISPFEE7 : chr "." "." "." "." ...
## $ XOSPRO7 : chr "A" "Y" "A" "A" ...
## $ OSPROF7 : chr "." "." "." "." ...
## $ XOSPFE7 : chr "A" "Y" "A" "A" ...
## $ OSPFEE7 : chr "." "." "." "." ...
## $ XISPRO8 : chr "A" "Y" "A" "A" ...
## $ ISPROF8 : chr "." "." "." "." ...
## $ XISPFE8 : chr "A" "Y" "A" "A" ...
## $ ISPFEE8 : chr "." "." "." "." ...
## $ XOSPRO8 : chr "A" "Y" "A" "A" ...
## $ OSPROF8 : chr "." "." "." "." ...
## [list output truncated]
head(new_dist[, c("TUITION1", "TUITION2", "FEE1","FEE2")])
## TUITION1 TUITION2 FEE1 FEE2
## 1 8610 8610 1414 1414
## 2 8832 8832 0 0
## 3 9480 9480 990 990
## 4 10120 10120 1758 1758
## 5 8328 8328 2920 2920
## 6 11100 11100 800 800
summary(new_dist[, c("TUITION1","TUITION2","FEE1","FEE2")])
## TUITION1 TUITION2 FEE1 FEE2
## Length:3825 Length:3825 Length:3825 Length:3825
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
new_dist$TUITION1 <- as.numeric(new_dist$TUITION1)
## Warning: NAs introduced by coercion
new_dist$TUITION2 <- as.numeric(new_dist$TUITION2)
## Warning: NAs introduced by coercion
new_dist$FEE1 <- as.numeric(new_dist$FEE1)
## Warning: NAs introduced by coercion
new_dist$FEE2 <- as.numeric(new_dist$FEE2)
## Warning: NAs introduced by coercion
summary(new_dist[, c("TUITION1", "TUITION2", "FEE1", "FEE2")])
## TUITION1 TUITION2 FEE1 FEE2
## Min. : 0 Min. : 0 Min. : 0 Min. : 0
## 1st Qu.: 4740 1st Qu.: 5160 1st Qu.: 250 1st Qu.: 250
## Median :10500 Median :10700 Median : 766 Median : 770
## Mean :16475 Mean :16653 Mean : 1091 Mean : 1100
## 3rd Qu.:23000 3rd Qu.:23000 3rd Qu.: 1463 3rd Qu.: 1470
## Max. :85000 Max. :85000 Max. :25017 Max. :25017
## NA's :288 NA's :288 NA's :288 NA's :288
# Histogram for TUITION1 (In-State Tuition)
hist(new_dist$TUITION1, main="Distribution of In-State Tuition", xlab="Tuition (USD)", col="lightblue", breaks=30)
# Histogram for TUITION2 (Out-of-State Tuition)
hist(new_dist$TUITION2, main="Distribution of Out-of-State Tuition", xlab="Tuition (USD)", col="lightgreen", breaks=30)
colnames(new_dist)
## [1] "UNITID" "XTUIT1" "TUITION1" "XFEE1" "FEE1" "XHRCHG1"
## [7] "HRCHG1" "XTUIT2" "TUITION2" "XFEE2" "FEE2" "XHRCHG2"
## [13] "HRCHG2" "XTUIT3" "TUITION3" "XFEE3" "FEE3" "XHRCHG3"
## [19] "HRCHG3" "XTUIT5" "TUITION5" "XFEE5" "FEE5" "XHRCHG5"
## [25] "HRCHG5" "XTUIT6" "TUITION6" "XFEE6" "FEE6" "XHRCHG6"
## [31] "HRCHG6" "XTUIT7" "TUITION7" "XFEE7" "FEE7" "XHRCHG7"
## [37] "HRCHG7" "XISPRO1" "ISPROF1" "XISPFE1" "ISPFEE1" "XOSPRO1"
## [43] "OSPROF1" "XOSPFE1" "OSPFEE1" "XISPRO2" "ISPROF2" "XISPFE2"
## [49] "ISPFEE2" "XOSPRO2" "OSPROF2" "XOSPFE2" "OSPFEE2" "XISPRO3"
## [55] "ISPROF3" "XISPFE3" "ISPFEE3" "XOSPRO3" "OSPROF3" "XOSPFE3"
## [61] "OSPFEE3" "XISPRO4" "ISPROF4" "XISPFE4" "ISPFEE4" "XOSPRO4"
## [67] "OSPROF4" "XOSPFE4" "OSPFEE4" "XISPRO5" "ISPROF5" "XISPFE5"
## [73] "ISPFEE5" "XOSPRO5" "OSPROF5" "XOSPFE5" "OSPFEE5" "XISPRO6"
## [79] "ISPROF6" "XISPFE6" "ISPFEE6" "XOSPRO6" "OSPROF6" "XOSPFE6"
## [85] "OSPFEE6" "XISPRO7" "ISPROF7" "XISPFE7" "ISPFEE7" "XOSPRO7"
## [91] "OSPROF7" "XOSPFE7" "OSPFEE7" "XISPRO8" "ISPROF8" "XISPFE8"
## [97] "ISPFEE8" "XOSPRO8" "OSPROF8" "XOSPFE8" "OSPFEE8" "XISPRO9"
## [103] "ISPROF9" "XISPFE9" "ISPFEE9" "XOSPRO9" "OSPROF9" "XOSPFE9"
## [109] "OSPFEE9" "XCHG1AT0" "CHG1AT0" "XCHG1AF0" "CHG1AF0" "XCHG1AY0"
## [115] "CHG1AY0" "XCHG1AT1" "CHG1AT1" "XCHG1AF1" "CHG1AF1" "XCHG1AY1"
## [121] "CHG1AY1" "XCHG1AT2" "CHG1AT2" "XCHG1AF2" "CHG1AF2" "XCHG1AY2"
## [127] "CHG1AY2" "XCHG1AT3" "CHG1AT3" "XCHG1AF3" "CHG1AF3" "XCHG1AY3"
## [133] "CHG1AY3" "CHG1TGTD" "CHG1FGTD" "XCHG2AT0" "CHG2AT0" "XCHG2AF0"
## [139] "CHG2AF0" "XCHG2AY0" "CHG2AY0" "XCHG2AT1" "CHG2AT1" "XCHG2AF1"
## [145] "CHG2AF1" "XCHG2AY1" "CHG2AY1" "XCHG2AT2" "CHG2AT2" "XCHG2AF2"
## [151] "CHG2AF2" "XCHG2AY2" "CHG2AY2" "XCHG2AT3" "CHG2AT3" "XCHG2AF3"
## [157] "CHG2AF3" "XCHG2AY3" "CHG2AY3" "CHG2TGTD" "CHG2FGTD" "XCHG3AT0"
## [163] "CHG3AT0" "XCHG3AF0" "CHG3AF0" "XCHG3AY0" "CHG3AY0" "XCHG3AT1"
## [169] "CHG3AT1" "XCHG3AF1" "CHG3AF1" "XCHG3AY1" "CHG3AY1" "XCHG3AT2"
## [175] "CHG3AT2" "XCHG3AF2" "CHG3AF2" "XCHG3AY2" "CHG3AY2" "XCHG3AT3"
## [181] "CHG3AT3" "XCHG3AF3" "CHG3AF3" "XCHG3AY3" "CHG3AY3" "CHG3TGTD"
## [187] "CHG3FGTD" "XCHG4AY0" "CHG4AY0" "XCHG4AY1" "CHG4AY1" "XCHG4AY2"
## [193] "CHG4AY2" "XCHG4AY3" "CHG4AY3" "XCHG5AY0" "CHG5AY0" "XCHG5AY1"
## [199] "CHG5AY1" "XCHG5AY2" "CHG5AY2" "XCHG5AY3" "CHG5AY3" "XCHG6AY0"
## [205] "CHG6AY0" "XCHG6AY1" "CHG6AY1" "XCHG6AY2" "CHG6AY2" "XCHG6AY3"
## [211] "CHG6AY3" "XCHG7AY0" "CHG7AY0" "XCHG7AY1" "CHG7AY1" "XCHG7AY2"
## [217] "CHG7AY2" "XCHG7AY3" "CHG7AY3" "XCHG8AY0" "CHG8AY0" "XCHG8AY1"
## [223] "CHG8AY1" "XCHG8AY2" "CHG8AY2" "XCHG8AY3" "CHG8AY3" "XCHG9AY0"
## [229] "CHG9AY0" "XCHG9AY1" "CHG9AY1" "XCHG9AY2" "CHG9AY2" "XCHG9AY3"
## [235] "CHG9AY3"
grep("enroll", colnames(new_dist), ignore.case = TRUE, value = TRUE)
## character(0)
grep("student|head|total", colnames(new_dist), ignore.case = TRUE, value = TRUE)
## character(0)
colnames(new_dist)[1:50]
## [1] "UNITID" "XTUIT1" "TUITION1" "XFEE1" "FEE1" "XHRCHG1"
## [7] "HRCHG1" "XTUIT2" "TUITION2" "XFEE2" "FEE2" "XHRCHG2"
## [13] "HRCHG2" "XTUIT3" "TUITION3" "XFEE3" "FEE3" "XHRCHG3"
## [19] "HRCHG3" "XTUIT5" "TUITION5" "XFEE5" "FEE5" "XHRCHG5"
## [25] "HRCHG5" "XTUIT6" "TUITION6" "XFEE6" "FEE6" "XHRCHG6"
## [31] "HRCHG6" "XTUIT7" "TUITION7" "XFEE7" "FEE7" "XHRCHG7"
## [37] "HRCHG7" "XISPRO1" "ISPROF1" "XISPFE1" "ISPFEE1" "XOSPRO1"
## [43] "OSPROF1" "XOSPFE1" "OSPFEE1" "XISPRO2" "ISPROF2" "XISPFE2"
## [49] "ISPFEE2" "XOSPRO2"
colnames(new_dist)[51:100]
## [1] "OSPROF2" "XOSPFE2" "OSPFEE2" "XISPRO3" "ISPROF3" "XISPFE3" "ISPFEE3"
## [8] "XOSPRO3" "OSPROF3" "XOSPFE3" "OSPFEE3" "XISPRO4" "ISPROF4" "XISPFE4"
## [15] "ISPFEE4" "XOSPRO4" "OSPROF4" "XOSPFE4" "OSPFEE4" "XISPRO5" "ISPROF5"
## [22] "XISPFE5" "ISPFEE5" "XOSPRO5" "OSPROF5" "XOSPFE5" "OSPFEE5" "XISPRO6"
## [29] "ISPROF6" "XISPFE6" "ISPFEE6" "XOSPRO6" "OSPROF6" "XOSPFE6" "OSPFEE6"
## [36] "XISPRO7" "ISPROF7" "XISPFE7" "ISPFEE7" "XOSPRO7" "OSPROF7" "XOSPFE7"
## [43] "OSPFEE7" "XISPRO8" "ISPROF8" "XISPFE8" "ISPFEE8" "XOSPRO8" "OSPROF8"
## [50] "XOSPFE8"
colnames(new_dist)[101:150]
## [1] "OSPFEE8" "XISPRO9" "ISPROF9" "XISPFE9" "ISPFEE9" "XOSPRO9"
## [7] "OSPROF9" "XOSPFE9" "OSPFEE9" "XCHG1AT0" "CHG1AT0" "XCHG1AF0"
## [13] "CHG1AF0" "XCHG1AY0" "CHG1AY0" "XCHG1AT1" "CHG1AT1" "XCHG1AF1"
## [19] "CHG1AF1" "XCHG1AY1" "CHG1AY1" "XCHG1AT2" "CHG1AT2" "XCHG1AF2"
## [25] "CHG1AF2" "XCHG1AY2" "CHG1AY2" "XCHG1AT3" "CHG1AT3" "XCHG1AF3"
## [31] "CHG1AF3" "XCHG1AY3" "CHG1AY3" "CHG1TGTD" "CHG1FGTD" "XCHG2AT0"
## [37] "CHG2AT0" "XCHG2AF0" "CHG2AF0" "XCHG2AY0" "CHG2AY0" "XCHG2AT1"
## [43] "CHG2AT1" "XCHG2AF1" "CHG2AF1" "XCHG2AY1" "CHG2AY1" "XCHG2AT2"
## [49] "CHG2AT2" "XCHG2AF2"
colnames(new_dist)[151:200]
## [1] "CHG2AF2" "XCHG2AY2" "CHG2AY2" "XCHG2AT3" "CHG2AT3" "XCHG2AF3"
## [7] "CHG2AF3" "XCHG2AY3" "CHG2AY3" "CHG2TGTD" "CHG2FGTD" "XCHG3AT0"
## [13] "CHG3AT0" "XCHG3AF0" "CHG3AF0" "XCHG3AY0" "CHG3AY0" "XCHG3AT1"
## [19] "CHG3AT1" "XCHG3AF1" "CHG3AF1" "XCHG3AY1" "CHG3AY1" "XCHG3AT2"
## [25] "CHG3AT2" "XCHG3AF2" "CHG3AF2" "XCHG3AY2" "CHG3AY2" "XCHG3AT3"
## [31] "CHG3AT3" "XCHG3AF3" "CHG3AF3" "XCHG3AY3" "CHG3AY3" "CHG3TGTD"
## [37] "CHG3FGTD" "XCHG4AY0" "CHG4AY0" "XCHG4AY1" "CHG4AY1" "XCHG4AY2"
## [43] "CHG4AY2" "XCHG4AY3" "CHG4AY3" "XCHG5AY0" "CHG5AY0" "XCHG5AY1"
## [49] "CHG5AY1" "XCHG5AY2"
head(new_dist, 5)
## UNITID XTUIT1 TUITION1 XFEE1 FEE1 XHRCHG1 HRCHG1 XTUIT2 TUITION2 XFEE2 FEE2
## 1 100654 R 8610 R 1414 R 287 R 8610 R 1414
## 2 100663 R 8832 R 0 R 368 R 8832 R 0
## 3 100690 R 9480 R 990 R 455 R 9480 R 990
## 4 100706 R 10120 R 1758 R 421 R 10120 R 1758
## 5 100724 R 8328 R 2920 R 347 R 8328 R 2920
## XHRCHG2 HRCHG2 XTUIT3 TUITION3 XFEE3 FEE3 XHRCHG3 HRCHG3 XTUIT5 TUITION5
## 1 R 287 R 17220 R 1414 R 574 R 10128
## 2 R 368 R 21864 R 0 R 911 R 8424
## 3 R 455 R 9480 R 990 R 455 R 11700
## 4 R 421 R 23012 R 1758 R 958 R 10632
## 5 R 347 R 16656 R 2920 R 694 R 7416
## XFEE5 FEE5 XHRCHG5 HRCHG5 XTUIT6 TUITION6 XFEE6 FEE6 XHRCHG6 HRCHG6 XTUIT7
## 1 R 1414 R 422 R 10128 R 1414 R 422 R
## 2 R 0 R 468 R 8424 R 0 R 468 R
## 3 R 1390 R 750 R 11700 R 1390 R 750 R
## 4 R 1054 R 708 R 10632 R 1054 R 708 R
## 5 R 2920 R 412 R 7416 R 2920 R 412 R
## TUITION7 XFEE7 FEE7 XHRCHG7 HRCHG7 XISPRO1 ISPROF1 XISPFE1 ISPFEE1 XOSPRO1
## 1 20160 R 1414 R 840 A . A . A
## 2 20556 R 0 R 1142 Y . Y . Y
## 3 11700 R 1390 R 750 A . A . A
## 4 24430 R 1054 R 1628 A . A . A
## 5 14832 R 2920 R 824 A . A . A
## OSPROF1 XOSPFE1 OSPFEE1 XISPRO2 ISPROF2 XISPFE2 ISPFEE2 XOSPRO2 OSPROF2
## 1 . A . A . A . A .
## 2 . Y . R 31902 R 0 R 74362
## 3 . A . A . A . A .
## 4 . A . A . A . A .
## 5 . A . A . A . A .
## XOSPFE2 OSPFEE2 XISPRO3 ISPROF3 XISPFE3 ISPFEE3 XOSPRO3 OSPROF3 XOSPFE3
## 1 A . A . A . A . A
## 2 R 0 R 32134 R 0 R 62714 R
## 3 A . A . A . A . A
## 4 A . A . A . A . A
## 5 A . A . A . A . A
## OSPFEE3 XISPRO4 ISPROF4 XISPFE4 ISPFEE4 XOSPRO4 OSPROF4 XOSPFE4 OSPFEE4
## 1 . A . A . A . A .
## 2 0 R 29841 R 0 R 54012 R 0
## 3 . A . A . A . A .
## 4 . A . A . A . A .
## 5 . A . A . A . A .
## XISPRO5 ISPROF5 XISPFE5 ISPFEE5 XOSPRO5 OSPROF5 XOSPFE5 OSPFEE5 XISPRO6
## 1 A . A . A . A . A
## 2 Y . Y . Y . Y . Y
## 3 A . A . A . A . A
## 4 A . A . A . A . A
## 5 A . A . A . A . A
## ISPROF6 XISPFE6 ISPFEE6 XOSPRO6 OSPROF6 XOSPFE6 OSPFEE6 XISPRO7 ISPROF7
## 1 . A . A . A . A .
## 2 . Y . Y . Y . Y .
## 3 . A . A . A . A .
## 4 . A . A . A . A .
## 5 . A . A . A . A .
## XISPFE7 ISPFEE7 XOSPRO7 OSPROF7 XOSPFE7 OSPFEE7 XISPRO8 ISPROF8 XISPFE8
## 1 A . A . A . A . A
## 2 Y . Y . Y . Y . Y
## 3 A . A . A . A . A
## 4 A . A . A . A . A
## 5 A . A . A . A . A
## ISPFEE8 XOSPRO8 OSPROF8 XOSPFE8 OSPFEE8 XISPRO9 ISPROF9 XISPFE9 ISPFEE9
## 1 . A . A . A . A .
## 2 . Y . Y . Y . Y .
## 3 . A . A . A . A .
## 4 . A . A . A . A .
## 5 . A . A . A . A .
## XOSPRO9 OSPROF9 XOSPFE9 OSPFEE9 XCHG1AT0 CHG1AT0 XCHG1AF0 CHG1AF0 XCHG1AY0
## 1 A . A . R 8610 R 1414 R
## 2 Y . Y . R 8568 R 0 R
## 3 A . A . A . A . A
## 4 A . A . R 9730 R 1608 R
## 5 A . A . R 8328 R 2740 R
## CHG1AY0 XCHG1AT1 CHG1AT1 XCHG1AF1 CHG1AF1 XCHG1AY1 CHG1AY1 XCHG1AT2 CHG1AT2
## 1 10024 R 8610 R 1414 R 10024 R 8610
## 2 8568 R 8568 R 0 R 8568 R 8832
## 3 . A . A . A . A .
## 4 11338 R 9730 R 1758 R 11488 R 10120
## 5 11068 R 8328 R 2740 R 11068 R 8328
## XCHG1AF2 CHG1AF2 XCHG1AY2 CHG1AY2 XCHG1AT3 CHG1AT3 XCHG1AF3 CHG1AF3 XCHG1AY3
## 1 R 1414 R 10024 R 8610 R 1414 R
## 2 R 0 R 8832 R 8832 R 0 R
## 3 A . A . A . A . A
## 4 R 1758 R 11878 R 10120 R 1650 R
## 5 R 2740 R 11068 R 8328 R 2920 R
## CHG1AY3 CHG1TGTD CHG1FGTD XCHG2AT0 CHG2AT0 XCHG2AF0 CHG2AF0 XCHG2AY0 CHG2AY0
## 1 10024 . . R 8610 R 1414 R 10024
## 2 8832 . . R 8568 R 0 R 8568
## 3 . . . A . A . A .
## 4 11770 . . R 9730 R 1608 R 11338
## 5 11248 . . R 8328 R 2740 R 11068
## XCHG2AT1 CHG2AT1 XCHG2AF1 CHG2AF1 XCHG2AY1 CHG2AY1 XCHG2AT2 CHG2AT2 XCHG2AF2
## 1 R 8610 R 1414 R 10024 R 8610 R
## 2 R 8568 R 0 R 8568 R 8832 R
## 3 A . A . A . A . A
## 4 R 9730 R 1758 R 11488 R 10120 R
## 5 R 8328 R 2740 R 11068 R 8328 R
## CHG2AF2 XCHG2AY2 CHG2AY2 XCHG2AT3 CHG2AT3 XCHG2AF3 CHG2AF3 XCHG2AY3 CHG2AY3
## 1 1414 R 10024 R 8610 R 1414 R 10024
## 2 0 R 8832 R 8832 R 0 R 8832
## 3 . A . A . A . A .
## 4 1758 R 11878 R 10120 R 1650 R 11770
## 5 2740 R 11068 R 8328 R 2920 R 11248
## CHG2TGTD CHG2FGTD XCHG3AT0 CHG3AT0 XCHG3AF0 CHG3AF0 XCHG3AY0 CHG3AY0 XCHG3AT1
## 1 . . R 17220 R 1414 R 18634 R
## 2 . . R 20400 R 0 R 20400 R
## 3 . . A . A . A . A
## 4 . . R 22126 R 1608 R 23734 R
## 5 . . R 16656 R 2740 R 19396 R
## CHG3AT1 XCHG3AF1 CHG3AF1 XCHG3AY1 CHG3AY1 XCHG3AT2 CHG3AT2 XCHG3AF2 CHG3AF2
## 1 17220 R 1414 R 18634 R 17220 R 1414
## 2 20400 R 0 R 20400 R 21216 R 0
## 3 . A . A . A . A .
## 4 22126 R 1758 R 23884 R 23012 R 1758
## 5 16656 R 2740 R 19396 R 16656 R 2740
## XCHG3AY2 CHG3AY2 XCHG3AT3 CHG3AT3 XCHG3AF3 CHG3AF3 XCHG3AY3 CHG3AY3 CHG3TGTD
## 1 R 18634 R 17220 R 1414 R 18634 .
## 2 R 21216 R 21864 R 0 R 21864 .
## 3 A . A . A . A . .
## 4 R 24770 R 23012 R 1650 R 24662 .
## 5 R 19396 R 16656 R 2920 R 19576 .
## CHG3FGTD XCHG4AY0 CHG4AY0 XCHG4AY1 CHG4AY1 XCHG4AY2 CHG4AY2 XCHG4AY3 CHG4AY3
## 1 . R 1600 R 1600 R 1600 R 2192
## 2 . R 1200 R 1200 R 1200 R 1200
## 3 . A . A . A . A .
## 4 . R 2200 R 2300 R 2416 R 2416
## 5 . R 1600 R 1600 R 1600 R 1600
## XCHG5AY0 CHG5AY0 XCHG5AY1 CHG5AY1 XCHG5AY2 CHG5AY2 XCHG5AY3 CHG5AY3 XCHG6AY0
## 1 R 9240 R 9520 R 9520 R 11402 R
## 2 R 12307 R 12307 R 13120 R 13590 R
## 3 A . A . A . A . A
## 4 R 10652 R 10764 R 11122 R 11122 R
## 5 R 6050 R 6050 R 6050 R 7690 R
## CHG6AY0 XCHG6AY1 CHG6AY1 XCHG6AY2 CHG6AY2 XCHG6AY3 CHG6AY3 XCHG7AY0 CHG7AY0
## 1 3090 R 3090 R 3090 R 3864 R 9240
## 2 5555 R 5555 R 5757 R 5757 R 12307
## 3 . A . A . A . A .
## 4 4076 R 4156 R 4462 R 4462 R 10652
## 5 3392 R 3392 R 3392 R 3392 R 7320
## XCHG7AY1 CHG7AY1 XCHG7AY2 CHG7AY2 XCHG7AY3 CHG7AY3 XCHG8AY0 CHG8AY0 XCHG8AY1
## 1 R 9520 R 9520 R 11402 R 3090 R
## 2 R 12307 R 14330 R 14580 R 5555 R
## 3 A . A . A . A . A
## 4 R 10764 R 11122 R 11122 R 4076 R
## 5 R 7320 R 7320 R 7320 R 4228 R
## CHG8AY1 XCHG8AY2 CHG8AY2 XCHG8AY3 CHG8AY3 XCHG9AY0 CHG9AY0 XCHG9AY1 CHG9AY1
## 1 3090 R 3090 R 3864 R 3440 R 3440
## 2 5555 R 6007 R 6007 R 5555 R 5555
## 3 . A . A . A . A .
## 4 4156 R 4462 R 4462 R 4076 R 4156
## 5 5130 R 5130 R 5130 R 4228 R 5130
## XCHG9AY2 CHG9AY2 XCHG9AY3 CHG9AY3
## 1 R 3440 R 4271
## 2 R 6007 R 6007
## 3 A . A .
## 4 R 4462 R 4462
## 5 R 5130 R 5130
head(new_dist[, 200:235], 5)
## XCHG5AY2 CHG5AY2 XCHG5AY3 CHG5AY3 XCHG6AY0 CHG6AY0 XCHG6AY1 CHG6AY1 XCHG6AY2
## 1 R 9520 R 11402 R 3090 R 3090 R
## 2 R 13120 R 13590 R 5555 R 5555 R
## 3 A . A . A . A . A
## 4 R 11122 R 11122 R 4076 R 4156 R
## 5 R 6050 R 7690 R 3392 R 3392 R
## CHG6AY2 XCHG6AY3 CHG6AY3 XCHG7AY0 CHG7AY0 XCHG7AY1 CHG7AY1 XCHG7AY2 CHG7AY2
## 1 3090 R 3864 R 9240 R 9520 R 9520
## 2 5757 R 5757 R 12307 R 12307 R 14330
## 3 . A . A . A . A .
## 4 4462 R 4462 R 10652 R 10764 R 11122
## 5 3392 R 3392 R 7320 R 7320 R 7320
## XCHG7AY3 CHG7AY3 XCHG8AY0 CHG8AY0 XCHG8AY1 CHG8AY1 XCHG8AY2 CHG8AY2 XCHG8AY3
## 1 R 11402 R 3090 R 3090 R 3090 R
## 2 R 14580 R 5555 R 5555 R 6007 R
## 3 A . A . A . A . A
## 4 R 11122 R 4076 R 4156 R 4462 R
## 5 R 7320 R 4228 R 5130 R 5130 R
## CHG8AY3 XCHG9AY0 CHG9AY0 XCHG9AY1 CHG9AY1 XCHG9AY2 CHG9AY2 XCHG9AY3 CHG9AY3
## 1 3864 R 3440 R 3440 R 3440 R 4271
## 2 6007 R 5555 R 5555 R 6007 R 6007
## 3 . A . A . A . A .
## 4 4462 R 4076 R 4156 R 4462 R 4462
## 5 5130 R 4228 R 5130 R 5130 R 5130
new_dist$CHG5AY2 <- as.numeric(new_dist$CHG5AY2)
## Warning: NAs introduced by coercion
summary(new_dist$CHG5AY2)
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 675 8566 10953 11121 13634 27000 1881
plot(new_dist$TUITION1, new_dist$CHG5AY2,
main="In-State Tuition vs. Enrollment",
xlab="In-State Tuition (USD)",
ylab="Enrollment",
col="blue", pch=19)
cor(new_dist$TUITION1, new_dist$CHG5AY2, use="complete.obs")
## [1] 0.5792363