ExcelFlux

FDIST function

the F probability distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find an upper-tail probability using the legacy F distribution.

A worked example from the workbook

RowA
6Input
70.5
81
93
Record 1
=FDIST(A7,4,8)

Illustrative output0.73728

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find an upper-tail probability using the legacy F distribution.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.5
8 1
9 3
Trial Expression Sample output
Record 1 =FDIST(A7,4,8) 0.73728
Record 2 =FDIST(A8,4,8) 0.4609053498
Record 3 =FDIST(A9,4,8) 0.08704
Microsoft Excel reference