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 |
Tutor | Rating |
---|---|
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.. |