在EXCEL中实现多总体方差的Bartlett齐性检验

在总体服从正态分布的前提下,方差齐性与否决定了单因素多水平的模型能否采用方差分析来检验均数间的差异。主要介绍在EXCEL中,Bartlett齐性检验的自动计算工具的设计与实现。工具完成后可以重复使用,大大减少以后齐性检验计算的工作量。

Realizing the Test of Bartlett Homogeneity of Variance for N Population Variance in Excel

Under the prerequisite that population be subjected to normal distribution,homogeneity of variance is one of the conditions that may determine whether ANOVA model can use variance analysis to test the difference between N population means.This paper is mainly about the design and realization of the tool of auto computation for Bartlett homogeneity of variance in EXCEL and after it is completed,it can be repeated in use so as to reduce greatly the amount of work for homogeneity of variance test in future.