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.
F.DIST(15.35, 7, 6, TRUE)
F.DIST(A2, B2, C2, FALSE)
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
F.DISTreturns the cumulative distribution function.
F.DISTreturns the probability density function.
degrees_freedom2are truncated to an integer in the calculation if a non-integer is provided as an argument.
degrees_freedom2must be greater than
1and may not exceed
degrees_freedom2must be numeric.
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.