Manuals/calci/LEVENESTEST

LEVENESTEST(xRange,ConfidenceLevel,NewTableFlag)

• $xRange$ is the set of values for the test.
• $ConfidenceLevel$ is the value from 0 to 1.
• $LogicalValue$ is either TRUE or FALSE. TRUE for getting results in a new cube. FALSE will display results in the same cube.

Description

• This function used to test the Homogeneity of variances.
• Levene's test is used to test the Samples have equal variances.
• Equal variances across samples is called homogeneity of variance or homoscedasticity.
• To do the Levenes test we need the following assumptions:

  1.The Samples from the populations are independent of one another. 
  2. The population under consideration are Normally Distributed. 

• For three or more variables the following statistical tests for homogeneity of variances are commonly used:

   1.Levene's Test.
   2.Bartlett Test.

• Levene's test is an alternative to the Bartlett test.
• If the data surely is of normally distributed or nearly to normally distributed then we can use the Bartlett test.
• The Levene's test is defined as

$H_{0}=\sigma _{1}^{2}=\sigma _{2}^{2}=......=\sigma _{t}^{2}$.
$H_{1}$=Not all of the variances are equal. 

• Normally there are three versions of the Levenes test.
• There are
• 1.Use of Mean.
• 2.Use of Median.
• 3.Use of 10% of Trimmed Mean.
• The Levene test statistic is:

$W={\frac {(N-k)\sum _{i=1}^{k}N_{i}(Z_{i}-Z)^{2}}{(k-1)\sum _{i=1}^{k}\sum _{i=1}^{k}\sum _{j=1}^{N_{i}}(Z_{ij}-Z_{i})^{2}}}$.

• • where $W$ is the result of the test.
  • $k$ is the number of different groups to which the sampled cases belong.
  • $N$ is the total number of cases in all groups.
  • $N_{i}$ is the number of cases in the $i^{th}$ group.
  • $Y_{ij}isthevalueofthemeasuredvariableforthe<math>j^{th}$ case from the $i^{th}$ group.
• Zij is satisfying the one of the following conditions:
• 1.$z_{ij}=|y_{ij}-{\bar {y_{i}}}|$,Where ${\bar {y_{i}}}$ is the Mean of the $i^{th}$ subgroup.
• 2.$z_{ij}=|y_{ij}-{\bar {y_{i}}}|$,Where ${\bar {y_{i}}}$ is the Median of the $i^{th}$ subgroup
• 3.$z_{ij}=|y_{ij}-{\bar {y_{i}}}|$,Where ${\bar {y_{i}}}$ is the 10%Trimmed Mean of the $i^{th}$ subgroup.
• Levene's Testing Procedure:
• 1. checking the assumptions.
• 2.State the Null(H0) and alternative(H1) hypothesis.
• 3.Decide on the Significance level (α).
• 4.Finding the Critical value and Rejection Region.Here $df_{1}=t-1$,$df_{2}=N-t$.
• 5.Compute the Levenes statistic using the formula.
• 6.Then decision of the value of the test statistic,W is falls in the rejection region or if p-value ≤ α, then reject $H_{0}$.Otherwise, fail to reject $H_{0}$. For the computation p-value we have to use the value of $df_{1}$ and $df_{2}$.
• 7. Finally we have to conclude that the rejection of $H_{0}$ or fail to rejection $H_{0}$ according to the test statistic at the significance level.

Example

X1	X2
3067	3200
2730	2777
2840	2623
2913	3044
2789	2834

1. =LEVENESTEST(B1:C5,.05,0)

+ LEVENES TEST

Stats	Data1	Data2
Median	2840	2834
Mean	2867.8	2895.6
Variance	16923.7	51713.3
Count	5	5
df	4	4

Regression Analysis SUMMARY OUTPUT

LevenesTest	Statistics
W	1.0439235110342522
F-Test	0.38245649772919
a	0.05
F	0.32726010523405
p 1 & 2 Tail	0.1524069466470822	0.3048138932941644