F.DIST

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.

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.

Remarks:

• Both deg_num and deg_den are truncated to an integer in the calculation if a non-integer is provided as an argument.
• Both deg_num and deg_den must be greater than 1 and may not exceed 10^10.
• x, deg_num, and deg_den must be numeric.

See Also:

 FDIST: 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.

F.DIST.RT: 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.

 T.INV: Calculates the negative inverse of the one-tailed TDIST function.

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: