UNISTAT - the ultimate
Excel statistics add-in
Paired Samples in Excel with Unistat
The Unistat statistics add-in extends Excel with Paired Samples capabilities.
Further documentation is available at section 6.4.2 of the manual, Nonparametric Tests > Paired Samples.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Paired Samples
Wilcoxon Signed Rank Test
For Drug and Placebo
| Cases | Rank Sum | Mean Rank | |
|---|---|---|---|
| Negative Differences | 6 | 38.0000 | 6.3333 |
| Positive Differences | 4 | 17.0000 | 4.2500 |
| Total | 10 | 55.0000 | 5.5000 |
| Wilcoxon Signed Rank Test | 17.0000 |
|---|---|
| Asymptotic with Continuity Correction: | |
| Z-Statistic | 1.0273 |
| 2-Tail Probability | 0.3043 |
Hodges-Lehmann Estimator (Paired)
For Drug and Placebo
| Median of Walsh Differences | -1.0000 |
|---|---|
| Normal Approximation: | |
| K* | 9 |
| 95% Confidence Interval | -4.5000 <> 1.0000 |
Sign Test
For Drug and Placebo
| Cases | |
|---|---|
| Negative Differences | 6 |
| Positive Differences | 4 |
| Ties | 0 |
| Total | 10 |
| Sign Test | 6.0000 |
|---|---|
| Exact Binomial: | |
| 2-Tail Probability | 0.7539 |
| Asymptotic with Continuity Correction: | |
| Z-Statistic | 0.3162 |
| 2-Tail Probability | 0.7518 |
Table of Ranks
For Drug and Placebo
| Row | Drug | Placebo | Difference | Signed Rank | Ordered Difference |
|---|---|---|---|---|---|
| 1 | 19.0000 | 22.0000 | -3.0000 | -6.5000 | -8.0000 |
| 2 | 11.0000 | 18.0000 | -7.0000 | -8.0000 | -7.0000 |
| 3 | 14.0000 | 17.0000 | -3.0000 | -6.5000 | -3.0000 |
| 4 | 17.0000 | 19.0000 | -2.0000 | -5.0000 | -3.0000 |
| 5 | 23.0000 | 22.0000 | 1.0000 | 2.5000 | -2.0000 |
| 6 | 11.0000 | 12.0000 | -1.0000 | -2.5000 | -1.0000 |
| 7 | 15.0000 | 14.0000 | 1.0000 | 2.5000 | 1.0000 |
| 8 | 19.0000 | 11.0000 | 8.0000 | 9.5000 | 1.0000 |
| 9 | 11.0000 | 19.0000 | -8.0000 | -9.5000 | 1.0000 |
| 10 | 8.0000 | 7.0000 | 1.0000 | 2.5000 | 8.0000 |