Hypothesis Testing for Differences between Groups

profileEuty
cfassessment2dataset1.xlsx

Sheet1

CLINIC 1 CLINIC 2
Mean 124.32 Mean 145.03
Standard Error 4.6781866469 Standard Error 3.9780827573
Median 134.5 Median 149.5
Mode 150 Mode 175
Standard Deviation 46.7818664688 Standard Deviation 39.7808275734
Sample Variance 2188.543030303 Sample Variance 1582.5142424242
Kurtosis -0.4357474011 Kurtosis 0.2646528486
Skewness -0.5051077009 Skewness -0.0628565208
Range 183 Range 221
Minimum 24 Minimum 42
Maximum 207 Maximum 263
Sum 12432 Sum 14503
Count 100 Count 100
Confidence Level(95.0%) 9.2825372474 Confidence Level(95.0%) 7.8933792419

dataset2

clinic1 clinic2 F-Test Two-Sample for Variances
140 169
126 151 Clinic 1 Clinic 2
30 175 Mean 124.32 145.03
130 115 Variance 2188.543030303 1582.5142424242
193 167 Observations 100 100
137 153 df 99 99
168 115 F 1.3829531335
99 194 P(F<=f) one-tail 0.05420092
135 216 F Critical one-tail 1.3940612573
184 149
118 122
109 155 t-Test: Two-Sample Assuming Equal Variances
93 185
136 150 Clinic 1 Clinic 2
102 141 Mean 124.32 145.03
24 135 Variance 2188.543030303 1582.5142424242
99 87 Observations 100 100
104 42 Pooled Variance 1885.5286363636
134 96 Hypothesized Mean Difference 0
80 111 df 198
30 234 t Stat -3.3724734143
44 158 P(T<=t) one-tail 0.0004479683
156 130 t Critical one-tail 1.6525857836
150 148 P(T<=t) two-tail 0.0008959366
150 105 t Critical two-tail 1.9720174778
95 108
51 114
205 113 t-Test: Two-Sample Assuming Unequal Variances
30 131
92 114 Clinic 1 Clinic 2
173 61 Mean 124.32 145.03
49 175 Variance 2188.543030303 1582.5142424242
137 135 Observations 100 100
27 198 Hypothesized Mean Difference 0
150 149 df 193
182 92 t Stat -3.3724734143
184 127 P(T<=t) one-tail 0.0004500372
152 170 t Critical one-tail 1.6527870682
147 167 P(T<=t) two-tail 0.0009000743
76 175 t Critical two-tail 1.9723316758
161 263
143 138
127 161
166 166
139 88
92 152
145 136
176 121
186 174
48 90
92 179
69 171
168 85
27 134
157 123
83 134
139 64
132 153
85 106
97 192
125 115
145 150
129 151
157 166
183 105
50 159
185 160
149 52
157 167
185 103
127 178
110 174
66 80
141 128
125 172
111 154
150 170
162 152
94 95
138 111
162 144
134 136
83 191
157 193
134 144
137 168
76 94
115 126
51 208
150 136
25 201
137 171
148 148
207 214
189 111
104 204
197 189
131 159
151 188
202 174
12432 14503