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	87	50	48	79	61	53	54
2	82	91	92	80	52	79	73	74
3	79	84	74	98	63	83	85	58
4