F.DIST
Definition/Description of Formula:
Calculates the lefttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snecdor's F distribution.
Syntax:
F.DIST(x, deg_num, deg_den, cumulative)
x
 The input to the F probability distribution function. The value at which to evaluate the function. Must be a positive number.deg_num
 The numerator degrees of freedom.deg_den
 The denominator degrees of freedom.cumulative
 Logical value that determines the form of the function. If
TRUE
:F.DIST
returns the cumulative distribution function.  If
FALSE
:F.DIST
returns the probability density function.
 If
Remarks:
 Both
deg_num
anddeg_den
are truncated to an integer in the calculation if a noninteger is provided as an argument.  Both
deg_num
anddeg_den
must be greater than1
and may not exceed10^10
. x
,deg_num
, anddeg_den
must be numeric.
See Also:
: Calculates the righttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snedecor's F distribution.FDIST
: Calculates the righttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snedecor's F distribution.F.DIST.RT
: Calculates the negative inverse of the onetailed TDIST function.T.INV
In order to use the F.DIST formula, start with your edited Excellentable:
Then type in the F.DIST Formula in area you would like to display the outcome:
A

B

C



1

Degrees Freedom Denominator


2

D



1


2
