Use Excel to Test. For each paired difference, compute After – Before. In Data A

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 170

Explanation / 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.0001

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.