FDIST

Definition

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.

Sample Usage

FDIST(15.35, 7, 6)

FDIST(A2, B2, C2)

Syntax

FDIST(x, degrees_freedom1, degrees_freedom2)

• 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 of the number of degrees of freedom.

• degrees_freedom2 - The denominator of the number of degrees of freedom.

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.

• All arguments must be numeric.

• FDIST is synonymous with F.DIST.RT.

See Also

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.

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 Snecdor's F distribution.

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

In order to use the FDIST formula, start with your edited Excellentable:

Then type in the FDIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the FDIST formula for, Excellentable will generate the outcome: