Manuals/calci/TTESTUNEQUALVARIANCES
- 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 set of values.
- 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 md } is the Hypothesized Mean Difference.
- 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.
- 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.
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 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 TTESTTWOSAMPLESUNEQUALVARIANCES(ar1,ar2,md,alpha,lv), 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.
- 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 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 lv value it will consider the value as FALSE.
- The t statistic of this function calculated by:
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 t=\frac{\bar{x1}-\bar{x2}}{s_{\bar{x1}-\bar{x2}}}} 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{x1}-\bar{x2}}= \sqrt{\frac{s_1^2}{n_1}+\frac{s_2^2}{n_2}} *Here <math> 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.n1 and n2 are the number of data points in two arrays . sx1(bar)-x2(bar) is not a pooled variance.
- This function will give the result as error when
1. any one of th argument is non-numeric.
2.alpha>1
Examples
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | 12 | 21 | 9 | 18 | 27 | 37 | 41 |
| 2 | 19 | 8 | 45 | 29 | 14 | 10 | 11 |
- =TTESTSAMPLESEQUALVARIANCES(A1:F1,A2:F2,0.5)
See Also