Question
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)
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 ?30students, available? below, show that 20 successfully completed the program? (coded as? 1) and 10 did not? (coded as? 0). Complete parts? (a) through? (h) below.
a. Use technology to develop a logistic regression model to predict the probability of successful completion of the MBA? program, based on undergraduate GPA ?(X1?) and GMAT score ?(X2?).
b0=?
b1=?
b2=?
Success GPA GMAT O 2.93 617 O 3.05 557 3.11 599 3.24 616 O 3,36 594 O 3.41 567 O 3.45 542 O 3.6 551 3.64 573 O 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 784Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started