From ZCubes Wiki
Revision as of 17:30, 20 December 2016 by Devika (talk | contribs)
Jump to navigation Jump to search
TTESTTWOSAMPLESEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)

  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is either 0 or 1.


  • This function calculating the two Sample for equal variances determines whether two sample means are equal.
  • We can use this test when both:
  • 1.The two sample sizes are equal;
  • 2.It can be assumed that the two distributions have the same variance.
  • In , and are two arrays of sample values. is the Hypothesized Mean Difference .
  • Suppose HypothesizedMeanDifference=0 which indicates that sample means are hypothesized to be equal.
  • is the significance level which ranges from 0 to 1.
  • is either 0 or 1.
  • "1" is indicating the result will display in new worksheet.Suppose we are omitted the NewTableFlag value it will consider the value as "0".
  • The t statistic of this function calculated by:


  • Here and are unbiased estimators of the variances of two samples. is the grand standard deviation data 1 and data2 and n is the data points of two data set.
  • This function will give the result as error when
  1.any one of the argument is non-numeric.
  3. and  are having different number of data points.