# Documentation/Calc Functions/F.DIST

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.

• 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

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

## 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

F.DIST.RT

F.INV

F.TEST

FDIST

FINV

FTEST

## ODF standard:

Section 6.18.22, part 2

F.DIST