Bickley Academy is a competitive private college preparatory high school. Bickley’s administration is now considering applications from the three local junior high schools: Montgomery, Cleeghorn, and Benson. Bickley’s admissions department has compiled a file named bickley that contains the first name, last name, email address, and grade point average (GPA) for applicants from these schools.

Bickley’s Director of Admissions, Joan Bisdubic, would like to look at the relationship between these students’ GPAs and the schools they are attending. The school each student is attending can be identified by the domain name in the student’s email address. To ensure each applicant receives full and proper consideration, Joan Bisdubic would also like to ensure that the file has the GPA for every applicant.

a. Create a new set of data from the data in the file bickley that includes the applicant’s first name, last name, email username (the portion of the email address that precedes the @ symbol), email domain (the portion of the email address that follows the @ symbol), and GPA. Save your file under the name bickleyapp.xlsx.

b. Using the file bickleyapp that you created in part (a), determine if any records have missing values for the GPA field. Provide a list of the names of the applicants for whom the value of the field GPA is missing.