UNISTAT - the ultimate
Excel statistics add-in
Sample Size and Power Estimation: Variance in Excel with Unistat
The Unistat statistics add-in extends Excel with Sample Size and Power Estimation: Variance capabilities.
Further documentation is available at section 6.7.3 of the manual, Sample Size and Power > Variance.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Sample Size and Power Estimation: Variance
Sample Size
| Sample Variance | 2.6898 |
|---|---|
| Population Variance | 1.5000 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| Estimated Sample Size | 50.7813 |
Sample Size and Power Estimation: Variance
Power of the Test
| Sample Size | 8.0000 |
|---|---|
| Sample Variance | 2.6898 |
| Population Variance | 1.5000 |
| Confidence Level | 0.9500 |
| Power of the Test | |
| Chi-Square Statistic | 7.8447 |
| Right-Tail Probability | 0.3465 |