T.TEST

T.TEST(array1, array2, tails, type)

Returns the probability value from a t distribution.

array1	The first array,
array2	The second array.
tails	The number of distribution tails: 1 = one-tailed distribution 2 = two-tailed distribution
type	The kind of t-Test to perform: 1 = paired 2 = two sample equal variance (homoscedastic) 3 = two sample unequal variance (heteroscedastic)

REMARKS

* For an illustrated example refer to the page under Distributions
* The t distribution is a continuous distribution
* The random variable returned by this function if often referred to as a critical value.
* You can use the T.DIST function to return the probability distribution function for a t distribution (left tailed).
* You can use the T.DIST.2T function to return the probability distribution function for a two tailed distribution (no cumulative).
* You can use the T.DIST.RT function to return the probability distribution function for a two tailed distribution (no cumulative).
* You can use the T.INV function to return the inverse of the probability distribution function for a t distribution (left tailed)
* You can use the T.INV.2T function to return the inverse of the probability distribution function for a two tailed distribution.
* This is similar to the CHISQ.TEST, F.TEST and Z.TEST functions.
* This function was added in Excel 2010 to replace the TTEST function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	??