UNISTAT - the ultimate
Excel statistics add-in
Paired Proportions in Excel with Unistat
The Unistat statistics add-in extends Excel with Paired Proportions capabilities.
Further documentation is available at section 6.4.5 of the manual, Nonparametric Tests > Paired Proportions.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Paired Proportions
Data option: Two Columns Contain Two Categories Each
| Status = 0 | Status = 1 | Total | |
|---|---|---|---|
| Sex = Female | 5 | 14 | 19 |
| Sex = Male | 7 | 22 | 29 |
| Total | 12 | 36 | 48 |
Difference Between Paired Proportions
| Difference | 0.1458 |
|---|---|
| Normal Approximation: | |
| Z-Statistic | 1.5275 |
| 2-Tail Probability | 0.1266 |
| 95% Confidence Interval | -0.0367 <> 0.3283 |
| Exact Binomial: | |
| 2-Tail Probability | 0.1892 |
| 95% Confidence Interval | -0.0610 <> 0.3099 |
Fisher's Exact Test
| 1-Tail Probability | 0.5626 |
|---|
McNemar's Test
| Chi-Square Statistic | 12.1905 |
|---|---|
| Degrees of Freedom | 1 |
| Right-Tail Probability | 0.0005 |
Odds Ratio (Paired)
| Odds Ratio (Paired) | 4.4000 |
|---|---|
| 95% Confidence Interval | 1.1202 <> 11.1690 |