UNISTAT - the ultimate
Excel statistics add-in
Unpaired Proportions in Excel with Unistat
The Unistat statistics add-in extends Excel with Unpaired Proportions capabilities.
Further documentation is available at section 6.4.4 of the manual, Nonparametric Tests > Unpaired Proportions.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Unpaired Proportions
Data option: Two Columns Contain Two Categories Each
Condition: 0 = 0, 1 = 1
Species: A = 0, B = 1
| Condition | Species | Total | |
|---|---|---|---|
| 0 | 10 | 9 | 19 |
| 1 | 10 | 13 | 23 |
| Total | 20 | 22 | 42 |
Difference Between Unpaired Proportions
| Difference | 0.0909 |
|---|---|
| Normal Approximation: | |
| Z-Statistic | 0.5912 |
| 2-Tail Probability | 0.5544 |
| Pooled Variance | 0.0236 |
| 95% Confidence Interval | -0.2105 <> 0.3923 |
| Separate Variance | 0.0235 |
| 95% Confidence Interval | -0.2095 <> 0.3913 |
Risk Ratio
| Risk Ratio | 1.2222 |
|---|---|
| 95% Confidence Interval | 0.6276 <> 2.3803 |
Odds Ratio (Unpaired)
| Odds Ratio (Unpaired) | 1.4444 |
|---|---|
| 95% Confidence Interval | 0.4261 <> 4.8971 |