HLTH 501
EXCEL EXERCISE WEEK 2
Refer to the Histogram tab in the Excel Assignment Spreadsheet and answer the following.
What percent of the sample weighs 170 lbs. or less? _34.48_ % 1 pt
How many subjects weigh more than 200 lbs? _10_ 1 pt
What percent of
HLTH 501
EXCEL EXERCISE WEEK 3
The standard deviation is a measure of how much variation is present in a sample or population.
Refer to the Descriptives table in the spreadsheet and identify the standard deviation for the
weights of the three groups. Ente
HLTH 501
WEEK 2 PROBLEMS30
POINTS
10 points per problem. Put answers in table below:
1.
A. 205
B. 175
C. 245
D. 70
E. 350
F. No
G. 50
H. 75
2.
A. Sensitivity = P(Smoker/Nicotine Present) = 52/66 = 0.7878
B. Specificity = P(Non-smoker/Nicotine Absent) = 82
HLTH 501
EXCEL EXERCISE WEEK 1
Locate the Descriptives tab in the Excel Assignment Spreadsheet and answer the following
questions.
What is the mean for Systolic BP_2_Grp2? _166.6296296_ 1 pt
What is the median for Diastolic_1_Grp_1? _101_ 1 pt
What is the
HLTH 501
WEEK 1 PROBLEMS30 POINTS
6 points per problem. Put answers in the following table:
1.
A-3
B-10
C-4
D-8
E-6
F-2
G-1
H-9
I-7
J-5
2. Type of study: Case-control study
Strengths: Strengths for this study would include time and costs. Since the study