Formualizer Docs
ReferenceFunctionsStatistics Functions

F.DIST

F.DIST: Returns the F-distribution probability for `x` with numerator and denominator degrees of freedom.

Summary

Use F.DIST for left-tail cumulative probabilities or density values in variance-ratio tests.

Remarks

  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Requires x >= 0, deg_freedom1 >= 1, and deg_freedom2 >= 1.
  • Returns #NUM! when any domain constraint is violated.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

F CDF with symmetric 2 and 2 degrees of freedom
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5
F PDF with symmetric 2 and 2 degrees of freedom
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.25

Runtime metadata

Category

Statistics

Signature

F.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

EXPON.DIST

EXPON.DIST: Returns the exponential-distribution probability at `x` for rate `lambda`.

F.INV

F.INV: Returns the F value whose left-tail probability equals `probability`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata