# 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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews