Use Excel to Test. For each paired difference, compute After – Before. In Data A
ID: 3245841 • Letter: U
Question
Use Excel to Test. For each paired difference, compute After – Before. In Data Analysis, t-Test: Paired Two Sample for means, select the After data for Variable 1 Range. Note that the critical value output by Data Analysis for this test is always positive. In this problem, the sign of the critical value is negative corresponding to a 1-tailed test with lower reject region and negative lower critical value.
What is your conclusion:
a) Reject the NULL Hypothesis because the actual value is less than the critical value
b) Do not reject the NULL Hypothesis because the actual value exceeds the critical value
c) Reject the NULL Hypothesis because the actual value exceeds the critical value
d) Do not reject the NULL Hypothesis because the actual value is less than the critical value
Person Before After 1 176 164 2 192 191 3 185 176 4 177 176 5 196 185 6 178 169 7 196 196 8 181 172 9 158 158 10 201 193 11 191 185 12 193 189 13 176 175 14 212 210 15 177 173 16 183 180 17 210 204 18 198 192 19 157 152 20 213 200 21 161 161 22 177 166 23 210 203 24 192 186 25 178 170Explanation / Answer
The statistical software output for this problem is:
Paired T hypothesis test:
D = 1 - 2 : Mean of the difference between After and Before
H0 : D = 0
HA : D 0
Hypothesis test results:
p - value is almost 0 hence, we reject Ho.
Option a is correct.
Difference Mean Std. Err. DF T-Stat P-value After - Before -5.68 0.8014986 24 -7.0867248 <0.0001Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.