UNISTAT - the ultimate
Excel statistics add-in
Jonckheere's Trend in Excel with Unistat
The Unistat statistics add-in extends Excel with Jonckheere's Trend capabilities.
Further documentation is available at section 6.5.2 of the manual, Nonparametric Tests > Jonckheeres Trend.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Jonckheere's Trend
| Cases | |
|---|---|
| Treatment 1 | 8 |
| Treatment 2 | 8 |
| Treatment 3 | 8 |
| Treatment 4 | 8 |
| Total | 32 |
| P | 265.0000 |
|---|---|
| Q | 111.0000 |
| P-Q | 154.0000 |
| Variance P-Q | 3531.0452 |
| Z-Statistic | 2.5916 |
| 1-Tail Probability | 0.0048 |