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 the subjects
HLTH 501
Carinne Meline
EXCEL EXERCISE MODULE/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.62_ 1 pt
What is the median for Diastolic_1_Grp_1? _101_
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
STUDY GUIDE FOR FINAL EXAM OF BIOSTATISTICS
FROM CHAPTERS 8 , 9, 10, 3, 11 FINAL EXAM)
These chapters are from textbook: Essentials of Biostatistics in Public Health.
PRACTICE PROBLEMS INCLUDING ANSWERS CHAPTER 3
BIOSTATISTICS - WEEK 7
Chapter 3 Solution
Carinne Meline
October 25, 2013
HLTH 501
WEEK 1 PROBLEMS30 POINTS
6 points per problem. Put answers in the following table:
1.
A3
B 10
C7
D8
E6
F2
G1
H9
I4
J5
2. Type of study: Nested case control study, because the individuals meet a set of
inclusion (Pa
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
Carinne Meline
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 e
Carinne Meline
HLTH 501
WEEK 3 PROBLEMS30 POINTS
10 points per problem. Put answers in the table:
1.
RD = 0 .192
RR = 2.09
OR = 2.7
b. One can be 95% confident that the true value will be greater than the lower limit.
2.
df= _3_
alpha= _0.05_
Reject H0
HLTH 501
WEEK 2 PROBLEMS30 POINTS
10 points per problem. Put answers in table below:
1.
A
B
C
D
E
F
G
H
205
175
245
70
350
no (265 <350)
50%
75%
2.
A. What is the sensitivity of self-reported smoking status?
0.81 = 52/(52+12) = a/(a+c)
B. What is the spec
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
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? _40_ % 1 pt
How many subjects weigh more than 200 lbs? _17_ 1 pt
What percent of th
Carinne Meline
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 gr
MIDTERM EXAM STUDY GUIDE
(FROM CHAPTERS 1, 2 ,4, 5, 6, 7 MIDTERM TEST)
These chapters are from textbook: Essentials of Biostatistics in Public Health.
_
PRACTICE PROBLEMS INCLUDING ANSWERS CHAPTER 2
BIOSTATISTICS - WEEK 1
Solutions to Problems
1
An inves
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 the subj
PRACTICE PROBLEMS INCLUDING ANSWERS CHAPTER 5
BIOSTATISTICS - WEEK 2
Chapter 5 Solutions to Problems
1
A recent study reported that the prevalence of hyperlipidemia (defined as total cholesterol over
200) is 30% in children 2-6 years of age. If 12 childr
Carinne Meline
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 pat
Power and Sample Size Determination
Week 7 Discussion post (Due Wednesday June 13th by 11:00 p.m. CST)
Based on your course project data, please answer the following questions:
1. What margin of error did you calculate for your estimate of the population
Carinne Meline
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 scatter
Carinne Meline
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 scatter
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? _ % 1 pt
How many subjects weigh more than 200 lbs? _ 1 pt
What percent of the subj
HLTH 501
CHAPTER PROBLEMS 6
Answer the following. (3 pts ea)
1. A company is evaluating the impact of a wellness program offered on-site as a
means of reducing employee sick days. A total of 8 employees agree to participate in
the evaluation which lasts 1
Carinne Meline
HLTH 501
WEEK 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1. A. 3.306
B. 4.394
2. A. 438.51
B. 501.41
C. 425.84
3. A. 2.23
B. 1.85
1. A study is run to estimate the association between exposure to lead pa
Carinne Meline
October 25, 2013
HLTH 501
WEEK 1 PROBLEMS30 POINTS
6 points per problem. Put answers in the following table:
1.
A3
B 10
C7
D8
E6
F2
G1
H9
I4
J5
2. Type of study: Nested case control study, because the individuals meet a set of
inclusion (Pa
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
MODULE/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 th
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? 17 months 2 pts
After 5 months of treatment what proprtion of the patiensts are still
BIOSTATISTICS CASE STUDY:
Tests of Association for Categorical Data
Carinne Meline
There are seven questions at the end of this article. This assignment is worth 80 points.
Place answers in this table:
1. D. A & C
2.
275/399= 68.9%
3. Upper limit CI = _0.
Carinne Meline
HLTH 501
WEEK 7 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1. A. 0.2016 or 20.16%
B. 0.284 or 28.4%
C. 0.1483 or 14.83%
2. A. 0.3889
B. 2.571
C. 4.4722
3. A. 76.8
B. 1.44
C. 9.12
1. A cohort study is conducted t
PUBH 6125/8125 Step-by-Step Guide to Week 8:
This week you are learning about the importance of power and sample size to research
conducted in Public Health. Please review the text material, as well as the PowerPoint
on Type 1 and Type 2 error before usin
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 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 0.78
B 0.87
3.
A 0.75
B 0.24
C 3.6
1. The following box-whisker plot shows the distributions of total cholesterol le
HLTH 501
WEEK 3 PROBLEMS30 POINTS
10 points per problem. Put answers in the table:
1.
= 0.192
= 2.0971
= 2.7332
D. a and b
2. df=3
alpha= 0.5
2
Reject H0 if > 1.960
25.5 41 33 25.5
25.5 41 33 25.5
2= 28.332
A. We
have statistically significant evidence at
HLTH 501
WEEK 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1. A.
3.29
B.
4.39
2. A.
= 438.51
B.
= 501.41
C.
= 425.84
3. A.
= 2.488
B.
= 1.855
1. A study is run to estimate the association between exposure to lead paint i
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 Sta