Alpha University attempts to attract the highest-quality students, especially from its region of the county. It has gathered data on 200 applicants who were admitted by Alpha University, but not all of them accepted Alpha's offer. (a random sample from all acceptable applicants over the past several years). Alpha is concerned that it is not getting enough of best students, and worse yet, that many of these best students are going to Alpha's main rival, Beta University. The data are in the file Alpha University Admissions Template.xlsx with the following variables: Applicant ID Accepted Alpha's offer: whether the applicant accepts Alpha's offer to enroll (Yes / No) Went to Beta: whether the applicant did not accept Alpha's offer and enrolled at Beta University (Yes / No) Combined Score: a combined score for the applicant used by Alpha to rank applicants Use the template file, update the highlighted cells with formula and interpretation/conclusion, and upload your worksheet. Alpha University Admissions.xlsxDownload Alpha University Admissions.xlsx a. Admission director of Alpha University believes that at least 65% of offered students accept the Alpha's admission offer and enroll. Validate the director's claim on both 95% and 99% confidence level. b. Alpha University targets to keep