UNISTAT - the ultimate
Excel statistics add-in
Single Proportion in Excel with Unistat
The Unistat statistics add-in extends Excel with Single Proportion capabilities.
Further documentation is available at section 6.4.3 of the manual, Nonparametric Tests > Binomial Proportion.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Single Proportion
Data option: Column Contains Two Categories
| Cases | |
|---|---|
| Species = A | 9 |
| Species = B | 13 |
| Total | 22 |
Runs Test
| Number of Runs | 8 |
|---|---|
| Normal Approximation: | |
| Z-Statistic | -1.4197 |
| 2-Tail Probability | 0.1557 |
Binomial Test
| Expected Proportion | 0.5000 |
|---|---|
| Observed Proportion | 0.4091 |
| Exact Binomial: | |
| 2-Tail Probability | 0.5235 |
| 95% Confidence Interval | 0.2071 <> 0.6365 |
| Asymptotic with Continuity Correction: | |
| Z-Statistic | 0.6396 |
| 2-Tail Probability | 0.5224 |
| 95% Confidence Interval | 0.2148 <> 0.6332 |
| Asymptotic without Continuity Correction: | |
| Z-Statistic | -0.8528 |
| 2-Tail Probability | 0.3938 |
| 95% Confidence Interval | 0.2326 <> 0.6127 |