F.DIST Function Explained
The F.DIST Function in Microsoft Excel calculates the F probability distribution for a given set of parameters. It returns the probability that a member of a population with a given degree of freedom will have a value less than or equal to a given value. The function takes three arguments: x, deg_freedom1, and deg_freedom2. x is the value for which you want to calculate the probability, deg_freedom1 is the numerator degrees of freedom, and deg_freedom2 is the denominator degrees of freedom.
F.DIST Function Syntax
F.DIST(x,deg_freedom1,deg_freedom2,cumulative)
x: The value at which you want to evaluate the distribution.deg_freedom1: The numerator degrees of freedom.deg_freedom2: The denominator degrees of freedom.cumulative: A logical value that determines the form of the function. If cumulative is TRUE, F.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.