USING EXCEL A college director wants to predict the success of students in an MBA program using two independent? variables, undergraduate grade point average? (GPA) and GMAT score. Data from a random sample of

30?students, available? below, show that20successfully completed the program? (coded as? 1) and10

did not? (coded as? 0). Complete parts? (a) through? (h) below.

Success GPA GMAT O 2.93 617 3,05 557 O 3.11 599 0 3.24 616 3.36 594 3.41 567 0 3.45 542 0 3.6 551 3.64 573 3.57 536 2.75 691 2.81 647 3.03 652 3,1 608 3.06 680 3,17 639 3.24 632 3.41 639 3.37 619 3.46 665 3,57 694 3.62 641 3.66 594 3.69 678 3.7 624 3.78 654 3,84 718 3.77 692 3,79 632 3.97 784a. Use technology to develop a logistic regression model to predict the probability of successful completion of the MBA program, based on undergraduate GPA (X, ) and GMAT score (X2). Find the constant, bo, and the coefficients of X, and X2, b, and bo, respectively. bo = - 121.9 (Round to one decimal place as needed.) by = 8.05 (Round to two decimal places as needed.) by = 0.1573 (Round to four decimal places as needed.)The deviance statistic is 8.12 . (Round to two decimal places as needed.) The p-value for the deviance is 1.000 (Round to three decimal places as needed.)Find the Wald statistic for X,, the undergraduate GPA. Z= 1.60 (Round to two decimal places as needed.) The p-value for the Wald statistic, Z, for X, is 0.109. (Round to three decimal places as needed.) What is the correct conclusion? For undergraduate GPA, fail to reject Ho. There is insufficient evidence that the undergraduate GPA makes a significant contribution to the model. Find the Wald statistic for X2, the GMAT score. Z= 2.07 (Round to two decimal places as needed.) The p-value for the Wald statistic, Z, for X2 is 0.038 . (Round to three decimal places as needed.) For GMAT score, reject Ho. There is sufficient evidence that the GMAT score makes a significant contribution to the model. . Use technology to develop a logistic regression model that includes only undergraduate GPA to predict the probability of success in the MBA program. In (estimated odds ratio) = - 2.76 + ( 1.02 )X1; (Round to two decimal places as needed.) The deviance statistic is 29.17 . Round to two decimal places as needed.)