Documentation/Calc Functions/F.DIST

From The Document Foundation Wiki
Jump to: navigation, search

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:

  • The formula for F.DIST is:

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

Fdist2.png

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

Fdist1.png

is not defined.

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

Fdist.png

otherwise.

  • For more details on F distribution, visit Wikipedia

Examples:

Formula Description Returns
=F.DIST(0.8;8;12;0) This formula calculates the probability density function for the F distribution with Number as 0.8, degree of numerator as 8, degree of denominator as 12. 0.7095282499
=F.DIST(0.8;8;12;1) This formula calculates the cumulative distribution function for the F distribution with Number as 0.8, degree of numerator as 8, degree of denominator as 12. 0.3856603563
=F.DIST(0.8;8;12) This formula calculates the cumulative distribution function (by default) for the F distribution with Number as 0.8, degree of numerator as 8, degree of denominator as 12. 0.3856603563

Related LibreOffice functions:

F.DIST.RT

F.INV

F.TEST

FDIST

FINV

FTEST

ODF standard:

Section 6.18.22, part 2

Equivalent Excel functions:

F.DIST