1. Load the Enrollment file using the readxl package and the read_excel function. Use sheet = 'Sheet1' argument. It is located in the R:/Institutional Research/Tableau/University Factbook/Source Data/Enrollment.xlsx. Save it as an object with a name of your choice. If youโ€™re going to filter using base R, coerce the tibble into a dataframe using as.data.frame and save it as an object.

  2. Filter the data to get Fall 2018 full-time, first-year undergraduate students. Select ID, MAJOR_1, MAJOR_2, MAJOR_3. Save it as an object with a name of your choice.

  3. How many full-time FTFY Biology majors are there? BIOL is the major code.