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
Statistical methodology often involves taking random data and organizing it, summarizing it, and
presenting it in an understandable form. In effect it is creating order from chaos.
Read Genesis chapters 1 & 2. In these verses God describes His creating or
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
WEEK 3 PROBLEMS30 POINTS
10 points per problem. Put answers in the table:
1.
2.
3.
1. A clinical trial is conducted comparing a new pain medication for arthritis. Participants are
randomly assigned to receive the new medication or a placebo. The
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
What is the median for Diastolic_1_Grp_1? _ 1 pt
What is the Standard Deviat
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 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
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 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? _34.48_ % 1 pt
How many subjects weigh 200 lbs or more? _10_ 1 pt
What percent 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
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 6 PROBLEMS30 POINTS
10 points each. Place answers in the following table:
1.
Alpha= _0.05_
n= _8_
Critical value= _0_
Smaller of the number of positive or negative signs= _1_
Answer: B
2.
n (n 1)
U1 n1n 2 1 1
R 1 _
2
n (n 1)
U 2 n 1 n 2 2 2
After reading Genesis chapters 1 & 2, I have come to conclusion that I agree with the
perspective where God creates his order from chaos and how this directly relates to statistical
methodology. In the first two books you notice how God follows a certain
HLTH 501
WEEK 3 PROBLEMS30
POINTS
10 points per problem. Put answers in the table:
1.
RD= 0.191
RR= 2.09
OR= 2.72
C
2.
df= 3
alpha= 0.05
Reject H0 if x2 > 7.81
Frequencies: in column below
Compute x2*x2= 18.91
D
3.
Reject H0 if Z < -1.97 or if Z > 1.97
Al
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
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.7878
B. 0.8723
3.
A. 0.7472
B. 0.2397
C. 3.6
1. The following box-whisker plot shows the distributions of
HLTH 501
WEEK 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1.
2.
3.
1. A study is run to estimate the association between exposure to lead paint in childhood and
attention-deficit hyperactivity disorder (ADHD). Data on n
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 paint in childhoo
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.
(I completed the table below in red)
2.
R1= 18
R2=_37
Alpha= 0.05
N1= 2
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 stil
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? _23_months 2 pts
After 5 months of treatment what proprtion of the patiensts are stil
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 5 PROBLEMS30 POINTS
10 points per problem. Place answer in the following table:
1.
A. 3.294
B. 4.392
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 paint in childhoo
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. 52/66=.7878
B. 82/94=.8723
3.
A. 0.7472
B. 0.2397
C. 3.6
1. The following box-whisker plot shows the distributions 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
There has been enormous debate regarding the possibility of a link between childhood
vaccinations and the subsequent development of autism. 1This has become a major public
health issue with vaccine preventable diseases increasing in the community due to t
The changes that I chose to make for this 8 weeks of class is Deforestation.
My reasons are as follow:
Trees are absolutely vital to life here on Earth, but they are also being destroyed at an alarming
rate. So many of the choices we make throughout the d
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.A & C
2.275/399=68.9%
3. Upper limit CL= 0.732649
Loer limit Cl =
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 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.6296296_ 1 pt
What is the median for Diastolic_1_Grp_1? _101_ 1 pt
What is the
3) A randomized trial is conducted to evaluate the efficacy of a new cholesterol lowering medication. The
primary outcome is incident coronary artery disease. Participants are free of coronary artery disease at
the start of the study and randomized to rec
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 paint in childhood
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