Project #15598 - Biostats

For  problems involving a hypothesis test, after running the computer program and printing the results, you are to write on the bottom of the page the 6 step testing procedure just like regular homework problems.

 

 

 

MUST DO IN EXCEL

 

 

 

Problem 1 Excel (pg 362 problem 18)

 

 

 

18.) Patients on chronic fatigue syndrome were tested, then retested after being treated with fluorocortisone. Listed below are the changes in fatigue after the treatment. A standard scale from -7 to +7 was used, with positive values representing improvements. Use a 0.01 significance level to test the claim that the mean change is a positive. Does the treatment appear to be effective?

 

6, 5, 0, 5, 6, 7, 3, 3, 2, 6, 5, 5, 0, 6, 3, 4, 3, 7, 0, 4, 4

 

 

 

Test on the mean:

 

Input data (dpi) into column 1

 

Click on down arrow after S symbol, select z-test

 

Array- highlight data in column 1

 

X – input mean 100

 

Sigma – input 16

 

 

 

 

 

Problem 2 Excel  (pg 406 problem 8)

 

Catopril is a drug designed to lower systolic blood pressure. When subjects were tested with this drug, their systolic blood pressure readings (in mmHg) were measured before and after the drug was taken, with the results given in the accompanying table.

 

a.)   use the sample data to construct a 99% confidence interval for the mean difference between the before & after readings

 

b.)  Is there sufficient evidence to support the claim that catopril is effective in lowering systolic blood pressure?

 

c.)   95% conf. interval and test on the difference in means-paired data input data, then click on data analysis select t-test paired data

 

d.)  variable1 – highlight column 1

 

e.)   variable2 – highlight column 2

 

f.)    Mean – input 0

 

 

 

Subject

A

B

C

D

E

F

G

H

I

J

K

L

Before

200

174

198

170

179

182

193

209

185

155

169

210

After

191

170

177

167

159

151

176

183

159

145

146

177

 

 

 

 

 

Note: problems 3 and 4 use the same data.

 

 

 

 

 

Problem 3 Excel pg 422 problem 4

 

Refer to the given data for the measured amounts of CO from samples of filtered and nonfiltered king-sized cigarettes. All measurements are in milligrams, and the data are from the Federal Trade Commission. Use a 0.05 significance level to test the claim that the mean amount of CO in filtered king-size cigarettes is equal to the mean amount of CO for nonfiltered king-size cigarettes. Based on this result, are cigarette filters effective in reducing CO?

 

Filtered: 14, 12, 14, 16, 15, 2, 14, 16, 11, 13, 13, 12, 13, 12, 13, 14, 14, 14, 9, 17, 12

 

Nonfiltered: 14, 15, 17, 17, 16, 16, 14, 16

 

 

 

95% conf. interval and test on the difference in means-paired data

 

input data, then

 

Click on data analysis select t-test unequal variances

 

variable1 – highlight column 1

 

variable2 – highlight column 2

 

Mean – input 0

 

 

 

c1

C2

74

124

78

109

91

119

130

112

115

100

119

117

115

82

108

130

115

93

112

96

142

50

102

112

103

93

106

117

 

 

 

 

 

 

 

Subject Mathematics
Due By (Pacific Time) 10/31/2013 12:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy