Class TDist

  • All Implemented Interfaces:
    FreeRefFunction, Function, Function3Arg

    public final class TDist
    extends Fixed3ArgFunction
    implements FreeRefFunction
    Implementation for Excel TDIST() function.

    Syntax:
    TDIST (X,Deg_freedom,Tails)

    Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.

    • X Required. The numeric value at which to evaluate the distribution.
    • Deg_freedom Required. An integer indicating the number of degrees of freedom.
    • Tails Required. Specifies the number of distribution tails to return. If Tails = 1, TDIST returns the one-tailed distribution. If Tails = 2, TDIST returns the two-tailed distribution.
    • If any argument is non-numeric, TDIST returns the #VALUE! error value.
    • If Deg_freedom < 1, TDIST returns the #NUM! error value.
    • The Deg_freedom and Tails arguments are truncated to integers.
    • If Tails is any value other than 1 or 2, TDIST returns the #NUM! error value.
    • If x < 0, then TDIST returns the #NUM! error value.
    https://support.microsoft.com/en-us/office/tdist-function-630a7695-4021-4853-9468-4a1f9dcdd192
    • Field Detail

      • instance

        public static final TDist instance
    • Constructor Detail

      • TDist

        public TDist()