Homogeneity of Variance Tests in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Homogeneity of Variance Tests capabilities.
For further information visit UNISTAT User's Guide section 7.4.2. Homogeneity of Variance Tests.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Homogeneity of Variance Tests
For AUC
| Test Statistic | Probability | |
|---|---|---|
| classified by Period | ||
| Bartlett’s Chi-square Test | 0.0680 | 0.7943 |
| Bartlett-Box F Test | 0.0689 | 0.7929 |
| Cochran’s C (max var / sum var) | 0.5401 | 0.7944 |
| Hartley’s F (max var / min var) | 1.1745 | |
| Levene’s F Test | 0.2243 | 0.6404 |
Multiple Comparisons (Tukey-HSD)
Method: 95% Tukey-HSD interval
** denotes significantly different pairs. Vertical bars show homogeneous subsets.
A pairwise test result is significant if its q stat value is greater than the table q.
| Group | N-1 | Ln(variance) | 2 | 1 | |
|---|---|---|---|---|---|
| 2 | 11 | 10.3044 | | | ||
| 1 | 11 | 10.4653 | | |
| Comparison | Difference | Standard Error | q Stat | Table q | Probability | Lower 95% | Upper 95% | Result |
|---|---|---|---|---|---|---|---|---|
| 1 - 2 | 0.1608 | 0.4264 | 0.3772 | 2.7718 | 0.7897 | -1.0211 | 1.3427 |
| Homogeneous Subsets: |
|---|
| Group 1: 2, 1 |
Multiple Comparisons (S-N-K)
Method: 95% Student-Newman-Keuls interval
** denotes significantly different pairs. Vertical bars show homogeneous subsets.
A pairwise test result is significant if its q stat value is greater than the table q.
| Group | N-1 | Ln(variance) | 2 | 1 | |
|---|---|---|---|---|---|
| 2 | 11 | 10.3044 | | | ||
| 1 | 11 | 10.4653 | | |
| Comparison | Difference | Standard Error | q Stat | Table q | Probability | Lower 95% | Upper 95% | Result |
|---|---|---|---|---|---|---|---|---|
| 1 - 2 | 0.1608 | 0.4264 | 0.3772 | 2.7718 | 0.7897 | * | * |
| Homogeneous Subsets: |
|---|
| Group 1: 2, 1 |
Comparisons against a Control Group (Dunnett)
Method: 95% Dunnett interval
Control Group: 1, Two-Tailed Test
** denotes significantly different pairs. Vertical bars show homogeneous subsets.
A pairwise test result is significant if its q stat value is greater than the table q.
| Group | N-1 | Ln(variance) | 1 | |
|---|---|---|---|---|
| 2 | 11 | 10.3044 | | | |
| 1 | 11 | 10.4653 | | |
| Comparison | Difference | Standard Error | q Stat | Table q | Probability | Lower 95% | Upper 95% | Result |
|---|---|---|---|---|---|---|---|---|
| 2 - 1 | -0.1608 | 0.6030 | 0.2667 | 1.9601 | 0.7897 | -1.3428 | 1.0211 |
| Homogeneous Subsets: |
|---|
| Group 1: 2, 1 |
Homogeneity of Variance Tests
For AUC
| Test Statistic | Probability | |
|---|---|---|
| classified by Period | ||
| Bartlett's Chi-square Test | 0.0680 | 0.7943 |
| Bartlett-Box F Test | 0.0689 | 0.7929 |
| Cochran's C (max var / sum var) | 0.5401 | 0.7944 |
| Hartley's F (max var / min var) | 1.1745 | |
| Levene's F Test | 0.2243 | 0.6404 |
| classified by Sequence | ||
| Bartlett's Chi-square Test | 4.2737 | 0.0387 |
| Bartlett-Box F Test | 4.3410 | 0.0373 |
| Cochran's C (max var / sum var) | 0.7889 | 0.0386 |
| Hartley's F (max var / min var) | 3.7366 | |
| Levene's F Test | 6.5725 | 0.0177 |
| classified by Treatment | ||
| Bartlett's Chi-square Test | 1.0143 | 0.3139 |
| Bartlett-Box F Test | 1.0292 | 0.3104 |
| Cochran's C (max var / sum var) | 0.6516 | 0.3140 |
| Hartley's F (max var / min var) | 1.8700 | |
| Levene's F Test | 1.5735 | 0.2229 |
| Overall | ||
| Bartlett's Chi-square Test | 2.4017 | 0.4933 |
| Bartlett-Box F Test | 0.8128 | 0.4868 |
| Cochran's C (max var / sum var) | 0.3645 | 0.7621 |
| Hartley's F (max var / min var) | 4.1552 | |
| Levene's F Test | 1.2526 | 0.3173 |