FDIST
Returns the right-tailed F probability (legacy name).
FDIST(x, deg_freedom1, deg_freedom2) is P(F > x), the same as F.DIST.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
=FDIST(x, deg_freedom1, deg_freedom2)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
x | number | Required | — |
deg_freedom1 | number | Required | — |
deg_freedom2 | number | Required | — |
How it works
Maps to F.DIST.RT(x, degrees_freedom1, degrees_freedom2) with the same arguments. Finds the probability above x in a ratio of independent sample variances, with nonnegative x and two positive degrees of freedom.
Remarks
- Both degrees of freedom are truncated to integers.
Error cases
- Returns
#NUM!whenx < 0or either degrees of freedom is< 1or>= 10^10.
Examples
Use the legacy name to find the probability above a variance ratio of two.
Formula =FDIST(2,5,10)
Expected result 0.164194950899739
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?.
Swap numerator and denominator degrees of freedom before evaluating the upper tail.
Formula =FDIST(2,10,5)
Expected result 0.229975119349899
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 zero variance ratio leaves the full area in the right tail.
Formula =FDIST(0,5,10)
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 negative F statistic is outside the support.
Formula =FDIST(-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 upper-tail probability above an F statistic of 14.2 with six and four degrees of freedom.
Formula =FDIST(14.2,6,4)
Expected result 0.011356126812524
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?.