UNISTAT - the ultimate
Excel statistics add-in
Sample Size and Power Estimation: One Sample in Excel with Unistat
The Unistat statistics add-in extends Excel with Sample Size and Power Estimation: One Sample capabilities.
Further documentation is available at section 6.7.1 of the manual, Sample Size and Power > One Sample.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Sample Size and Power Estimation: One Sample
Sample Size in Estimating Population Mean
| Denominator Degrees of Freedom | 2.0000 |
|---|---|
| Sample Variance | 0.4008 |
| Half-Width of Confidence Interval | 0.2500 |
| Assurance for Confidence Interval | 0.9000 |
| Confidence Level | 0.9500 |
| Estimated Sample Size | 27.0740 |
Sample Size and Power Estimation: One Sample
Sample Size in Tests Concerning Mean
| Sample Variance | 1.5682 |
|---|---|
| Minimum Detectable Difference | 1.0000 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Estimated Sample Size | 18.4992 |
Sample Size and Power Estimation: One Sample
Minimum Detectable Difference
| Sample Size | 25.0000 |
|---|---|
| Sample Variance | 1.5682 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Minimum Detectable Difference | 0.8470 |
Sample Size and Power Estimation: One Sample
Power of the Test
| Sample Size | 12.0000 |
|---|---|
| Sample Variance | 1.5682 |
| Minimum Detectable Difference | 1.0000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Power of the Test | |
| t-Statistic | 0.5652 |
| 2-Tail Probability | 0.7084 |