F.DIST function
Summary
Returns the F probability distribution
Syntax
F.DIST(x,deg_freedom1,deg_freedom2,cumulative)
The F.DIST function syntax has the following arguments:
• X Required. The value at which to evaluate the function.
• Deg_freedom1 Required. The numerator degrees of freedom.
• Deg_freedom2 Required. The denominator degrees of freedom.
• Cumulative Required. 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.
• X Required. The value at which to evaluate the function.
• Deg_freedom1 Required. The numerator degrees of freedom.
• Deg_freedom2 Required. The denominator degrees of freedom.
• Cumulative Required. 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.
Example
=F.DIST(A2,A3,A4,TRUE)
=F.DIST(A2,A3,A4,FALSE)
=F.DIST(A2,A3,A4,FALSE)