# Documentation/Calc Functions/F.DIST

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

F.DIST