170 Use Excel to Test. For each paired difference, compute After – Before. In Da

Question

170

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 the critical t-value?

a) 3.645 or -3.645

b) 1.711 or -1.711

c) 5.614 or -5.614

d) 7.861 or -7.861

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

Degrees of freedom = n - 1 = 25 - 1 = 24

Assuming 90% confidence or 0.1 level of significance,

Critical t values = 1.711 or -1.711

Option b is correct.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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