A large company institutes an exercise break for its workers to see if this will improve job satisfaction, as measured by a questionnaire that was given to a random sample of workers to assess their satisfaction.
Worker # nbspWorker # |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
---|---|---|---|---|---|---|---|---|---|---|---|
Before |
35 |
29 |
28 |
42 |
27 |
25 |
23 |
18 |
20 |
30 |
|
After |
33 |
42 |
48 |
39 |
30 |
37 |
38 |
24 |
26 |
42 |
Find the test-statistic and p-value.
Using Excel
data -> data analysis -> t-Test: Paired Two Sample for Means
t-Test: Paired Two Sample for Means | ||
Before | After | |
Mean | 27.7 | 35.9 |
Variance | 49.7889 | 57.6556 |
Observations | 10 | 10 |
Pearson Correlation | 0.4805 | |
Hypothesized Mean Difference | 0 | |
df | 9 | |
t Stat | -3.4665 | |
P(T<=t) one-tail | 0.0035 | |
t Critical one-tail | 1.8331 | |
P(T<=t) two-tail | 0.0071 | |
t Critical two-tail | 2.2622 |
Ho:mu_d = 0
Ha: mu_d > 0
this is right-tailed test(one-tail)
TS = -3.4665
p-value = 0.0035
Please give me a thumbs-up if this helps you out. Thank you! :)
Get Answers For Free
Most questions answered within 1 hours.