Formulas and Functions

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.
Related Topics
For related functions and additional information, see:
254 Chapter 10 Statistical Functions