Documentation/Calc Functions/F.DIST.RT

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

F.DIST.RT

Category:

Statistical Analysis

Summary:

Calculates the area of the right tail of the probability density function for the F-distribution.

Syntax:

F.DIST.RT(Number; degreesFreedom1; degreesFreedom2)

Returns:

Returns a non-negative real number which is the area of the right tail of the probability density function for the F-distribution.

Arguments:

Number is a real number or a reference to the cell containing that number which is the value for which the F distribution is to be calculated.

degreesFreedom1 is a real number or a reference to the cell containing that number which is the degrees of freedom in the numerator in the F distribution.

degreesFreedom2 is a real number or a reference to the cell containing that number which is the degrees of freedom in the denominator in the F distribution.

  • If Number is negative or degreeFreedom1/degreeFreedom2 is less than 1, then the function returns an error value.
  • If degreeFreedom1 or degreeFreedom2 is a non-integer value then the function uses its floor value, i.e. truncates it to an integer.

Additional details:

  • The formula for F.DIST.RT is:

If x<0, the function returns an error and it returns the value

Lfdist.png

otherwise.

  • For more details on F distribution, visit Wikipedia

Examples:

Formula Description Returns
=F.DIST.RT(0.8;8;12) This formula calculates the area of the right tail of the probability density function for the F-distribution with Number as 0.8, degree of numerator as 8, degree of denominator as 12. 0.6143396437

Related LibreOffice functions:

F.DIST

F.INV

F.TEST

FDIST

FINV

F.INV.RT

FTEST

ODF standard:

Section 6.18.23, part 2

Equivalent Excel functions:

F.DIST.RT