F.DISTCalculates 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 FALSE.
If TRUE: F.DIST returns the cumulative distribution function.
If FALSE: F.DIST returns the probability density function.
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.
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.