UNISTAT - the ultimate
Excel statistics add-in
Multisample Median Test in Excel with Unistat
The Unistat statistics add-in extends Excel with Multisample Median Test capabilities.
Further documentation is available at section 6.5.3 of the manual, Nonparametric Tests > Multisample Median Test.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Multisample Median Test
| Cases | > Median | <= Median | |
|---|---|---|---|
| Herbs | 5 | 5 | 0 |
| Shrubs | 5 | 1 | 4 |
| Trees | 5 | 1 | 4 |
| Total | 15 | 7 | 8 |
| Median | 6.9000 |
|---|---|
| Chi-Square Statistic | 8.5714 |
| Degrees of Freedom | 2 |
| Right-Tail Probability | 0.0138 |
Multiple Comparisons (Tukey-HSD)
Method: 95% Tukey-HSD interval.
** denotes significantly different pairs. Vertical bars show homogeneous subsets.
A pairwise test result is significant if its q stat value is greater than the table q.
| Group | Cases | Mean | Shrubs | Trees | Herbs | |
|---|---|---|---|---|---|---|
| Shrubs | 5 | 1.0000 | ** | | | ||
| Trees | 5 | 1.0000 | ** | | | ||
| Herbs | 5 | 5.0000 | ** | ** | | |
| Comparison | Difference | Standard Error | q Stat | Table q | Significance | Lower 95% | Upper 95% | Result |
|---|---|---|---|---|---|---|---|---|
| Herbs - Shrubs | 4.0000 | 1.1547 | 3.4641 | 3.3145 | 0.0380 | 0.1728 | 7.8272 | ** |
| Trees - Shrubs | 0.0000 | 1.1547 | 0.0000 | 3.3145 | 1.0000 | -3.8272 | 3.8272 | |
| Herbs - Trees | 4.0000 | 1.1547 | 3.4641 | 3.3145 | 0.0380 | 0.1728 | 7.8272 | ** |
| Homogeneous Subsets: |
|---|
| Group 1: Shrubs Trees |
| Group 2: Herbs |