Manuals/calci/TTESTUNEQUALVARIANCES

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

• $ar1$ and $ar2$ are set of values.
• $md$ is the Hypothesized Mean Difference.
• $alpha$ is the significance level.
• $lv$ 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 $TTESTTWOSAMPLESUNEQUALVARIANCES(ar1,ar2,md,alpha,lv)$, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar2 } are two arrays of sample values.
• $md$ is the Hypothesized Mean Difference. Suppose md = 0 which indicates that sample means are hypothesized to be equal.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle alpha } is the significance level which ranges from 0 to 1.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lv } is the logical value like TRUE or FALSE.
• TRUE is indicating the result will display in new worksheet.Suppose we are omitted the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lv} value it will consider the value as FALSE.
• The t-statistic of this function calculated by:

$t={\frac {{\bar {x_{1}}}-{\bar {x_{2}}}}{s_{{\bar {x_{1}}}-{\bar {x_{2}}}}}}$ where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s_{\bar{x_1}-\bar{x_2}}= \sqrt{\frac{s_1^2}{n_1}+\frac{s_2^2}{n_2}} }

• Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s_1^2} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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

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. =TTESTSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,0.5)

See Also

• TTEST
• TDIST
• TINV
• TTESTEQUALVARIANCES