Definition/Description of Formula:
Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snecdor's F distribution.
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.
F.DISTreturns the cumulative distribution function.
F.DISTreturns the probability density function.
deg_denare truncated to an integer in the calculation if a non-integer is provided as an argument.
deg_denmust be greater than
1and may not exceed
deg_denmust be numeric.
: Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
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: