Changes

 

<div style="font-size:30px">'''TTESTTWOSAMPLESEQUALVARIANCES(ar1,ar2,md,alpha,lv)'''</div><br/>

<div style="font-size:30px">'''TTESTTWOSAMPLESEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>

*<math>ar1 </math> and <math> ar2 </math>  are set of values.

*<math>Array1 </math> and <math> Array2 </math>  are set of values.

*<math>md </math> is the  Hypothesized Mean Difference.

*<math>HypothesizedMeanDifference </math> is the  Hypothesized Mean Difference.

*<math> alpha </math> is the significance level.

*<math> Alpha </math> is the significance level.

*<math> lv </math> is the logical value.

*<math> NewTableFlag </math> is either 0 or 1.

==Description==

==Description==

*1.The two sample sizes  are equal;

*1.The two sample sizes  are equal;

*2.It can be assumed that the two distributions have the same variance.

*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 .

*In <math>TTESTTWOSAMPLESEQUALVARIANCES (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 md=0 which  indicates that sample means are hypothesized to be equal.

*Suppose HypothesizedMeanDifference=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> Alpha </math> is the significance level which ranges from 0 to 1.

*<math> lv </math> is the logical value like TRUE or FALSE.

*<math> NewTableFlag </math> is either 0 or 1.

*TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.

*"1" is indicating the result will display in new worksheet.Suppose we are omitted the NewTableFlag value it will consider the value as "0".

*The t statistic of this function calculated by:

*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>

  <math>t = \frac{\bar{x_1}-\bar{x_2}}{s_{x1}.s_{x2}.\sqrt{\frac{2}{n}}}</math>

*This function will give the result as error when  

*This function will give the result as error when  

   1.any one of the argument is non-numeric.

   1.any one of the argument is non-numeric.

   2.alpha>1

   2.Alpha>1

   3.<math>ar1 </math> and <math> ar2 </math> are having different number of data points.

   3.<math>Array1 </math> and <math> Array2 </math> are having different number of data points.