Formualizer Docs
ReferenceFunctionsStatistics Functions

F.INV

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

Summary

F.INV inverts F.DIST(x, deg_freedom1, deg_freedom2, TRUE).

Remarks

  • probability must be strictly between 0 and 1.
  • deg_freedom1 and deg_freedom2 must each be at least 1.
  • Returns #NUM! for invalid probability or degree-of-freedom arguments.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Median F quantile with symmetric 2 and 2 degrees of freedom
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Upper-tail F critical value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.3258345304130112

Runtime metadata

Category

Statistics

Signature

F.INV(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

F.DIST

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

F.TEST

F.TEST: Returns the two-tailed p-value from an F-test comparing sample variances.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata