The way I understand it, LO_INC_WDRAW_ORIG_YR2_RT is the number of low income students that withdrew from the college within 2 years. There is also a variable for 3 years, 4, 6, and 8 years. I am confused because the maximum value goes down for larger years (in R, I have filtered "PrivacySuppressed" and "NULL" entries then arranged them in descending order by the LO_INC_WDRAW_ORIG_YR#_RT variables where # is 2, 3, 4, 6 or 8).
colleges %>% select(INSTNM, LO_INC_WDRAW_ORIG_YR6_RT) %>% filter(!(LO_INC_WDRAW_ORIG_YR6_RT == "PrivacySuppressed"), !(LO_INC_WDRAW_ORIG_YR6_RT == "NULL"), !(is.na(LO_INC_WDRAW_ORIG_YR6_RT)), !(is.null(LO_INC_WDRAW_ORIG_YR6_RT))) %>% arrange(desc(LO_INC_WDRAW_ORIG_YR6_RT))
Shouldn't the number of students that withdrew within 2 years be counted into the total for 3 years, and those be counted into the total for 4, etc, meaning the maximum value should go up rather than down? Thank you