Variance in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Variance capabilities.
For further information visit UNISTAT User's Guide section 6.7.3. Variance.
Here we provide a sample 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 |