Binomial Proportion in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with Binomial Proportion capabilities.

For further information visit UNISTAT User's Guide section 6.4.3. Binomial Proportion.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

Binomial Proportion

Data option: Column Contains Two Categories

	Cases
Species = A	9
Species = B	13
Total	22

Runs Test

	Number of Runs	Z-Statistic	1-Tail Probability	2-Tail Probability
Asymptotic	8	-1.4197	0.0779	0.1557
Asymptotic with CC		-1.6460	0.0499	0.0998

Binomial Test

Expected Proportion	0.5000
Observed Proportion	0.4091

	Proportion used in SE	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Wald	0.4091	0.1048				0.2036	0.6145
H0	0.5000	0.1066	-0.8528	0.1969	0.3938
Wald with CC	0.4091	0.1048				0.1809	0.6373
H0	0.5000	0.1066	-0.6396	0.2612	0.5224
Wilson (score)						0.2326	0.6127
Wilson with CC						0.2148	0.6332
Agresti-Coull	0.4226	0.0972				0.2321	0.6131
Agresti-Coull (+2)	0.4231	0.0969				0.2332	0.6130
Jeffreys						0.2253	0.6151
Clopper-Pearson (exact)				0.2617	0.5235	0.2071	0.6365

Noninferiority Test

Expected Proportion	0.5000
Observed Proportion	0.4091
Noninferiority Margin	0.2000

	Proportion used in SE	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 90%	Upper 90%
Wald	0.4091	0.1048	1.0407	0.1490		0.2367	0.5815
H0	0.3000
Wald with CC	0.4091	0.1048	0.8239	0.2050		0.2139	0.6042
H0	0.3000
Clopper-Pearson (exact)				0.1865	0.3729	0.2327	0.6048

Superiority Test

Expected Proportion	0.5000
Observed Proportion	0.4091
Superiority Margin	0.2000

	Proportion used in SE	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 90%	Upper 90%
Wald	0.4091	0.1048	-2.7752	0.0028		0.2367	0.5815
H0	0.7000
Wald with CC	0.4091	0.1048	-2.5584	0.0053		0.2139	0.6042
H0	0.7000
Clopper-Pearson (exact)				0.0043	0.0087	0.2327	0.6048

Equivalence Test

Expected Proportion	0.5000
Observed Proportion	0.4091
Lower Equivalence Margin	-0.2000

Lower Equivalence	Proportion used in SE	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 90%	Upper 90%
Wald	0.4091	0.1048	1.0407	0.1490		0.2367
H0	0.3000
Wald with CC	0.4091	0.1048	0.8239	0.2050		0.2139
H0	0.3000
Clopper-Pearson (exact)				0.1865		0.2327

Upper Equivalence Margin	0.2000

Upper Equivalence	Proportion used in SE	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 90%	Upper 90%
Wald	0.4091	0.1048	-2.7752	0.0028			0.5815
H0	0.7000
Wald with CC	0.4091	0.1048	-2.5584	0.0053			0.6042
H0	0.7000
Clopper-Pearson (exact)				0.0043			0.6048

Overall	1-Tail Probability	Lower 90%	Upper 90%
Wald	0.1490	0.2367	0.5815
Wald with CC	0.2050	0.2139	0.6042
Clopper-Pearson (exact)	0.1865	0.2327	0.6048