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 |
* 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. * 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 |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top