Difference between revisions of "Manuals/calci/TTEST"

 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<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.
 +
**TTEST() returns the probability associated with a Students t-test.
  
 
+
==Description==
==Descrition==
 
 
*This function gives the probability of the t-test.  
 
*This function gives the probability of the t-test.  
 
*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"
ty value             t-Test is performed
+
|-
1      -                 Paired
+
|Type value   ||          t-Test is performed
2     -                  Two-sample equal variance
+
|-
3     -                  Two-sample unequal variance
+
|1      ||                Paired
 +
|-
 +
|2       ||                Two-sample equal variance
 +
|-
 +
|3       ||                Two-sample unequal variance
 +
|}
 
*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==
Line 43: Line 48:
 
#=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
 
#=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
 
#=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
 
#=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
#=TTEST(A1:G1,A2:G2,1,3) = 0.382340251837
+
#=TTEST(A1:G1,A2:G2,1,3) = 0.37285157760157517
#=TTEST(A1:G1,A2:G2,2,3) = 0.76468050367
+
#=TTEST(A1:G1,A2:G2,2,3) = 0.7457031552031503
 
#=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN
 
#=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|BlS11D2VL_U|280|center|T-TEST}}
  
 
==See Also==
 
==See Also==
Line 51: Line 60:
 
*[[Manuals/calci/TINV  | TINV ]]
 
*[[Manuals/calci/TINV  | TINV ]]
  
 +
==References==
 +
*[http://docs.statwing.com/examples-and-definitions/t-test/ T-test]
  
  
==References==
+
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:45, 18 June 2018

TTEST(Array1,Array2,Tails,Type)


  • and are the array of values.
  • is the number of distribution tails.
  • is the type of t-test.
    • TTEST() returns the probability associated with a Students t-test.

Description

  • This function gives the probability of the 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.
  • In  ,   and   are two set of array values.
  • ta is indicating the number of distribution tails. ta value is either 1 or 2.
  • 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.
Type value t-Test is performed
1 Paired
2 Two-sample equal variance
3 Two-sample unequal variance
  • Suppose we are giving ta and ty in decimals , then it will converted in to integers.
  • TTEST uses the value of Array1 and Array2 to find non-negative t-statistic.
  • 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 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

     1. Array1 and Array2 have a different number of data points and Type=1.
     2. Any one of the argument is nonnumeric.
     3. Tails>2 and Type>3.

Examples

Spreadsheet
A B C D E F G
1 3 5 14 10 8 2 15
2 11 19 5 4 15 7 3
  1. =TTEST(A1:G1,A2:G2,1,1)=0.399108571503
  2. =TTEST(A1:G1,A2:G2,2,1)=0.7982171430076
  3. =TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
  4. =TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
  5. =TTEST(A1:G1,A2:G2,1,3) = 0.37285157760157517
  6. =TTEST(A1:G1,A2:G2,2,3) = 0.7457031552031503
  7. =TTEST(A1:G1,A2:G2,2.2,1.3) = NAN

Related Videos

T-TEST

See Also

References