The database Applicants.xlsx contains a description of an MBA applicant pool for an unspecified year in the 1990s. For each of the following requirements, create a separate worksheet and extract the data from the original database.
a. Among enrolling students, what is the average GMAT score? What is the average in the applicant pool as a whole?
b. How many in the applicant pool represented Financial Services in terms of job background? What was their average age? What was their average work experience (months)? What was their average GMAT score?
c. How many in the applicant pool represented Consulting in terms of job background? What was their average age? What was their average work experience (months)? What was their average GMAT score?
d. What proportion of the applicant pool had two or more degrees?