Formualizer Docs

FINV

Returns the inverse of the right-tailed F probability (legacy name).

FINV(probability, deg_freedom1, deg_freedom2) is the x with FDIST(x, deg_freedom1, deg_freedom2) = probability, the same as F.INV.RT.

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=FINV(probability, deg_freedom1, deg_freedom2)

Arguments

ArgumentTypeRequiredDefault
probabilitynumberRequired—
deg_freedom1numberRequired—
deg_freedom2numberRequired—

How it works

Maps to F.INV.RT with the same arguments. Finds the nonnegative F statistic that leaves a given right-tail probability, using numerator degrees of freedom before denominator degrees of freedom.

Remarks

  • Both degrees of freedom are truncated to integers.

Error cases

  • Returns #NUM! when probability is outside [0, 1] or either degrees of freedom is < 1 or >= 10^10.

Examples

Use the legacy inverse to find the upper F quartile.

Formula =FINV(0.25,5,10)

Expected result 1.58532325938462

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Increase the right-tail probability while holding both degrees of freedom fixed.

Formula =FINV(0.75,5,10)

Expected result 0.529141685567821

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Use one numerator and one denominator degree of freedom at right-tail probability 0.5.

Formula =FINV(0.5,1,1)

Expected result 1

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

A probability above one is outside the function's domain.

Formula =FINV(1.1,5,10)

Expected result #NUM!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Find the F critical value with 1% of the area to its right and six and four degrees of freedom.

Formula =FINV(0.01,6,4)

Expected result 15.2068648611576

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page