The data setCollege_AdmissionsDownload College_Admissionscontains records for students who recently applied to a University. Explore the data on two categorical variables denoting admission decision (Admitted) and the college that the student applies to (College).

Complete the following tasks:

1. Introduction: Describe the motivation for this research. In other words, why would it be important to analyze this topic of research?
2. Develop an appropriate contingency that summarizes the data set and discuss any insights the graph reveals about the data.
3. Perform the following calculations and report results in complete sentences:

• • What is the probability that a randomly selected student is not admitted?
  • What is the probability that a randomly selected student is a Math & Science major?
  • What is the probability that a randomly selected student is admitted or is an Arts & Letters major?
  • What is the probability that a randomly selected student is enrolled admitted and is a Business & Economics major?
  • What is the probability that a randomly selected student is a Math & Science major given he or she has been admitted?
  • What is the probability that a randomly selected student is not admitted given he or she is a Business & Economics major?

1. Summarize and compare your results (from part 3.) and provide a recommendation to the University. Additionally, make appropriate suggestions and/or discuss any shortcomings of this research.
2. Excel file download: https://www.filemail.com/d/dgaywfmoladtrzm