071 Drug test data for 221 and 222 Spring 2026 Hw2-3 Double Homework.xlsx

	B	C	D	E	F	G	H	I	J
1
2	A new drug (medicine) to assist body weight loss is subject to testing during its Research & Development (R&D) process. The R&D people, who are actually pharmaceutics experts or medical doctors, try the drug on 200 subjects, i.e., people. Then they report their experimental results in the following table. You can now use the data set in your respective homework assignments. Examine the data carefully, first. Then proceed to your analysis. Subject (i): Subject index, 1,2,...,200 Age: Age of subject in years Sex: Sex of subject, 1: Female, 0: Male Working: Work status of subject, 1: Working, 0: Not working Duration: Duration of test, i.e., clinical drug use, in weeks Diabetes history of subject: 1: Diabetes history, 0: No diabetes history Smoking: Smoking behavior of subject, 1: Smoking, 0: Not smoking Before: Body weight of subject before the test in kilograms After: Body weight of subject after the test in kilograms
3
4
5
6
7
8
9
10
11
12
13
14
15			(1: Female)	(1: Working)		(1: Yes)	(1: Yes)
16		(Years)	(0: Male)	(0: Not working)	(Weeks)	(0: No)	(0: No)	(Kg)	(Kg)
17	Subject (i)	Age	Sex	Working	Duration	Diabetes	Smoking	Before	After

18	1	54	0	1	6	1	1	125	116
19	2	31	1	0	6	0	0	100	83
20	3	66	0	0	2	1	0	135	131
21	4	39	1	1	4	1	0	120	102
22	5	59	1	1	3	1	1	135	140
23	6	64	1	1	3	0	1	145	128
24	7	54	0	0	2	0	1	140	132
25	8	41	0	1	4	0	0	120	110
26	9	60	0	1	2	0	1	95	85
27	10	61	0	1	3	1	1	135	130
28	11	43	1	0	5	1	1	120	112
29	12	47	0	0	2	1	1	140	139
30	13	42	1	0	6	1	0	110	117
31	14	47	1	1	3	0	1	100	81
32	15	50	0	1	2	0	1	110	99
33	16	66	0	0	2	0	1	110	103
34	17	58	1	0	3	1	0	140	129
35	18	68	1	0	4	0	0	110	92
36	19	52	1	1	2	1	1	105	87
37	20	55	0	0	5	0	1	140	138
38	21	51	0	0	6	1	0	105	99
39	22	44	0	1	3	0	1	120	107
40	23	50	0	1	2	1	1	110	102
41	24	44	0	1	5	0	0	140	127
42	25	58	1	1	6	0	0	140	123
43	26	40	0	1	2	0	1	110	119
44	27	44	0	0	5	0	1	115	105
45	28	45	1	1	3	0	0	140	119
46	29	32	1	1	6	1	0	145	125
47	30	49	0	1	2	0	1	125	115
48	31	28	1	0	3	0	0	110	94
49	32	35	0	1	4	1	1	125	115
50	33	48	0	1	3	0	1	95	83
51	34	54	0	1	5	0	0	110	97
52	35	52	0	0	4	0	0	110	102
53	36	52	0	1	6	0	0	115	103
54	37	49	1	0	6	1	1	130	114
55	38	63	0	0	6	0	1	140	134
56	39	61	0	1	4	0	0	140	130
57	40	53	0	0	4	0	0	105	93
58	41	38	1	1	5	0	0	120	98
59	42	44	0	1	6	1	0	130	115
60	43	54	1	1	2	1	0	135	117
61	44	51	0	1	3	1	0	95	90
62	45	50	0	1	2	1	1	145	134
63	46	55	0	1	4	1	1	100	95
64	47	66	0	0	3	0	1	135	147
65	48	30	0	1	6	0	1	130	114
66	49	56	0	0	6	1	0	125	120
67	50	52	1	0	4	0	1	145	129
68	51	59	1	1	3	0	0	125	106
69	52	73	1	0	3	1	0	95	88
70	53	40	0	1	5	1	1	145	136
71	54	51	1	1	4	0	0	115	101
72	55	33	0	1	6	1	1	135	122
73	56	61	1	1	5	1	1	100	79
74	57	54	0	1	3	0	0	115	99
75	58	58	0	1	6	0	1	125	112
76	59	56	1	1	4	1	1	100	89
77	60	45	0	1	4	1	1	105	93
78	61	58	0	1	2	1	1	100	94
79	62	44	1	1	2	0	0	145	123
80	63	51	0	0	4	0	1	130	119
81	64	50	0	1	6	0	0	145	135
82	65	26	1	1	5	1	0	145	124
83	66	76	1	0	3	0	0	95	84
84	67	44	0	1	4	1	1	125	117
85	68	48	1	0	6	0	1	100	83
86	69	41	0	1	6	0	1	110	97
87	70	74	0	0	6	0	1	115	108
88	71	45	0	1	5	1	0	100	93
89	72	50	0	1	4	1	0	145	132
90	73	54	0	1	3	1	1	110	103
91	74	44	0	1	5	0	1	115	100
92	75	57	0	1	5	0	0	120	111
93	76	50	0	1	2	1	1	120	114
94	77	45	0	1	5	0	0	115	103
95	78	37	1	1	5	0	1	100	77
96	79	44	0	1	3	0	1	105	90
97	80	48	1	1	6	0	0	135	115
98	81	41	1	1	2	1	0	140	141
99	82	33	1	1	5	1	0	140	120
100	83	55	0	1	6	1	1	95	85