Skip to main content

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 TRUEF.DIST returns the cumulative distribution function.
    • If FALSEF.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.
  • xdeg_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:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.