Using Stat Tools in Excel

9. (10 points) The director of admissions of a top-20 MBA program is interested in studying the proportion Graduate Management Admissions Test (GMAT) in excess of 630. The director has collected random of entering students in similar graduate business programs who have achieved a composite score on the that these students' GMAT scores are indicative of the scores earned by their peers in his program and in samples of MBA candidates entering his program in the fall of 2019 and in the fall of 2009. He believes competitors' programs. The GMAT scores are for the randomly selected students entering in each year are listed in the file Problem9Data.xlsx 1% significance levels. a. The admission directors claims that proportion of students entering top-rate programs in 2019 with composite GMAT scores in excess of 630 is greater than 50%. Test this claim at the 10%, 5% and b. The admissions director also claims that the proportion of students entering top-rated programs with composite GMAT scores in excess of 630 is higher in 2019 than it was in 2009. Test the admission director's claim at the 5% significance level and report your findings. 9. (10 points) The director of admissions of a top-20 MBA program is interested in studying the proportion Graduate Management Admissions Test (GMAT) in excess of 630. The director has collected random of entering students in similar graduate business programs who have achieved a composite score on the that these students' GMAT scores are indicative of the scores earned by their peers in his program and in samples of MBA candidates entering his program in the fall of 2019 and in the fall of 2009. He believes competitors' programs. The GMAT scores are for the randomly selected students entering in each year are listed in the file Problem9Data.xlsx 1% significance levels. a. The admission directors claims that proportion of students entering top-rate programs in 2019 with composite GMAT scores in excess of 630 is greater than 50%. Test this claim at the 10%, 5% and b. The admissions director also claims that the proportion of students entering top-rated programs with composite GMAT scores in excess of 630 is higher in 2019 than it was in 2009. Test the admission director's claim at the 5% significance level and report your findings