writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + Line 9:
Line 9: − +
no edit summary
*<math> Tails </math> is the number of distribution tails.
*<math> Tails </math> is the number of distribution tails.
*<math> Type </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==
==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(Array1,Array2,Tails,Type), Array1 and Array2 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 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.
*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.