Owner manual

Examples

=EXPONDIST(4, 2, 1) returns 0.999664537372097 (cumulative distribution form).

=EXPONDIST(4, 2, 0) returns 0.000670925255805024 (probability density form).

Related Topics

For related functions and additional information, see:

“LOGNORMDIST” on page 269

“Listing of Statistical Functions” on page 225

“Value Types” on page 36

“The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

FDIST

The FDIST function returns the F probability distribution.

FDIST(non-neg-x-value, d-f-numerator, d-f-denominator)

Â non-neg-x-value: The value at which you want to evaluate the function. non-neg-x-

value is a number value that must be greater than or equal to 0.

Â d-f-numerator: The degrees of freedom to include as the numerator. d-f-numerator

is a number value and must be greater than or equal to 1. If there is a decimal

portion, it is ignored.

Â d-f-denominator: The degrees of freedom to include as the denominator. d-f-

denominator is a number value and must be greater than or equal to 1. If there is a

decimal portion, it is ignored.

Usage Notes

The F distribution is also known as Snedecor’s F distribution or the Fisher-Snedecor Â

distribution.

Examples

=FDIST(0.77, 1, 2) returns 0.472763488223567.

=FDIST(0.77, 1, 1) returns 0.541479597634413.

=FDIST(0.77, 2, 1) returns 0.627455805138159.