Documentation/Calc Functions/F.INV.RT

    From The Document Foundation Wiki

    Function name:

    F.INV.RT

    Category:

    Statistical Analysis

    Summary:

    Calculates the inverse of a right-tail probability value for the F-distribution with given degrees of freedom.

    F-distributions (named in recognition of Sir Ronald Fisher) are a family of continuous probability distributions on the interval [0, +∞) that often arise in the statistical analysis of variance. The F-distribution has two characteristic parameters, known as the degrees of freedom for the numerator and the degrees of freedom for the denominator and these determine the shape of the distribution.

    F.INV.RT is the inverse of F.DIST.RT, so that for valid arguments [math]\displaystyle{ \text{F.INV.RT}(\text{F.DIST.RT}(x;\:ν1;\:ν2);\:ν1;\:ν2)~=~x }[/math].

    Syntax:

    F.INV.RT(Number; Degrees freedom 1; Degrees freedom 2)

    Returns:

    Returns a non-negative real number, which is the inverse of the specified right-tail probability value for the given F-distribution.

    Arguments:

    Number is a real number in the range (0, 1], or a reference to a cell containing that number, which is the right-tail probability for which the inverse is required.

    Degrees freedom 1 is a positive integer, or a reference to a cell containing that number, which is the degrees of freedom for the numerator of the F-distribution.

    Degrees freedom 2 is a positive integer, or a reference to a cell containing that number, which is the degrees of freedom for the denominator of the F-distribution.

    • If any of Number, Degrees freedom 1, or Degrees freedom 2 is non-numeric, then F.INV.RT reports a #VALUE! error.
    • If Number is less than or equal to 0.0, or greater than 1.0, then F.INV.RT reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is less than 1.0, then F.INV.RT reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is greater than or equal to [math]\displaystyle{ 1.0 \times 10^{10} }[/math], then F.INV.RT reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is a non-integer value, then F.INV.RT truncates it to an integer value.
    • If the function’s iterative algorithm does not converge for the given arguments, then F.INV.RT reports a calculation does not converge error (Err:523).

    Additional details:

    • Calc's FINV and F.INV.RT functions perform identical calculations. The requirements for FINV are specified in ODF 1.2; F.INV.RT is provided for interoperability with Microsoft Excel.
    • F.INV.RT utilizes an iterative algorithm to determine the inverse of the specified right-tail probability.
    • The following figure shows inverse right-tail probability plots for five sample F-distributions.
    F distribution inverse RT probability plots.png
    • The name space for F.INV.RT is COM.MICROSOFT.F.INV.RT.
    • For more information about F-distributions, visit Wikipedia's F-distribution page.

    Examples:

    Formula Description Returns
    =F.INV.RT(A1; A2; A3) where cells A1:A3 contain the values 0.614339643745812, 8 and 12 respectively. Here the function calculates the inverse of a right-tail probability value for the specified F-distribution. Note that the formula =F.INV.RT(0.614339643745812; 8.9; 12.95) returns the same result because the non-integer degrees of freedom values are truncated. 0.8
    =F.INV.RT(0.0354938271604938; 6; 6) Here the function calculates the inverse of a right-tail probability value for the specified F-distribution. Note that the formula =FINV(0.0354938271604938; 6; 6) returns the same result. 5

    Related LibreOffice functions:

    F.DIST

    F.DIST.RT

    F.INV

    F.TEST

    FDIST

    FINV

    FTEST

    ODF standard:

    Section 6.18.25, part 2

    Related (or similar) Excel functions:

    F.INV.RT