Two Samples in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Two Samples capabilities.
For further information visit UNISTAT User's Guide section 6.7.2. Two Samples.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Size and Power Estimation: Two Samples
Sample Size in Estimating Two Population Means
| Denominator Degrees of Freedom | 11.0000 |
|---|---|
| Pooled Variance | 0.5193 |
| Half-Width of Confidence Interval | 0.5000 |
| Assurance for Confidence Interval | 0.9000 |
| Confidence Level | 0.9500 |
| N1 Given (Optional) | 0.0000 |
| Estimated Sample Size | 17.2934 |
Sample Size and Power Estimation: Two Samples
Sample Size in Tests Concerning Two Means
| Pooled Variance | 0.5200 |
|---|---|
| Minimum Detectable Difference | 0.5000 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| N1 Given (Optional) | 30.0000 |
| Estimated Sample Size | 44.7245 |
| N2 when N1 Given | 87.8328 |
Sample Size and Power Estimation: Two Samples
Minimum Detectable Difference
| Sample Size | 20.0000 |
|---|---|
| Pooled Variance | 0.5193 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Minimum Detectable Difference | 0.7585 |
Sample Size and Power Estimation: Two Samples
Power of the Test
| Sample Size | 15.0000 |
|---|---|
| Pooled Variance | 0.5193 |
| Minimum Detectable Difference | 1.0000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Power of the Test | |
| t-Statistic | 1.7519 |
| 2-Tail Probability | 0.9546 |
| Phi | 2.6872 |
| Probability | 0.9561 |