UNISTAT - the ultimate Excel statistics add-in

Homogeneity of Variance Tests in Excel with Unistat

The Unistat statistics add-in extends Excel with Homogeneity of Variance Tests capabilities.

Further documentation is available at section 7.4.2 of the manual, Homogeneity of Variance Tests.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Homogeneity of Variance Tests

For AUC

Test StatisticSignificance
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) 1.1745 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) 3.7366 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) 1.8700 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) 1.7208 0.7621
Hartley's F (max var / min var) 4.1552
Levene's F Test 1.2526 0.3173