Browse

F.DIST Function in LibreOffice Calc — Tested Examples

Statistical Intermediate LibreOffice Calc

An explanation of LibreOffice Calc F.DIST, including tested formulas, examples, expected results and common mistakes.

Verification status: Selected examples were executed in LibreOffice Calc 25.2.3.2. This does not establish that every formula and edge case was tested. How formula examples are checked

Values of the left tail F probability distribution. The F distribution with numerator and denominator degrees of freedom both equal to four has cumulative probability 0.5 at x=1.

Syntax and arguments

=F.DIST(Number; Degrees_freedom_1; Degrees_freedom_2; Cumulative)

LibreOffice Calc formulas generally separate arguments with semicolons (;).

Argument Explanation
Number The value for which the F distribution is to be calculated.
Degrees freedom 1 The degrees of freedom in the numerator of the F distribution.
Degrees freedom 2 The degrees of freedom in the denominator of the F distribution.
Cumulative Cumulative distribution function (TRUE) or probability density function (FALSE). (optional)

Worked examples

Example 1: Compute the cumulative F-distribution at 1 with symmetric degrees of freedom

=F.DIST(1;4;4;TRUE())

Expected result: 0.5. This value was returned in the LibreOffice Calc 25.2 test.

Example 2: Cumulative F distribution at zero

=F.DIST(0;4;4;TRUE())

Expected result: 0. This value was returned in the LibreOffice Calc 25.2 test.

How to interpret the result

The F distribution with numerator and denominator degrees of freedom both equal to four has cumulative probability 0.5 at x=1.

Mistakes and troubleshooting

  • Check inputs and assumptions: TRUE requests the cumulative probability; FALSE requests probability density. The degrees of freedom must be positive.
  • Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
  • Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.

COUNT · AVERAGE · SUM

Tested version and primary reference

2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.