Predictive model guessing the admissions percentage at a university given directory and financial aid information, with an RMSE of 10%. Part of the capstone for HarvardX's Data Science certification.
Data sets can be found in the data folder, information on the variables contained within can be found in the dictionaries folder.
This model uses the following key variables (among many others):
GRN4A22: Average amount of grant and scholarship aid awarded, income level (30,001-48,000), 2017-18.
ANYAIDP: Percent of full-time first-time undergraduates awarded any financial aid.
AIDFSIP: Percent of full-time first-time undergraduates awarded any loans to students or grant aid from federal state/local government or the institution.
AGRNT_P: Percent of full-time first-time undergraduates awarded federal, state, local or institutional grant aid.
LATITUDE: Latitude location of institution.
GRN4A32: Average amount of grant and scholarship aid awarded, income level (48,001-75,000), 2017-18.
GRN4A21: Average amount of grant and scholarship aid awarded, income level (30,001-48,000), 2016-17.
NPT452: Average net price (income over 110,000)-students awarded Title IV federal financial aid, 2017-18.
GRN4A12: Average amount of grant and scholarship aid awarded, income level (0-30,000), 2017-18.
GRN4A20: Average amount of grant and scholarship aid awarded, income level (30,001-48,000), 2015-16.
IGRNT_P: Percent of full-time first-time undergraduates awarded institutional grant aid.
ZIP: ZIP code.
FLOAN-P: Percent of full-time first-time undergraduates awarded federal student loans.
NPT452: Average net price (income over 110,000)-students awarded Title IV federal financial aid, 2016-17.
GRN4A31: Average amount of grant and scholarship aid awarded, income level (48,001-75,000), 2016-17.
C18UGPRF: Carnegie Classification 2018: Undergraduate Profile.
OLOAN_A: Average amount of other student loans awarded to full-time first-time undergraduates.
LONGITUD: Longitude location of institution.
NPT452: Average net price (income over 110,000)-students awarded Title IV federal financial aid, 2017-18.
LOAN_P: Percent of full-time first-time undergraduates awarded student loans.
2018 data gathered from IPEDS here (under Survey Data): https://nces.ed.gov/ipeds/use-the-data