Formualizer Docs

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

ArgumentTypeRequiredDefault
xnumberRequired—
deg_freedom1numberRequired—
deg_freedom2numberRequired—

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! when x < 0 or either degrees of freedom is < 1 or >= 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?.

Implementation

Engine source

On this page