1. The file P17_01.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might be useful in discriminating between these two groups: gender, martial status, annual income level, and age.
   1. Use logistic regression to classify the consumers on the basis of these explanatory variables. How successful is it? Which variables appear to be most important for the classification?
   2. Consider a new customer: male, married, income of $42k, age 47. Use the logistic regression equation to estimate the probability that this customer prefers regular. How would you classify this person?

Individual	Gender	Married	Income	Age	Beer Preference	Gender female	Gefer male	Beer preference regular	Beer preference light	Married No	Married Yes
1	1	0	$37,779	45	Regular	0	1	1	0	1	0
2	0	1	$44,955	53	Regular	1	0	1	0	0	1
3	1	0	$36,896	48	Regular	0	1	1	0	1	0
4	1	1	$70,981	45	Light	0	1	0	1	0	1
5	1	0	$38,990	36	Regular	0	1	1	0	1	0
6	1	1	$51,126	41	Light	0	1	0	1	0	1
7	0	1	$45,133	51	Light	1	0	0	1	0	1
8	1	1	$36,316	41	Light	0	1	0	1	0	1
9	1	1	$40,955	69	Regular	0	1	1	0	0	1
10	0	1	$27,280	55	Regular	1	0	1	0	0	1
11	0	1	$33,027	51	Regular	1	0	1	0	0	1
12	1	1	$63,555	62	Light	0	1	0	1	0	1
13	1	1	$64,709	70	Regular	0	1	1	0	0	1
14	1	0	$38,447	37	Light	0	1	0	1	1	0
15	1	1	$35,282	59	Regular	0	1	1	0	0	1
16	0	1	$43,468	52	Regular	1	0	1	0	0	1
17	1	0	$53,768	34	Light	0	1	0	1	1	0
18	0	1	$52,875	71	Light	1	0	0	1	0	1
19	1	0	$29,728	41	Regular	0	1	1	0	1	0
20	0	0	$30,587	36	Regular	1	0	1	0	1	0
21	0	1	$49,585	34	Light	1	0	0	1	0	1
22	1	1	$48,957	33	Light	0	1	0	1	0	1
23	1	1	$32,739	50	Regular	0	1	1	0	0	1
24	1	0	$41,057	40	Light	0	1	0	1	1	0
25	1	0	$31,916	43	Regular	0	1	1	0	1	0
26	1	0	$29,077	39	Regular	0	1	1	0	1	0
27	1	1	$58,164	30	Light	0	1	0	1	0	1
28	0	1	$30,784	52	Regular	1	0	1	0	0	1
29	1	1	$25,440	51	Regular	0	1	1	0	0	1
30	0	0	$41,779	39	Light	1	0	0	1	1	0
31	0	0	$26,598	29	Light	1	0	0	1	1	0
32	1	1	$30,081	56	Regular	0	1	1	0	0	1
33	1	1	$43,194	47	Light	0	1	0	1	0	1
34	1	0	$22,408	40	Regular	0	1	1	0	1	0
35	1	1	$42,108	26	Light	0	1	0	1	0	1
36	0	0	$40,456	42	Light	1	0	0	1	1	0
37	1	1	$47,797	49	Light	0	1	0	1	0	1
38	1	0	$43,992	53	Light	0	1	0	1	1	0
39	1	1	$41,882	54	Regular	0	1	1	0	0	1
40	1	1	$55,281	48	Light	0	1	0	1	0	1
41	1	1	$47,495	35	Light	0	1	0	1	0	1
42	0	0	$33,088	22	Light	1	0	0	1	1	0
43	0	1	$46,890	36	Light	1	0	0	1	0	1
44	0	0	$35,406	29	Light	1	0	0	1	1	0
45	0	1	$59,485	36	Light	1	0	0	1	0	1
46	1	0	$42,775	27	Light	0	1	0	1	1	0
47	0	0	$28,094	39	Regular	1	0	1	0	1	0
48	1	0	$26,004	62	Regular	0	1	1	0	1	0
49	1	0	$38,671	44	Light	0	1	0	1	1	0
50	0	1	$33,880	48	Regular	1	0	1	0	0	1
51	0	0	$43,593	27	Light	1	0	0	1	1	0
52	0	0	$27,078	45	Regular	1	0	1	0	1	0
53	1	0	$37,926	33	Light	0	1	0	1	1	0
54	1	1	$50,517	38	Light	0	1	0	1	0	1
55	0	0	$39,370	28	Light	1	0	0	1	1	0
56	0	0	$31,398	47	Regular	1	0	1	0	1	0
57	1	0	$29,293	43	Regular	0	1	1	0	1	0
58	1	0	$49,811	49	Regular	0	1	1	0	1	0
59	0	0	$38,453	43	Regular	1	0	1	0	1	0
60	0	0	$31,779	46	Regular	1	0	1	0	1	0
61	0	1	$33,700	25	Light	1	0	0	1	0	1
62	0	1	$37,263	49	Regular	1	0	1	0	0	1
63	0	1	$44,802	34	Light	1	0	0	1	0	1
64	0	1	$35,050	36	Light	1	0	0	1	0	1
65	1	1	$37,606	37	Light	0	1	0	1	0	1
66	1	0	$52,341	42	Light	0	1	0	1	1	0
67	1	1	$45,600	50	Regular	0	1	1	0	0	1
68	1	1	$36,030	55	Regular	0	1	1	0	0	1
69	0	1	$44,558	31	Light	1	0	0	1	0	1
70	1	1	$34,391	60	Regular	0	1	1	0	0	1
71	1	1	$43,741	54	Regular	0	1	1	0	0	1
72	0	0	$36,821	32	Light	1	0	0	1	1	0
73	1	1	$51,578	45	Light	0	1	0	1	0	1
74	1	0	$23,234	31	Regular	0	1	1	0	1	0
75	0	1	$48,259	32	Light	1	0	0	1	0	1
76	0	1	$46,273	56	Light	1	0	0	1	0	1
77	1	1	$42,404	30	Light	0	1	0	1	0	1
78	0	0	$41,391	54	Light	1	0	0	1	1	0
79	0	1	$45,610	38	Light	1	0	0	1	0	1
80	1	1	$47,667	87	Regular	0	1	1	0	0	1
81	1	1	$40,261	31	Light	0	1	0	1	0	1
82	1	0	$46,626	46	Light	0	1	0	1	1	0
83	0	1	$55,608	43	Light	1	0	0	1	0	1
84	1	1	$35,678	64	Regular	0	1	1	0	0	1
85	0	0	$50,154	40	Light	1	0	0	1	1	0
86	1	0	$34,575	57	Regular	0	1	1	0	1	0
87	0	0	$30,841	24	Light	1	0	0	1	1	0
88	1	0	$20,945	42	Regular	0	1	1	0	1	0
89	1	0	$38,176	40	Regular	0	1	1	0	1	0
90	1	0	$28,513	34	Regular	0	1	1	0	1	0
91	0	1	$51,094	46	Regular	1	0	1	0	0	1
92	1	1	$40,582	66	Regular	0	1	1	0	0	1
93	1	0	$32,493	63	Regular	0	1	1	0	1	0
94	0	1	$36,451	44	Regular	1	0	1	0	0	1
95	0	1	$42,051	58	Regular	1	0	1	0	0	1
96	0	0	$26,186	38	Regular	1	0	1	0	1	0
97	1	1	$24,302	46	Regular	0	1	1	0	0	1
98	0	0	$39,923	58	Regular	1	0	1	0	1	0
99	0	1	$39,942	21	Light	1	0	0	1	0	1
100	1	0	$33,553	48	Regular	0	1	1	0	1	0