FDIST Function Explained
The FDIST Function in Microsoft Excel calculates the F-Distribution probability density function or cumulative distribution function for a given set of parameters. It takes three arguments: x, deg_freedom1, and deg_freedom2. x is the value at which to evaluate the function, deg_freedom1 is the numerator degrees of freedom, and deg_freedom2 is the denominator degrees of freedom. The function returns the probability that a random variable with the specified degrees of freedom will be less than or equal to x.
FDIST Function Syntax
FDIST(x,deg_freedom1,deg_freedom2)
- x: The value for which you want to calculate the probability.
- deg_freedom1: The numerator degrees of freedom, a number between 1 and 10^10, excluding non-integer values.
- deg_freedom2: The denominator degrees of freedom, a number between 1 and 10^10, excluding non-integer values.