F.DIST

Calculates the left-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.

Sample Usage

F.DIST(15.35, 7, 6, TRUE)

F.DIST(A2, B2, C2, FALSE)

Syntax

F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)

  • x - The input to the F probability distribution function. The value at which to evaluate the function.

    • Must be a positive number.

  • degrees_freedom1 - The numerator degrees of freedom.

  • degrees_freedom2 - The denominator degrees of freedom.

  • cumulative - Logical value that determines the form of the function. Default value is FALSE.

    • If TRUE: F.DIST returns the cumulative distribution function.

    • If FALSE: F.DIST returns the probability density function. 

Notes

  • Both degrees_freedom1 and degrees_freedom2 are truncated to an integer in the calculation if a non-integer is provided as an argument.

  • Both degrees_freedom1 and degrees_freedom2 must be greater than 1 and may not exceed 10^10.

  • x, degrees_freedom1, and degrees_freedom2 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.

TDIST: Calculates the probability for Student's t-distribution with a given input (x).

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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
17524686425592285493
true
Search Help Center
true
true
true