ANOVA in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with ANOVA capabilities.
For further information visit UNISTAT User's Guide section 6.7.7. ANOVA.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Size and Power Estimation: ANOVA
Sample Size
| Number of Groups | 3.0000 |
|---|---|
| Minimum Detectable Difference | 2.0000 |
| Error Mean Square | 1.6550 |
| Power of the Test | 0.8000 |
| Confidence Level | 0.9500 |
| Phi | 1.9093 |
| Estimated Sample Size | 9.0500 |
Sample Size and Power Estimation: ANOVA
Maximum Number of Groups
| Total No of Cases (nk) | 50.0000 |
|---|---|
| Minimum Detectable Difference | 2.0000 |
| Error Mean Square | 1.6550 |
| Power of the Test | 0.8000 |
| Confidence Level | 0.9500 |
| Phi | 1.6539 |
| Number of Groups | 4.7000 |
Sample Size and Power Estimation: ANOVA
Minimum Detectable Difference
| Sample Size | 20.0000 |
|---|---|
| Number of Groups | 3.0000 |
| Error Mean Square | 1.6550 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| Phi | 2.1092 |
| Minimum Detectable Difference | 1.4862 |
Sample Size and Power Estimation: ANOVA
Power of the Test
| Sample Size | 10.0000 |
|---|---|
| Number of Groups | 4.0000 |
| Error Mean Square | 7.5888 |
| Minimum Detectable Difference | 4.0000 |
| Confidence Level | 0.9500 |
| Phi | 1.6234 |
| Power of the Test | 0.7349 |