HLTH 501
EXCEL EXERCISE MODULE/WEEK 6
Refer to the Incidence tab in the assignment spreadsheet:
How many patients are represented in these data?_ 2 pts
Answer:
23 patients
How many patients had disease at the start of the study?_ 2 pts
Answer:
13 patients
HLTH 501
EXCEL EXERCISE WEEK 8
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 patiensts are stil
HLTH 501
EXCEL EXERCISE MODULE/WEEK 6
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 became diseased
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 2
Refer to the Histogram tab in the Excel Assignment Spreadsheet and answer the following.
What percent of the sample weighs less than 170 lbs.? (% 1 pt)
Answer:
20.69%
How many subjects weigh at least 200 lbs? (1 pt)
Answer:
HLTH 501
EXCEL EXERCISE WEEK 5
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?_1 pt.
Answer:
Maximum plotted systolic blood pr
HLTH 501
WEEK 6 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1.
Alpha= 0.05, n= 7, Critical value= 0, Smaller of the number of positive or negative signs= 1
B. There is not statistically significant evidence at alpha= 0.05 to sh
HLTH 501
WEEK 2 PROBLEMS30 POINTS
10 points per problem. Put answers in table below:
1. Answer the following questions associated with the box-whisker plot.
A.
B.
C.
D.
E.
F.
G.
H.
205
175
245
70
350
No
50%
75%
2. What is the sensitivity of self-reported
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? _ 1 pt
Answer:
166.6296296
What is the median for Diastolic_1_Grp_1? _ 1 pt
Answer:
HLTH 501
WEEK 1 PROBLEMS30 POINTS
6 points per problem. Put answers in the following table:
Question #1
A. Bias = 3. Systematic uncertainty
B. Clinical Trial = 10. Subject randomly assigned to treatment groups
C. Confounding = 7. Risk factor distortion
D.
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
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
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
EXCEL EXERCISE WEEK 5
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 scatterplot what is th
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.7 1 pt
What is the median for Diastolic_1_Grp_1? 101 1 pt
What is the Standard
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 3 PROBLEMS30
POINTS
10 points per problem. Put answers in the table:
1. RD =0.192
RR = 2.0971
OR = 2.7332
C. One can be 95% confident that the true value will between the upper and lower limit.
2. Df = 3
Alpha = 0.05
Reject Hoif x2 > 7.81
X2
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 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? 34.48% 1 pt
What percent of
HLTH 501
EXCEL EXERCISE 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. Enter the
HLTH 501
WEEK 1 PROBLEMS30 POINTS
6 points per problem. Put answers in the following table:
1.
A: 3
B: 10
C: 7
D: 8
E: 6
F: 2
G: 1
H: 9
I: 4
J: 5
2. Case- Control Study
Strengths:
1. Easy to conduct
2. Important in the field of medicine and have served as
HLTH 501
EXCEL EXERCISE WEEK 8
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 patiensts are still
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 7 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1.
Compute the prevalence of hypertension at baseline.
Prevalence = 0.2016=20.16%
Compute the prevalence of hypertension at 2 years.
Prevalence = 0.284=28.4%
Compute t
HLTH 501
WEEK 6 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1.
Employee
Sick Days Taken in
12 Months Prior to
Program
1
2
3
4
5
6
7
8
8
6
4
12
10
8
6
2
Sick Days Taken
in 12 Months
Following
program
7
6
5
11
7
4
3
1
Difference
BIOSTATISTICS CASE STUDY:
Tests of Association for Categorical Data
There are seven questions at the end of this article. This assignment is worth 80 points. Place
answers in this table:
1. E
2. 275/399 = 68.9%
3. Upper Limit CI = 0.732649
Lower Limit CI
HLTH 501
WEEK 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1.
A.
3.293924
RR
B.
4.392
OR
34/71 = 0.4788
29/266 = 0.109
2.
A. 438.505
B. 501.41
C. 425.835
3.
A. 2.28823
B. 1.85
1. A study is run to estimate the associat
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