UNISTAT - the ultimate Excel statistics add-in

Unpaired Samples in Excel with Unistat

The Unistat statistics add-in extends Excel with Unpaired Samples capabilities.

Further documentation is available at section 6.4.1 of the manual, Nonparametric Tests > Unpaired Samples.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Unpaired Samples

Mann-Whitney U Test

CasesRank SumMean RankU
Inpatients 32 858.0000 26.8125 694.0000
Outpatients 32 1222.0000 38.1875 330.0000
Total 64 2080.0000 32.5000

Mann-Whitney U Test 330.0000
Correction for Ties 410.5000
Normal Approximation:
Z-Statistic-2.4670
2-Tail Probability 0.0136

Hodges-Lehmann Estimator (Unpaired)

For Inpatients and Outpatients

Difference Between Medians-25.0000
K 367
Normal Approximation:
95% Confidence Interval-66.0000 <>-2.0000

Wald-Wolfowitz Runs Test

Exact probabilities for N <= 30, otherwise normal probabilities

CasesMeanStandard DeviationStandard Error
Inpatients 32-13.8750 252.8446 44.6970
Outpatients 32 15.3125 205.3409 36.2995
Total 64 0.7188 230.3207 28.7901

RunsZ-Statistic1-Tail Probability
23-2.5201 0.0059
37 1.0080 0.1567

Moses Extreme Reaction Test

Cases
Inpatients 32
Outpatients 32
Total 64

span1-Tail Probability
whole of group 1 56 0.0132
2 case(s) removed from ends 49 0.0738

Two Sample Median Test

> Median<=MedianTotal
Inpatients 10 22 32
Outpatients 22 10 32
Total 32 32 64

Median-74.5000
Fisher's Exact Probability:
2-Tail Probability 0.0055
Chi-square Approximation:
Chi-Square Statistic 7.5625
Degrees of Freedom 1
Right-Tail Probability 0.0060


DownloadUnistat 6.0
For Windows