writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − ttest+ + + + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/TTESTTWOSAMPLESEQUALVARIANCES (view source)
Revision as of 21:25, 20 December 2016
, 21:25, 20 December 2016no edit summary
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.