Documentation/Calc Functions/F.DIST

Function name:
F.DIST

Category:
Statistical Analysis

Summary:
Calculates the values of the left tail of the F distribution.

Syntax:
F.DIST(Number; DegreesFreedom1; DegreesFreedom2[; Cumulative])

Returns:
Returns a non-negative real number which is the value of the probability density function or the cumulative distribution 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.

Cumulative is a logical value that determines the form of the function. C = 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function. If this parameter is omitted then the function uses True as the default value.


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

Additional details:
If Cumulative is FALSE, FDIST returns Err:502 if x < 0, an Error if the numerator degrees of freedom r1 = 1 and x = 0, and the probability density function value
 * The formula for F.DIST is:

otherwise If the numerator degrees of freedom r1 = 1, then the density function has a pole at x=0, the subterm

is not defined.

If Cumulative is TRUE, FDIST returns Err:502 if x < 0 and the cumulative distribution function value

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 F.INV]

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

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

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

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

ODF standard:
Section 6.18.22, part 2

Equivalent Excel functions:
F.DIST