Difference between revisions of "TTESTTWOSAMPLESUNEQUALVARIANCES"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/> *<math>Array1 </math> and <math> Arr...") |
|||
| Line 7: | Line 7: | ||
==Description== | ==Description== | ||
*This function calculating the two Sample for unequal variances determines whether two sample means also distinct. | *This function calculating the two Sample for unequal variances determines whether two sample means also distinct. | ||
| − | *We can use this test when both: | + | * We can use this test when both: |
| − | * | + | * The two sample sizes are may are may not be equal; |
| − | * | + | * The means and variances are distinct . |
*In <math>TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>, <math>Array1</math> and <math> Array2 </math> are two arrays of sample values. | *In <math>TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>, <math>Array1</math> and <math> Array2 </math> are two arrays of sample values. | ||
*<math> HypothesizedMeanDifference </math> is the Hypothesized Mean Difference. Suppose HypothesizedMeanDifference = 0 which indicates that sample means are hypothesized to be equal. | *<math> HypothesizedMeanDifference </math> is the Hypothesized Mean Difference. Suppose HypothesizedMeanDifference = 0 which indicates that sample means are hypothesized to be equal. | ||
| Line 20: | Line 20: | ||
*Here <math> s_1^2</math> and <math> s_2^2</math> are unbiased estimators of the variances of two samples. <math> n_1</math> and <math> n_2</math> are the number of data points in two arrays. <math>s_{\bar{x_1}-\bar{x_2}}</math> is not a pooled variance. | *Here <math> s_1^2</math> and <math> s_2^2</math> are unbiased estimators of the variances of two samples. <math> n_1</math> and <math> n_2</math> are the number of data points in two arrays. <math>s_{\bar{x_1}-\bar{x_2}}</math> is not a pooled variance. | ||
*This function will give the result as error when | *This function will give the result as error when | ||
| − | + | * Any one of the argument is non-numeric. | |
| − | + | * Alpha>1 | |
==Examples== | ==Examples== | ||
Revision as of 05:19, 12 May 2017
TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)
- and are set of values.
- is the Hypothesized Mean Difference.
- is the significance level.
- is either 0 or 1.
and 
are set of values.
is the Hypothesized Mean Difference.
is the significance level.
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:
* The two sample sizes are may are may not be equal; * The means and variances are distinct .
- 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 value it will consider the value as "0".
- The t-statistic of this function calculated by:
, where
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
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. * Any one of the argument is non-numeric.
* 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 |
- =TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5,0)
| Variable 1 | Variable 2 | |
|---|---|---|
| Mean | 23.571428571428573 | 19.428571428571427 |
| Variance | 146.61904761904762 | 177.6190476190476 |
| Observations | 7 | 7 |
| Hypothesized Mean Difference | 3 | |
| Degree Of Freedom | 12 | |
| T- Statistics | 0.1679225216302784 | |
| P(T<=t) One-tail | 0.43472054489717515 | |
| T Critical One-Tail | 0 | |
| P(T<=t) Two-tail | 0.8694410897943503 | |
| T Critical Two-Tail | 0.6954828655202375 |
See Also
References