Biostats; mean, median EXCEL

Directions: This take-home assignment is open-book. This means that you can use your notes, textbook, and materials on th
website found at http://blackboard.udmercy.edu/. The Excel data file can be found in the Assignments section of Blackboar
to perform the calculations requested to answer the questions below.
* Exams will be turned in on Wednesday, October 19, 2022.
* The axes of graphs need to be properly labeled.
* Answer the short essay questions by inserting textboxes into your Excel worksheets.
Path: Insert → Text → TextBox
* Upload your Excel file into the Take-home 2 digital drop box. Do not worry if the derived Blackboard PDF is not formatte
Formatting issues will be resolved when the instructor downloads the Excel file onto his computer.
Note on cheating and plagiarism: You may not get ANY help from ANYONE other than the instructor. If you have technical p
contact the instructor. The penalty for cheating on this exam is a grade of zero (0). You must digitally sign the Honor state
it in with the exam.
Honor statement: By signing this page, I affirm that I completed this open-book, open-notes take-home exam witho
help from other people (with the exception of the instructor, Dr. Stokes Baker).
Type your name here–>
Date –>
otes, textbook, and materials on the course’s
Assignments section of Blackboard. Use Excel
d Blackboard PDF is not formatted correctly.
instructor. If you have technical problems
ust digitally sign the Honor statement and hand
n-notes take-home exam without
Atherosclerosis
130
114
138
156
139
126
105
149
123
131
141
144
138
127
121
108
143
118
139
142
136
137
137
119
127
125
122
112
139
124
130
125
114
123
140
149
132
125
144
128
110
130
119
125
131
125
Healthy
101
91
96
95
95
108
113
92
106
81
103
106
99
101
96
100
125
82
125
89
96
90
108
84
96
87
111
88
123
94
83
98
122
90
105
107
122
100
121
107
98
118
99
111
110
98
Q1: (2 points) What were the means and median systolic blood pressure of the
healthy and diseased population? Is there a difference between the two
populations?
Q2: (10 points) Create a relative frequency polygon that displays the distribution of each
population on the same graph. How do the distributions of each population compare?
Which method is better at comparing two populations? Use intervals of 5 mm Hg in your
graph. Describe the distribution of the class. (Number of modes, shape, skewed,
there a difference in the distributions of the two populations?
Q3: (18 points) At the research hospital you are doing your residency in, the attending
physician asked you to do a meta-analysis of the hospital records to see if using systolic
blood pressure would be a good diagnostic screen for detecting atherosclerosis.
Instructions will be posted on the Bio2900 Knowledge website.
a) Create a receiver operating characteristic curve.
b) Does the curve indicate that systolic blood pressure can be used as a diagnostic screen?
c) If so, what blood pressure should be used as an indicator of atherosclerosis concern?
(Hint: The first stage of treatment is putting your patient on a low-fat, low sodium diet.)
d) What would be that test’s sensitivity? What would be the specificity?
139
123
149
132
132
129
117
148
142
139
135
126
134
119
137
130
129
128
123
131
133
136
129
122
104
135
119
135
133
131
155
120
99
103
134
147
109
120
132
150
127
139
115
140
141
107
128
110
102
88
82
90
96
116
98
97
106
107
105
96
104
94
119
96
94
94
93
109
96
101
107
121
111
97
94
103
106
90
86
108
107
108
89
109
109
107
96
89
95
114
96
106
93
91
110
130
133
111
147
121
116
90
143
117
114
145
143
120
112
139
116
113
131
124
117
126
118
148
134
121
123
162
150
139
113
146
155
119
148
118
126
147
134
149
159
118
130
138
166
135
121
103
96
103
100
98
88
95
98
99
100
123
100
102
101
93
110
106
78
107
115
109
106
98
95
102
97
92
84
104
98
117
105
102
81
103
97
104
108
93
93
118
102
96
95
101
100
104
137
140
128
145
113
134
128
136
129
124
129
128
137
123
122
116
145
129
142
125
105
117
123
126
175
128
127
162
119
117
99
127
149
113
142
145
138
121
116
117
142
102
131
139
129
130
118
97
117
106
90
88
102
103
95
94
95
109
100
74
95
105
91
111
110
111
92
97
83
117
118
107
94
102
74
121
107
108
101
99
80
103
95
102
79
82
83
100
93
101
89
95
121
106
120
131
132
136
140
135
127
127
123
124
127
131
135
129
127
133
117
131
169
124
115
126
123
123
137
127
112
127
135
123
163
113
137
114
137
140
131
136
120
156
125
113
132
137
121
118
139
102
124
110
105
89
100
103
105
102
113
110
97
106
97
124
101
103
114
104
104
95
93
105
100
95
79
103
87
107
89
97
104
86
100
102
107
113
99
100
116
98
107
104
88
86
80
116
126
135
156
132
140
116
121
151
133
123
112
133
128
125
139
124
133
109
115
143
126
essure of the
he distribution of each
population compare?
vals of 5 mm Hg in your
shape, skewed, etc.). Is
cy in, the attending
o see if using systolic
herosclerosis.
as a diagnostic screen?
erosclerosis concern?
fat, low sodium diet.)
Receiver Operating Characteristic
False positive has high consequence
False positive has low consequence
Receiver Operating Characteristic (ROC) Curves:
(A) line of zero discrimination (AUC=0.5); (B) typical
clinical test (AUC=0.5–1.0); perfect test (AUC=1.0).
Abdul Ghaaliq Lalkhen, and Anthony McCluskey Contin Educ Anaesth Crit Care Pain 2008;8:221-223
Excel Equations
Video at https://youtu.be/-rfzhtLOYq8
Calculating Receiving Operating
Calculating Receiving Operating
Calculating Receiving Operating
What would be the appropriate sensitivity and false
positive rate?
Sensitivity: 0.943
False positive: 0.187
What would be the appropriate BMI cut-off value?
Sensitivity: 0.943
False positive: 0.187