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
| Argument | Type | Required | Default |
|---|---|---|---|
probability | number | Required | — |
deg_freedom1 | number | Required | — |
deg_freedom2 | number | Required | — |
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!whenprobabilityis outside[0, 1]or either degrees of freedom is< 1or>= 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?.