Documentation/Calc Functions/FDIST

Function name:
FDIST

Category:
Statistical Analysis

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

Syntax:
FDIST(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:
If x<0, the function returns an error and it returns the value
 * The formula for FDIST is:

otherwise.


 * For more details on F distribution, visit Wikipedia

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/F.DIST.RT F.DIST.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/F.INV.RT F.INV.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/F.INV F.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/F.TEST F.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/F.DIST F.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/FINV FINV]

[[Special:MyLanguage/Documentation/Calc_Functions/FTEST FTEST]

ODF standard:
Section 6.18.23, part 2

Equivalent Excel functions:
FDIST