Changes

<div style="font-size:30px">'''TTEST(ar1,ar2,ta,ty)'''</div><br/>

<div style="font-size:30px">'''TTEST(Array1,Array2,Tails,Type)'''</div><br/>

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

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

*<math> ta </math> is the number of distribution tails.

*<math> Tails </math> is the number of distribution tails.

*<math> ty </math> is the type of t-test.

*<math> Type </math> is the type of t-test.

 

==Description==

==Description==

*It is also called student's t-test.  

*It is also called student's t-test.  

*This function is used to find the probability of two samples having the same mean but equal or unequal variances.  

*This function is used to find the probability of two samples having the same mean but equal or unequal variances.  

*In TTEST(ar1,ar2,ta,ty), ar1 and ar2 are two set of array values.  

*In <math>TTEST(Array1,Array2,Tails,Type)</math>, <math>Array1</math> and <math>Array2</math> are two set of array values.  

*ta is indicating the number of distribution tails. ta value is either 1 or 2.  

*ta is indicating the number of distribution tails. ta value is either 1 or 2.  

*If ta=1,then TTEST uses the one-tailed distrbution.If ta=2, then TTEST uses the two-tailed distrbution.ty is the type of t-Test. ty value is 1 or 2 or 3.  

*If Tails=1,then TTEST uses the one-tailed distribution.If Tails=2, then TTEST uses the two-tailed distribution. Type is the type of t-Test. Type value is 1 or 2 or 3.  

{| class="wikitable"

{| class="wikitable"

|-

|-

|ty value  ||          t-Test is performed

|Type value  ||          t-Test is performed

|-

|-

|1      ||                Paired

|1      ||                Paired

|}

|}

*Suppose we are giving ta and ty in decimals , then it will converted in to integers.  

*Suppose we are giving ta and ty in decimals , then it will converted in to integers.  

*TTEST uses the value of ar1 and ar2 to find non-negative t-statistic.  

*TTEST uses the value of Array1 and Array2 to find non-negative t-statistic.  

*If ta=1, then it gives the probability of a higher value of the t-statistic with consideration of two arrays of samples with the same mean.  

*If Tails=1, then it gives the probability of a higher value of the t-statistic with consideration of two arrays of samples with the same mean.  

*If ta=2, then TTEST is gives double that when ta=1 and corresponds to the probability of a higher absolute value of the t-statistic with the consideration of same mean.  

*If Tails=2, then TTEST is gives double that when ta=1 and corresponds to the probability of a higher absolute value of the t-statistic with the consideration of same mean.  

This function will give the result as error when  

This function will give the result as error when  

       1. ar1 and ar2 have a different number of data points and ty=1.

       1. Array1 and Array2 have a different number of data points and Type=1.

       2. Any one of the argument is nonnumeric.

       2. Any one of the argument is nonnumeric.

       3. ta>2 and ty>3.

       3. Tails>2 and Type>3.

==Examples==

==Examples==