Bartlett'sTest

BARTLETTSTEST(DataRange,ConfidenceLevel,NewTableFlag)

• $DataRange$ is the array of x values.
• $ConfidenceLevel$ is the value from 0 to 1.
• $NewTableFlag$ is either TRUE or FALSE. TRUE for getting results in a new cube. FALSE will display results in the same cube.

Description

• Bartlett's test is used to test if k samples are from populations with equal variances.
• Bartlett's test is sensitive to departures from normality.
• That is, if the samples come from non-normal distributions, then Bartlett's test may simply be testing for non-normality.

 $B={\frac {df_{W}lnMS_{W}-\sum _{j}df_{j}lns_{j}^{2}}{1+{\frac {1}{3(k-1)}}(\sum _{j}{\frac {1}{df_{j}}}-{\frac {1}{df_{W}}})}}$

• B is the Bartlett's test static.
• $MS_{W}$ is the pooled variance across all groups.

Result

• If p-value is greater than BCriticl value, reject the null hypothesis.
• Else retain null hypothesis.

Example

Spreadsheet

	A	B	C	D
1	51	82	79	85
2	87	91	84	80
3	50	92	74	65
4	48	80	98	71
5	79	52	63	67
6	61	79	83	51
7	53	73	85	63
8	54	74	58	93