## Logistic regression Excel and Minitab

Logistic regression Excel and Minitab

Question1.

a) Use Minitab to develop and state the estimated logistic regression equation to predictAdmit by GRE, GPA and Prestige. (Assume for now that Prestige is a quantitativevariable.)
b) Testforoverallsignificance atthe 0.05level.
c) Whichofthepredictorsarestatisticallysignificantatthe0.05level?
d) Use hand-calculations based on the estimated logistic regression equation in part a) toestimate the probability of admission for a student from an institution of prestige level 3if the student has a score of 660 on their GRE and a 3.9 GPA. Verify your hand-calculationsusing Minitab.
e) FindtheestimatedoddsratiofortheGPAandinterpretit.
f) FindtheestimatedoddsratioforPrestigeandinterpretit.
g) Illustrate the odds ratio by comparing the odds in favour of being admitted into gradschool for a person with 660 GRE and 3.90 GPA from a college with prestige level 3 to aperson with the same GRA and GPA from a college with prestige level 2 and anotherwith prestigelevel4.
i) Repeat parts a) and b) but now assume that Prestige is a categorical variable. (You canfit the model without computing indicator variables by declaring Prestige as acategoricalpredictor.)

Question2.

a. Using Minitab, develop and state the estimated logistic regression equation to predictwhether a customerwillbuythecerealornot.
b. For each predictor variable, determine whether it is significant or not. Use a 0.05 levelofsignificance.
c. Suppose a customer earns \$51k annually and watched the ad. What is the estimatedprobabilitythecustomerwillbuythecereal?

Bought
Income
0
37
0
1
47
1
0
47
0
0
49
0
1
59
1
0
13
1
0
51
0
0
38
0
0
60
1
1
48
1
0
17
0
0
60
0
0
38
1
0
24
0
0
15
0
1
59
0
0
28
0
0
36
0
0
10
1
0
46
0
1
55
1
0
37
1
1
13
1
0
55
0
1
34
0
0
24
0
0
19
0
0
55
1
0
53
1
1
57
1
0
30
1
0
53
0
0
60
1
1
51
1
1
23
1
0
53
1
0
43
0
0
35
1
0
33
1
0
30
0
0
34
0
0
43
0
0
36
0
1
44
1
0
60
1
0
56
0
0
60
1
1
11
0
0
33
0
1
22
0
1
45
1
1
55
0
1
60
1
0
20
0
0
15
1
0
10
0
1
44
1
0
25
0
0
15
1
1
38
1
0
10
0
0
15
1
1
42
1
1
33
0
0
24
0
0
15
1
0
24
1
1
52
0
0
21
0
0
21
0
1
30
1

The post Logistic regression Excel and Minitab appeared first on Essay Shredder.