View the step-by-step solution to:

Use Excel to test. For each paired difference, compute After - Before. In the Data Analysis, t-Test: Paired Two Sample for means, select the After...

Use Excel to test. For each paired difference, compute After - Before. In the 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.


 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

What is the critical t-value?

Select from the following answer

a) 5.614 or -5.614

b) 3.645 or -3.645

c) 1.711 or -1.711

d) 7.861 or -7.861

Top Answer

The best way to approach your question... View the full answer

Excel.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online