Manuals/calci/TTEST

TTEST(Array1,Array2,Tails,Type)

$Array1$ and $Array2$ are the array of values.
$Tails$ is the number of distribution tails.
$Type$ is the type of 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 TTEST(Array1,Array2,Tails,Type), Array1 and Array2 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.