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

Returns the probability value from a t distribution.

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

* This function was added in Excel 2010 to replace the TTEST function.
* 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
* You can use the T.DIST.2T function to
* You can use the T.DIST.RT function to
* You can use the T.INV function to
* You can use the T.INV.2T function to
* This is similar to the CHISQ.TEST, F.TEST and Z.TEST functions.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top