Question

Please let me know how to solve this questions, I would like to know know how to do this using excel. Using the data in tab, test whether the average weight of patients attending your new weight loss clinic has changed as a result of attending the clinic. That is, is the average weight of patients after attending the clinic different from the average weight before attending? Report the average weight of these patients before and after attending the clinic and interpret the results of the statistical test(s) performed.

	Weight
Person	Before	After
1	173	164
2	192	191
3	185	176
4	177	176
5	196	189
6	178	169
7	196	196
8	181	172
9	158	158
10	201	193
11	191	185
12	193	190
13	176	175
14	212	213
15	177	173
16	183	180
17	211	204
18	198	192
19	157	152
20	213	209
21	161	153
22	178	168
23	210	203
24	192	186
25	178	170

Answer 1

This is a paired sample T test since the subjects are the same before and after.

$H_0:\mu_D=0$

$H_a:\mu_D\neq0$

Significance level:  

g= 0,05

A D E F G H J K 1 C Difference - After - Before -9 2 3 4 5 6 7 Before 173 192 185 177 B After 164 191 176 176 -9 -1 -7 -9 mean S.Dev AVERAGE(C2:C26) STDEV.S(C2:026) 189 -5.2000 3.3789 25 196 178 169 n= 8 196 0 df 24 G7-1 196 181 9 172 -9 0 10 11 158 201 191 158 193 185 12 13 14 193 -3 190 175 176 -1 212 213 15 16 17 1 -4 177 173 Test statistic T -7.6949 G5/G6/SQRT(G7)) significance level = 0.05 df= 24 Two tailed P value - 0.0000 T.DIST.2T(-H14,H16) Conclusion: Reject the null hypothesis as the P value is <0.05 (significance level). 183 180 -3 -7 211 204 198 192 157 152 -5 -4 213 18 19 20 21 22 23 24 25 161 209 153 168 -8 -10 178 210 203 - 7 -6 192 186 26 170 170 O

Since we have rejected the null hypothesis, we have evidence that the average weight of patients attending your new weight loss clinic has changed as a result of attending the clinic