Alpha University attempts to attract the highest-quality students, especially from its region of the county. It has gathered data on 178 applicants who were accepted by the University (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: whethter the applicant accepts Alpha's offer to enroll (Yes / No) Went to Beta: whether the applicant enrolls at Alpha's rival Beta University (Yes / No) Combined Score: a combined score for the applicant used by Alpha to rank applicants Alpha University Admissions Template.xlsx Use the template file, update the highlighted cells with formula and interpretation/conculsion, and upload your worksheet. a. Alpha University targets to keep 75% of offered students to enroll. Calculate a 95% confidence interval for the proportion of students who accept Alpha's offer. Do you think Alpha does well to keep the target acceptance rate? b. Admission director claims that students who accepted Alpha's offer show a combined score