FDIST
Definition
Calculates the righttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor 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
anddegrees_freedom2
are truncated to an integer in the calculation if a noninteger is provided as an argument.Both
degrees_freedom1
anddegrees_freedom2
must be greater than1
and may not exceed10^10
.All arguments must be numeric.
FDIST
is synonymous withF.DIST.RT
.
See Also
F.DIST.RT
: Calculates the righttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snedecor's F distribution.
F.DIST
: Calculates the lefttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snecdor's F distribution.
TDIST
: Calculates the probability for Student's tdistribution 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:
A

B

C



1


2


3


4


5
