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

    This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom.

    Syntax

    T.INV.2T(prog,deg)

    Arguments

    This function has these arguments:

    Argument Description
    prog Probability of the two-tailed student’s t-distribution
    deg Number of degrees of freedom to characterize the distribution; if not an integer, the number is truncated

    Remarks

    The #VALUE! error value is returned if any argument is nonnumeric.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    T.INV.2T(A4,2)

    T.INV.2T(0.68,4) gives the result 0.44400612800394834

    Version Available

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

    See Also

    TINV