Spread Formula Reference
Formula Functions / Functions T to Z / T.TEST
In This Topic
    T.TEST
    In This Topic

    This function returns the probability associated with a t-test.

    Syntax

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

    Arguments

    This function has these arguments:

    Argument Description
    array1 Array of values in first data set
    array2 Array of values in second data set
    tails Number of tails
    type Type of t-test to perform (1, 2, or 3)

    Remarks

    The tails and type arguments are truncated to integers. The #VALUE! error value is returned if tails or type is nonnumeric.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    T.TEST(A1:A17,B1:B17,4,3)

    T.TEST({2,2,2,3,4},{2,3,3,4,5},1,2) gives the result 0.1260360000000153

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    TTEST