Difference between revisions of "Manuals/calci/TTESTTWOSAMPLESEQUALVARIANCES"
Jump to navigation
Jump to search
(Created page with "ttest") |
|||
| Line 1: | Line 1: | ||
| − | + | TTESTTWOSAMPLESEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag) | |
| + | <div style="font-size:30px">'''TTESTTWOSAMPLESEQUALVARIANCES(ar1,ar2,md,alpha,lv)'''</div><br/> | ||
| + | *<math>ar1 </math> and <math> ar2 </math> are set of values. | ||
| + | *<math>md </math> is the Hypothesized Mean Difference. | ||
| + | *<math> alpha </math> is the significance level. | ||
| + | *<math> lv </math> is the logical value. | ||
| + | |||
| + | ==Description== | ||
| + | *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 <math>TTESTTWOSAMPLESEQUALVARIANCES(ar1,ar2,md,alpha,lv)</math>, <math>ar1 </math> and <math> ar2 </math> are two arrays of sample values. <math> md </math> is the Hypothesized Mean Difference . | ||
| + | *Suppose md=0 which indicates that sample means are hypothesized to be equal. | ||
| + | *<math> alpha </math> is the significance level which ranges from 0 to 1. | ||
| + | *<math> lv </math> 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: | ||
| + | <math>t = \frac{\bar{x_1}-\bar{x_2}}{s_{x1}.s_{x2}.\sqrt{\frac{2}{n}}}</math> | ||
| + | where <math>s_{x1}.s_{x2} = \sqrt{\frac{1}{2}(s_{x1}^2+s_{x2}^2)}</math> | ||
| + | *Here <math>s_{x1}</math> and <math>s_{x2}</math> are unbiased estimators of the variances of two samples.<math>s_{x1}.s_{x2}</math> 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. | ||
| + | 2.alpha>1 | ||
| + | 3.<math>ar1 </math> and <math> ar2 </math> are having different number of data points. | ||
Revision as of 15:25, 20 December 2016
TTESTTWOSAMPLESEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)
TTESTTWOSAMPLESEQUALVARIANCES(ar1,ar2,md,alpha,lv)
- and are set of values.
- is the Hypothesized Mean Difference.
- is the significance level.
- is the logical value.
and 
are set of values.
is the Hypothesized Mean Difference.
is the significance level.
is the logical value.Description
- 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 md=0 which indicates that sample means are hypothesized to be equal.
- is the significance level which ranges from 0 to 1.
- 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:
, 
where
- 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
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.1.any one of the argument is non-numeric. 2.alpha>1 3. and are having different number of data points.