Toxicology Example |
|
|
|
|
|
|
|
|
Unit 2 Section 2 |
|
|
|
|
Wilcoxon Rank Sum Test |
|
|
|
|
Square Root Transformed |
Square Root Transformed |
Excel Rank |
Excel Rank |
Tied Rank |
Tied Rank |
|
Control |
Nitrofen |
Control |
Nitrofen |
Control |
Nitrofen |
Control |
Nitrofen |
|
27 |
29 |
5.20 |
5.39 |
4 |
6 |
4.5 |
7.5 |
|
32 |
29 |
5.66 |
5.39 |
15 |
6 |
15.0 |
7.5 |
|
34 |
23 |
5.83 |
4.80 |
18 |
1 |
18.5 |
1.0 |
|
33 |
27 |
5.74 |
5.20 |
16 |
4 |
16.5 |
4.5 |
|
36 |
30 |
6.00 |
5.48 |
20 |
10 |
20.0 |
11.0 |
|
34 |
31 |
5.83 |
5.57 |
18 |
13 |
18.5 |
13.5 |
|
33 |
30 |
5.74 |
5.48 |
16 |
10 |
16.5 |
11.0 |
|
30 |
26 |
5.48 |
5.10 |
10 |
3 |
11.0 |
3.0 |
|
24 |
29 |
4.90 |
5.39 |
2 |
6 |
2.0 |
7.5 |
|
31 |
29 |
5.57 |
5.39 |
13 |
6 |
13.5 |
7.5 |
Sample Mean |
31.400 |
28.300 |
5.595 |
5.315 |
132.0 |
65.0 |
136.0 |
74.0 |
Sample Variance |
12.933 |
5.567 |
0.109 |
0.052 |
|
|
use this |
|
Sample Std. Dev |
3.596 |
2.359 |
0.330 |
0.228 |
T_U = |
|
127 |
|
Sample Size |
10.000 |
10.000 |
10.000 |
10.000 |
|
|
critical value |
Separate Variance |
1.850 |
|
0.016 |
|
|
|
|
|
c |
0.699 |
|
0.678 |
95% UCL |
Untransformed |
|
|
df(separate) |
15 |
|
15 |
Lower Bound |
-0.29 |
|
|
|
t-statistic(separate) |
2.279 |
|
2.202 |
Upper Bound |
6.49 |
|
|
|
t-critical(separate) |
2.131 |
|
2.131 |
Average Difference |
3.10 |
|
|
|
p-value |
0.019 |
|
0.022 |
|
|
|
|
|
Pooled Variance |
9.250 |
|
0.080 |
95% UCL |
Untransformed |
|
|
df(pooled) |
18 |
|
18 |
Lower Bound |
-0.23 |
|
|
|
t-statistic(pooled) |
2.279 |
|
2.202 |
Upper Bound |
6.43 |
|
|
|
t-critical(pooled) |
2.101 |
|
2.101 |
Average Difference |
3.10 |
|
|
|
p-value |
0.018 |
|
0.020 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sample Size
Estimation |
|
|
|
|
|
|
|
Pooled variance |
9.250 |
|
|
|
|
|
|
|
Delta |
1 |
|
|
|
|
|
|
|
P(Type I error) |
0.05 |
|
|
|
|
|
|
|
Sample Size Needed |
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|