Manuals/calci/TTESTUNEQUALVARIANCES

TTESTTWOSAMPLESUNEQUALVARIANCES(ar1,ar2,md,alpha,lv)


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is the logical value.

Description

  • This function calculating the two Sample for unequal variances determines whether two sample means also distinct.
  • We can use this test when both:
  • 1.the two sample sizes are may are may not be equal;
  • 2. The means and variances are distinct .
  • In  ,   and   are two arrays of sample values.
  •   is the Hypothesized Mean Difference. Suppose md = 0 which indicates that sample means are hypothesized to be equal.
  •   is the significance level which ranges from 0 to 1.
  •   is the logical value like TRUE or FALSE.
  • TRUE is indicating the result will display in new worksheet.Suppose we are omitted the   value it will consider the value as FALSE.
  • The t-statistic of this function calculated by:

  where  

  • Here   and   are unbiased estimators of the variances of two samples.   and   are the number of data points in two arrays.   is not a pooled variance.
  • This function will give the result as error when
     1. any one of the argument is non-numeric.
     2.alpha>1

Examples

Spreadsheet
A B C D E F G
1 12 21 9 18 27 37 41
2 19 8 45 29 14 10 11


  1. =TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5)
Result
Variable 1 Variable 2
Mean 20.666666666666668 20.833333333333332
Variance 105.06666666666665 196.56666666666666
Observations 6 6
Hypothesized Mean Difference 3
Degree Of Freedom 9
T- Statistics -0.4466201458140038
P(T<=t) One-tail 0.3328511748583461
T Critical One-Tail 0
P(T<=t) Two-tail 0.6657023497166922
T Critical Two-Tail 0.7027221467691982

Related Videos

TTESTUNEQUALVARIANCES

See Also

References