Documentation/Calc Functions/TINV

    From The Document Foundation Wiki

    Function name:

    TINV

    Category:

    Statistical Analysis

    Summary:

    Calculates the inverse of a two-tailed probability value for the t-distribution. The t-distribution is often known as the Student's t-distribution.

    T-distributions are a family of continuous probability distributions and each has a curve with the same general bell shape that is symmetric about 0. Each t-distribution is characterized by a parameter known as the number of degrees of freedom, often denoted by the lowercase Greek letter nu ([math]\displaystyle{ \nu }[/math]). The t-distribution approaches the normal distribution as the number of degrees of freedom increases. T-distributions are often used to model small sample sizes.

    Using the nomenclature of the previous paragraph, TINV calculates the real number x such that [math]\displaystyle{ \text{T.DIST.2T}(x;\:\nu)~=~\text{TDIST}(x;\:\nu; 2)~=~p }[/math], where the given probability p lies in the range (0, 1].

    Syntax:

    TINV(Number; Degrees freedom)

    Returns:

    Returns a positive real number, which is the value of the random variable that would give the specified two-tailed probability for the given t-distribution.

    Arguments:

    Number is a real number in the range (0, 1], or a reference to a cell containing that number, which is a two-tailed probability of the t-distribution.

    Degrees freedom is a positive integer, or a reference to a cell containing that number, which is the number of degrees of freedom of the t-distribution. This is typically assumed to be the number of samples minus 1.

    • If either of Number or Degrees freedom is non-numeric, then TINV reports a #VALUE! error.
    • If Number is less than or equal to 0, or greater than 1, then TINV reports an invalid argument error (Err:502).
    • If Degrees freedom is less than 1, then TINV reports an invalid argument error (Err:502).
    • If Degrees freedom is a non-integer value, then TINV truncates it to an integer value.

    Additional details:

    • Calc's T.INV.2T and TINV functions perform identical calculations. The requirements for TINV are specified in ODF 1.2; T.INV.2T is provided for interoperability with Microsoft Excel.
    • For more information on the t-distribution, visit Wikipedia's Student's t-distribution page.

    Examples:

    Formula Description Returns
    =TINV(A1; A2) where cells A1 and A2 contain the values 0.666666666666667 and 2 respectively. Here the function calculates the inverse of the given two-tailed probability value for the specified t-distribution. Note that the formulas =T.DIST.2T(0.5; 2) and =TDIST(0.5; 2; 2) both return 0.666666666666667. 0.5
    =TINV(0.001; 8) Here the function calculates the inverse of a small two-tailed probability value for the specified t-distribution. 5.04130543337337
    =TINV(1; 8) Here the function calculates the inverse of the largest possible two-tailed probability value for the specified t-distribution. 0

    Related LibreOffice functions:

    T.DIST

    T.DIST.2T

    T.DIST.RT

    T.INV

    T.INV.2T

    TDIST

    ODF standard:

    Section 6.18.78, part 2

    Related (or similar) Excel functions:

    TINV