The accompanying data file contains information on 186 terminally ill patients who agreed to participate in a new drug trial. They were randomly assigned to either an experimental group or a control group. Patients in the experimental group were given the new drug that is being tested for this particular illness. Patients in the control group were kept on the medicine they had been receiving. After one year, it was noted whether or not the patient was still alive.Click here for the Excel Data Filea-1. Construct a contingency table that cross-classifies the data by Experimental_Drug and Living. Provide the frequencies in the accompanying data file.a-2. How many of the patients received the experimental drug?a-3. How many of the patients were still living after one year?b-1. Of the patients in the control group, what proportion was still living after one year?Note: Report the proportion rounded to 2 decimal places.b-2. Of the patients in the experimental group, what proportion was still living after one year?Note: Report the proportion rounded to 2 decimal places. https://ezt.prod.mheducation.com/Media/Connect_Production/bne/Jaggia_Ess_3e/using_r/excel_data_file/ch02/static/Ch02_Q35_Data_File.xlsx

 

Patient	Experimental_Drug	Living
1	Yes	Yes
2	Yes	Yes
3	Yes	No
4	No	No
5	Yes	No
6	Yes	Yes
7	Yes	Yes
8	Yes	Yes
9	Yes	No
10	Yes	No
11	Yes	Yes
12	No	Yes
13	Yes	Yes
14	Yes	Yes
15	Yes	Yes
16	Yes	No
17	No	Yes
18	Yes	No
19	Yes	Yes
20	No	No
21	Yes	Yes
22	Yes	Yes
23	No	Yes
24	No	No
25	Yes	No
26	No	No
27	No	No
28	No	Yes
29	No	No
30	No	Yes
31	Yes	No
32	No	No
33	Yes	Yes
34	No	Yes
35	No	No
36	No	Yes
37	Yes	Yes
38	Yes	Yes
39	Yes	No
40	No	Yes
41	No	No
42	Yes	Yes
43	Yes	No
44	No	Yes
45	Yes	Yes
46	No	No
47	Yes	Yes
48	No	Yes
49	Yes	Yes
50	Yes	Yes
51	Yes	Yes
52	Yes	Yes
53	No	No
54	Yes	Yes
55	No	Yes
56	Yes	No
57	Yes	Yes
58	No	Yes
59	No	Yes
60	Yes	Yes
61	No	Yes
62	Yes	Yes
63	No	Yes
64	No	Yes
65	No	No
66	No	No
67	No	Yes
68	No	No
69	Yes	Yes
70	Yes	Yes
71	Yes	Yes
72	Yes	No
73	Yes	Yes
74	Yes	No
75	Yes	Yes
76	Yes	Yes
77	No	Yes
78	No	Yes
79	No	Yes
80	Yes	Yes
81	No	No
82	Yes	No
83	No	No
84	Yes	Yes
85	No	Yes
86	No	Yes
87	Yes	No
88	Yes	No
89	Yes	Yes
90	Yes	No
91	Yes	Yes
92	No	Yes
93	No	No
94	No	No
95	No	Yes
96	No	Yes
97	Yes	Yes
98	Yes	Yes
99	No	No
100	No	No
101	No	Yes
102	No	Yes
103	Yes	Yes
104	No	Yes
105	Yes	Yes
106	No	No
107	Yes	Yes
108	Yes	Yes
109	Yes	Yes
110	Yes	Yes
111	No	Yes
112	Yes	Yes
113	Yes	Yes
114	Yes	No
115	Yes	Yes
116	No	No
117	No	Yes
118	No	Yes
119	Yes	No
120	No	No
121	No	Yes
122	Yes	No
123	Yes	No
124	Yes	No
125	Yes	Yes
126	Yes	Yes
127	Yes	Yes
128	Yes	Yes
129	No	No
130	No	Yes
131	No	No
132	Yes	Yes
133	Yes	No
134	No	No
135	Yes	Yes
136	No	No
137	Yes	No
138	Yes	Yes
139	Yes	Yes
140	No	No
141	No	Yes
142	Yes	Yes
143	Yes	Yes
144	No	Yes
145	No	Yes
146	No	No
147	Yes	No
148	No	Yes
149	No	Yes
150	No	Yes
151	No	No
152	No	Yes
153	No	Yes
154	No	Yes
155	Yes	No
156	No	No
157	No	No
158	No	Yes
159	Yes	No
160	No	No
161	No	Yes
162	No	No
163	No	No
164	No	Yes
165	Yes	Yes
166	No	Yes
167	No	Yes
168	Yes	No
169	Yes	No
170	Yes	No
171	Yes	Yes
172	Yes	Yes
173	Yes	Yes
174	No	No
175	No	Yes
176	Yes	Yes
177	Yes	Yes
178	Yes	No
179	Yes	Yes
180	Yes	Yes
181	No	Yes
182	Yes	Yes
183	No	No
184	Yes	Yes
185	Yes	Yes
186	Yes	No