Difference between revisions of "Bartlett'sTest"

Revision as of 07:40, 9 May 2017

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.

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}}})}}$

@@ Line 8: / Line 8: @@
 * 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.
-   <math>B=\frac{df_WlnMS_W-\sum_{j}df_jln s_j^2}{1+\frac{1}{3(k-1)}(\sum_{j}\frac{1}{df_j})-\frac{1}{df_W}}</math>
+   <math>B=\frac{df_WlnMS_W-\sum_{j}df_jln s_j^2}{1+\frac{1}{3(k-1)}(\sum_{j}\frac{1}{df_j}-\frac{1}{df_W})}</math>