Difference between revisions of "Manuals/calci/TTEST"

Latest revision as of 15:45, 18 June 2018

TTEST(Array1,Array2,Tails,Type)

$Array1$ and $Array2$ are the array of values.
$Tails$ 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

=TTEST(A1:G1,A2:G2,1,1)=0.399108571503
=TTEST(A1:G1,A2:G2,2,1)=0.7982171430076
=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
=TTEST(A1:G1,A2:G2,1,3) = 0.37285157760157517
=TTEST(A1:G1,A2:G2,2,3) = 0.7457031552031503
=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN

References

T-test

List of Main Z Functions

Z3 home

@@ 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.
 *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 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.
-*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
+|-
-      -                  Paired
+|Type value   ||           t-Test is performed
-     -                  Two-sample equal variance
+|-
-     -                  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.
-*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
-. ar1 and ar2 have a different number of data points and ty=1.
+. Array1 and Array2 have a different number of data points and Type=1.
 . Any one of the argument is nonnumeric.
-. ta>2 and ty>3.
+. Tails>2 and Type>3.
 ==Examples==
@@ Line 43: / Line 48: @@
 #=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
 #=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
+==Related Videos==
+{{#ev:youtube|BlS11D2VL_U|280|center|T-TEST}}
 ==See Also==
@@ Line 51: / Line 60: @@
 *[[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 ]]