Unpaired Proportions in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with Unpaired Proportions capabilities.

For further information visit UNISTAT User's Guide section 6.4.4. Unpaired Proportions.

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

Unpaired Proportions

Data option: Two Columns Contain Two Categories Each

Species: A -> 1, B -> 2
Condition: 0 -> 1, 1 -> 2

	Species	Condition	Total
1	9	10	19
2	13	10	23
Total	22	20	42

Difference Between Unpaired Proportions

Proportion 1	0.4091
Proportion 2	0.5000

	Difference	Standard Error	Z-Statistic	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Pooled Variance	-0.0909	0.1538	-0.5912	0.2772	0.5544	-0.3923	0.2105
Separate Variance		0.1533	-0.5932	0.2765	0.5531	-0.3913	0.2095

Risk Ratio

	Value	Lower 95%	Upper 95%
Risk Ratio	0.8182	0.4201	1.5934

Odds Ratio and Relative Risks

	Value	Lower 95%	Upper 95%
Odds Ratio	0.6923	0.2042	2.3471
Exact		0.1722	2.7654
Relative Risk (Cohort 1)	0.8381	0.4626	1.5183
Relative Risk (Cohort 2)	1.2105	0.6436	2.2768