Manuals/calci/TTESTTWOSAMPLESUNEQUALVARIANCES

TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)

• $Array1$ and $Array2$ are set of values.
• $HypothesizedMeanDifference$ is the Hypothesized Mean Difference.
• $Alpha$ is the significance level.
• $NewTableFlag$ is either 0 or 1.

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 $TTESTTWOSAMPLESUNEQUALVARIANCES(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)$, $Array1$ and $Array2$ are two arrays of sample values.
• $HypothesizedMeanDifference$ is the Hypothesized Mean Difference. Suppose HypothesizedMeanDifference = 0 which indicates that sample means are hypothesized to be equal.
• $Alpha$ is the significance level which ranges from 0 to 1.
• $NewTableFlag$ 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:

$t={\frac {{\bar {x_{1}}}-{\bar {x_{2}}}}{s_{{\bar {x_{1}}}-{\bar {x_{2}}}}}}$ where $s_{{\bar {x_{1}}}-{\bar {x_{2}}}}={\sqrt {{\frac {s_{1}^{2}}{n_{1}}}+{\frac {s_{2}^{2}}{n_{2}}}}}$

• Here $s_{1}^{2}$ and $s_{2}^{2}$ are unbiased estimators of the variances of two samples. $n_{1}$ and $n_{2}$ are the number of data points in two arrays. $s_{{\bar {x_{1}}}-{\bar {x_{2}}}}$ 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