In what follows use any of the following tests/procedures: Regression, confidence intervals, onesided t-test, or two-sided t-test. All the procedures should be done with 5% P-value or 95%
confidence interval.
Open Hospital_HW13 data. Test if Hospital 1 has more patients who attempted suicide than
Hospital 3 on average. (Pick the closest answer)
1. What test did you perform? (4 points)
•
a. Regression
•
b. Confidence Interval
•
c. Two sided t-test
•
d. One sided t-test
2. What is the P-value/margin of error? (4 points)
•
a. #DIV/0!
•
b. 0.048098
•
c. 0.096197
•
d. None of these
3. What is the Statistical interpretation? (4 points)
•
a. The P-value is smaller than 5% thus the result is inconclusive.
•
b. The P-value is smaller than 5% thus we are confident to confirm the claim.
•
c. The P-value is too large to have a conclusive answer.
•
d. Average of data is inconsistent with the claim.
•
e. None of the above.
4. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 1 has more patients than Hospital 3.
•
b. We can claim Hospital 1 has more patients who have made suicide attempt than
Hospital 3.
•
c. We cannot claim that Hospital 1 has more patients who have made suicide attempt
than Hospital 3.
•
d. None of these.
5. What test did you perform? (4 points)
•
a. Regression
•
b. Two sided t-test
•
c. One sided t-test
•
d. Confidence Interval
6. What is the P-value/margin of error? (4 points)
•
a. 1.856912
•
b. 9.688328
•
c. 170.3271
•
d. None of these
7. What is the Statistical interpretation? (4 points)
•
a. The P-value is larger than 5% thus the result is conclusive.
•
b. The P-value is too large to have a conclusive answer.
•
c. Average of data is inconsistent with the claim.
•
d. The prediction interval for the true average number of Hospital 3 patients who
suffered car accident injuries is [168.471, 172.184].
•
e. None of the above.
8. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 3 has many patients who have had a car accident.
•
b. We are confident to say that Hospital 3 has more than 150 patients who have
suffered car accident injuries on average.
•
c. We cannot claim that Hospital 3 has more than 150 patients who have suffered car
accident injuries on average.
•
d. None of these.
9. What test did you perform? (4 points)
•
a. Regression
•
b. Confidence Interval
•
c. Two sided t-test
•
d. One sided t-test
10. What is the P-value/margin of error? (4 points)
•
a. 3.23187E-39
•
b. 6.46374E-39
•
c. 0.234217
•
d. 4.02183E-44
•
e. None of these
11. What is the Statistical interpretation? (4 points)
•
a. The P-value is smaller than 5% thus the result is inconclusive.
•
b. The P-value is smaller than 5% thus we are confident to confirm the claim.
•
c. The P-value is too large to have a conclusive answer.
•
d. Average of data is inconsistent with the claim.
•
e. None of the above.
12. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 1 has many patients who have had heart attack.
•
b. We can claim that Hospital 1 has more patients who have had heart attack than
patients who have made suicide attempt.
•
c. We cannot claim that Hospital 1 has more patients who have had heart attack than
patients who have made suicide attempt.
•
d. None of these.
13. What test/procedure did you perform? (4 points)
•
a. One sided t-test
•
b. Two sided t-test
•
c. Regression
•
d. Confidence Interval
14. What would be the correct Null-Hypothesis? (4 points)
•
a. The population averages are equal.
•
b. The slope of the regression line is equal to zero.
•
c. Age and wages should not be related.
•
d. Age and wages should be related.
15. What is the P-value/margin of error and what can be statistically concluded based on
the Null Hypothesis? (4 points)
•
a. 3.92E-05 and we accept the Null Hypothesis
•
b. 1.1525E-243 and we reject the Null Hypothesis
•
c. 2.305E-243 and we do not reject the Null Hypothesis
•
d. 3.92E-05 and we reject the Null Hypothesis
16. What is the Statistical interpretation? (4 points)
•
a. The P-value is much smaller than 5% thus the test result is inconclusive.
•
b. The P-value is much smaller than 5% thus we are confident that the slope is not
zero.
•
c. The P-value is greater than 5% thus we can claim that age is related to wage.
•
d. None of these.
17. What is the conclusion? (4 points)
•
a. We are confident that age and wage are not related.
•
b. We are confident that age and wage are negatively related, older people earn lesser
wages on average.
•
c. We cannot be confident that older people earn higher average wages than do
younger people.
•
d. None of these.
Upload the WagesHW12, use the wage column to make the histogram
(start the bin column from 0 and choose bin size=4) and answer the
questions:
18. The chart you created resembles which of the shape above? (4
points)
a. Bell shape
b. Double-Bell shape
c. Right-Skewed shape
d. Left-Skewed shape
19. For this data which of the following is true? (4 points)
a. StDev < Median < Average
b. Average < StDev < Median
c. Median < Average < StDev
d. StDev < Average < Median
e. None of these
20. Which class (interval) has the highest frequency? (4 points)
a. 0-4
b. 4-8
c. 8-12
d. 12-16
Upload the Hospitals_HW13, use the Suicide Attempt column to make
the histogram (start the bin column from 0 and choose bin size=10) and
answer the questions:
21. The chart you created resembles? (4 points)
a. Bell shape
b. Double-Bell shape
c. Right-Skewed shape
d. Left-Skewed shape
22. For this data which of the following is true? (Enter the letter that
corresponds to your answer in the fourth blank below) (4 points)
a. StDev < Median < Average
b. Average < StDev < Median
c. Median < Average < StDev
d. StDev < Average < Median
e. None of these
Your health insurance company has converge for three types of medical treatment. The annual
cost for each type of treatment can be modeled using Gaussian (Normal) distribution, with the
following parameters:
•
Treatment 1: Mean=$1600 and Standard Deviation=$120
•
Treatment 2: Mean=$1500 and Standard Deviation=$95
•
Treatment 3: Mean=$1200 and Standard Deviation=$70
Use Random number generator and simulate 1000 long columns, for each of the three cases.
Example: for the Treatment 1, use Number of variables=1, Number of random numbers=1000,
Distribution=Normal, Mean=1600 and Standard deviation=120, and leave random Seed empty.
Next: use either sorting or construct the appropriate histogram or rule of thumb to answer the
questions:
23. What is approximate probability that Treatment 3 has annual cost less than $1150? (4
points)
•
a. Between 20% and 30%
•
b. Between 30% and 70%
•
c. Between 70% and 85%
•
d. None of these
24. Which of the three treatment is most likely to cost between $1200 and $1300? (4
points)
•
a. Treatment 1
•
b. Treatment 2
•
c. Treatment 3
25. For which of the three treatments we expect that (approximately) 95% of cases will be
between $1300 and $1700? (4 points)
•
a. Treatment 1
•
b. Treatment 2
•
c. Treatment 3
Her is
Hospital_HW13
Hospital
attempt
1
84
1
90
1
96
1
92
1
82
1
81
car accidents
domestic accident
134
93
108
126
109
61
38
21
27
30
12
31
53
58
51
55
52
52
Heart attack
Suicide
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
93
93
74
94
98
87
91
89
80
102
97
89
92
90
105
90
91
90
91
91
91
58
70
93
96
79
92
78
79
95
85
94
94
84
87
96
101
96
101
88
89
81
84
92
102
113
88
62
97
89
70
97
101
77
111
89
99
60
113
78
81
109
59
69
97
100
98
141
103
88
107
124
101
55
72
81
61
109
72
77
88
97
68
103
88
20
100
90
123
95
75
128
108
126
120
97
108
66
120
93
98
140
176
115
57
131
93
81
99
84
115
101
103
97
56
51
51
49
53
47
42
51
44
51
46
51
53
55
52
44
45
49
62
55
55
53
62
52
49
54
52
53
51
49
46
44
45
55
50
49
51
45
45
51
42
53
43
51
50
48
49
51
51
43
56
57
60
43
50
55
49
37
13
41
45
25
29
18
40
31
30
31
22
23
42
35
26
14
26
46
39
21
35
33
29
42
33
24
51
12
38
28
30
37
38
29
23
32
26
26
21
34
16
29
34
37
31
16
32
26
34
7
28
28
25
43
26
33
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
101
97
84
91
76
95
73
93
90
82
95
104
88
94
90
96
93
93
83
85
95
93
89
146
116
133
121
139
127
137
131
152
114
127
128
130
123
124
136
124
136
145
137
133
122
126
126
140
129
130
141
126
125
125
119
143
125
128
85
91
59
60
70
48
89
79
83
133
93
68
101
93
92
99
117
74
112
80
108
79
157
131
159
126
167
132
139
154
205
125
166
112
147
119
156
189
127
154
158
151
140
93
124
143
156
158
156
183
161
192
136
139
148
160
41
57
54
50
53
50
54
48
52
54
52
53
51
52
53
44
47
50
43
45
57
39
43
50
60
46
53
50
47
47
52
51
54
60
52
48
47
53
54
48
47
52
59
48
55
46
51
47
44
51
47
43
53
51
51
63
53
29
34
41
32
34
23
24
28
33
22
25
19
33
16
35
47
38
20
40
23
34
1
26
25
29
25
24
37
33
28
10
50
48
21
47
36
42
26
23
38
35
33
35
35
27
39
28
41
19
25
22
21
19
18
21
20
18
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
127
123
148
129
124
130
123
135
114
132
138
125
129
127
120
138
136
118
125
130
135
133
131
112
116
126
123
134
117
123
120
120
145
143
135
135
125
133
115
135
130
126
106
141
114
124
131
123
129
112
136
133
130
136
141
133
133
121
163
147
160
152
152
166
170
123
119
153
150
149
162
117
176
149
128
141
140
157
123
140
113
129
160
159
158
125
146
119
120
215
190
147
131
152
138
105
153
163
138
123
194
121
179
177
168
118
127
112
147
148
130
196
147
151
55
49
54
47
62
55
55
48
52
41
49
48
56
46
43
54
51
52
51
42
53
48
57
44
55
39
46
49
54
56
52
59
45
57
57
46
51
47
41
56
44
54
53
44
53
50
50
52
49
55
46
52
52
44
54
49
57
23
38
28
23
40
35
18
16
51
19
1
32
29
27
35
31
22
43
30
33
16
37
30
28
41
38
17
8
16
38
22
29
44
8
30
19
32
36
27
26
21
15
49
19
20
45
28
13
46
23
38
25
33
43
43
30
13
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
128
114
130
151
145
124
121
124
136
129
130
102
103
123
142
142
161
164
156
173
147
173
166
168
182
168
170
169
161
180
172
169
167
162
157
159
157
194
174
169
148
155
172
168
174
163
180
164
162
174
169
164
165
161
168
172
173
145
68
169
177
191
141
148
122
163
139
104
93
118
123
180
155
216
222
187
214
162
211
197
193
231
197
236
192
175
202
231
205
181
184
197
181
164
227
162
200
161
166
212
186
198
183
205
198
199
201
208
200
207
159
222
203
205
51
54
59
52
53
42
54
54
51
50
41
50
53
54
50
47
49
47
52
56
47
60
47
44
54
51
56
49
44
50
49
51
51
47
54
45
48
47
53
41
46
45
52
50
60
46
49
53
51
51
52
44
50
47
52
44
38
39
18
30
14
17
15
37
28
38
35
37
32
40
20
26
51
50
46
29
34
31
40
16
26
36
23
33
20
47
28
34
29
18
42
32
43
34
35
35
37
31
34
27
37
38
38
28
32
17
10
32
28
51
18
20
46
27
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
184
162
148
176
170
161
167
174
182
159
170
167
169
155
182
183
169
175
165
179
156
193
153
166
183
166
169
170
185
170
153
180
163
174
182
179
172
180
143
173
169
191
181
162
164
176
155
177
171
162
164
182
175
166
167
174
165
255
170
173
222
204
183
193
213
199
158
198
162
170
169
210
197
171
164
211
188
193
197
183
225
192
194
204
178
214
221
180
238
155
163
222
206
169
202
191
184
177
223
181
173
203
210
232
167
196
190
231
222
243
224
196
179
203
47
49
44
47
60
56
50
40
58
48
51
45
55
48
50
49
51
53
54
53
42
49
45
59
49
48
49
51
44
49
49
51
51
47
51
51
56
61
49
50
50
52
43
49
50
50
51
51
53
46
56
53
51
41
56
48
47
44
14
39
12
34
28
24
29
34
13
22
40
27
45
40
28
41
58
30
18
31
31
23
22
50
43
29
33
26
29
26
17
34
41
28
36
19
22
22
32
26
19
27
14
44
57
23
40
27
32
31
43
48
30
43
25
29
3
3
3
3
3
3
3
3
3
166
169
179
176
175
173
164
175
183
209
244
200
249
210
217
209
207
222
53
53
51
52
45
48
51
51
53
39
25
40
27
27
35
39
43
18
