Difference between revisions of "Bartlett'sTest"

Revision as of 08:25, 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 23: / Line 23: @@
 |-
 ! 1
-| 51 || 87 || 50 || 48 || 79 || 61 || 53 || 54
+| 51 || 82 || 79 || 85
 |-
 ! 2
-| 82 || 91 || 92 || 80 || 52 || 79 || 73 || 74
+| 87 || 91 || 84 || 80
 |-
 !3
-| 79 || 84 || 74 || 98 || 63 || 83 || 85 || 58
+| 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
+|}