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
EXCEL EXERCISE WEEK 7
Brittany Johnson
Suppose we want to merely determine whether or not subsequent blood pressure measurement where higher or
lower than one another. One approach would be to use the Sign Test.
Refer to the Sign Test tab in the

HLTH 501
WEEK 4 PROBLEMS30 POINTS
Brittany Johnson
10 ponts per problem.
1.
The mean body mass index (BMI) for boys age 12 is 23.6. An investigator wants to test if
the BMI is higher in 12-year-old boys living in New York City. How many boys are
needed to

HLTH 501
WEEK 5 PROBLEMS30 POINTS
Brittany Johnson
10 points per problem. Place answer in the following table:
1.
p
34 / 105 0.324
RR 1
p 2 29 / 295 0.098
=3.31.
p /(1 p1 ) 0.324 /(1 0.324) 0.479
OR 1
p 2 /(1 p 2 ) 0.098 /(1 0.098) 0.109
= 4.39.
2.
a.
b.

HLTH 501
WEEK 6 PROBLEMS30 POINTS
Brittany Johnson
10 points each. Place answers in the following table:
1.
Employee
Sick Days Taken
in 12 Months
Prior to Program
Sick Days Taken
Difference
Sign
in 12 Months
(Reduction =
Following
Prior-After )
program
(

HLTH 501
EXCEL EXERCISE WEEK 6
Brittany Johnson
Refer to the Incidence tab in the assignment spreadsheet:
How many patients are represented in these data?_23_ 2 pts
How many patients had disease at the start of the study?_13_ 2 pts
How many patients becam

HLTH 501
EXCEL EXERCISE WEEK 5
Brittany Johnson
Refer to the Scatterplot, Regressions and Correlations tabs to answer the following questions.
Looking at the scatterplot what is the maximum value for systolic blood pressure?_150_1 pt.
Looking at the scatt

HLTH 501
EXCEL EXERCISE 3
Brittany Johnson
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

HLTH 501
EXCEL EXERCISE WEEK 2
Brittany Johnson
Refer to the Histogram tab in the Excel Assignment Spreadsheet and answer the following.
What percent of the sample weighs 170 lbs. or less? _40%_ % 1 pt
How many subjects weigh more than 200 lbs? _17_ 1 pt

HLTH 501
EXCEL EXERCISE WEEK 8
Brittany Johnson
Refer to the Survival Graph tab in the Excel Assigment spresdsheet.
Sixty percent of the subjects can be expected to survive for how long? _22_months 2 pts
After 5 months of treatment what proprtion of the p

HLTH 501
WEEK 6 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1. Alpha= _.05_
n= _7_
Critical value= _0_
Smaller of the number of positive or negative signs= _1_
(b.)
2. Alpha= _.05_
N1= _5_
N2= _5_
Critical value U= _2_
Smaller

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.62962962963_ 1 pt
What is the median for Diastolic_1_Grp_1? _ 101_ 1 pt
What

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% (Median is 50th percentile)
H 75% (Q3 represents 75 percentile)
2.(.788), (.872)
3. (.749), .(2396), (3.6)
1. The following

HLTH 501
WEEK 8 PROBLEMS30
POINTS
15 points each. Place answers within the Word document below.
1. A study is conducted to estimate survival in patients following kidney transplant. Key factors
that adversely affect success of the transplant include advan

HLTH 501
WEEK 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1.
(a) 3.31, (b) 4.39
2.
(a) 438.51, (b) 501.41, (c) 425.84
3.
(a) 2.49, (b) 1.85
1. A study is run to estimate the association between exposure to lead paint in

HLTH 501
WEEK 3 PROBLEMS30
POINTS
10 points per problem. Put answers in the table:
1.
.192, 2.097, 2.74, D
2.
df=3, a=.05, 7.81, 28.32, a.
3.
=
=
_.27_
_.367_
= _.175_
Z = _3.35_
B.
1. A clinical trial is conducted comparing a new pain medication for arth

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
WEEK 7 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1.
20.2%, 28.4%, 14.8%
2.
3.5, .78, 4.49
3.
7.7%, 9.9%, 16.8%
1. A cohort study is conducted to assess the association between clinical characteristics
and the risk of

HLTH 501
WEEK 4 PROBLEMS30 POINTS
10 ponts per problem.
1.
The mean body mass index (BMI) for boys age 12 is 23.6. An investigator wants to test if
the BMI is higher in 12-year-old boys living in New York City. How many boys are
needed to ensure that a tw

HLTH 501
EXCEL EXERCISE WEEK 7
Suppose we want to merely determine whether or not subsequent blood pressure measurement where higher or
lower than one another. One approach would be to use the Sign Test.
Refer to the Sign Test tab in the assignment spread

HLTH 501
WEEK 8 PROBLEMS30
POINTS
Brittany Johnson
15 points each. Place answers within the Word document below.
1. A study is conducted to estimate survival in patients following kidney transplant. Key factors
that adversely affect success of the transpl