Two Proportions in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Two Proportions capabilities.
For further information visit UNISTAT User's Guide section 6.7.6. Two Proportions.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Size and Power Estimation: Two Proportions
Sample Size
| Proportion 1 | 0.4500 |
|---|---|
| Proportion 2 | 0.2500 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| N2 / N1 | 1.0000 |
| Estimated Sample Size | 127.2343 |
Sample Size and Power Estimation: Two Proportions
Sample Size
| Proportion 1 | 0.4500 |
|---|---|
| Proportion 2 | 0.2500 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| N2 / N1 | 3.0000 |
| Estimated Sample Size | 83.1527 |
Sample Size and Power Estimation: Two Proportions
Power of the Test
| Sample Size 1 | 50.0000 |
|---|---|
| Sample Size 2 | 45.0000 |
| Proportion 1 | 0.7500 |
| Proportion 2 | 0.5000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Power of the Test | |
| 2-Tail Probability | 0.6402 |