F.DIST function

The F.DIST function in Excel calculates the F-distribution for a given value of the random variable, based on the degrees of freedom for both the numerator and the denominator. The F-distribution is commonly used in statistical tests, such as ANOVA (Analysis of Variance), to compare variances between two datasets.

Syntax:

F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

Arguments:

• x: The value at which you want to evaluate the function. It must be greater than or equal to 0.
• deg_freedom1: The degrees of freedom for the numerator (for example, the degrees of freedom of the first sample).
• deg_freedom2: The degrees of freedom for the denominator (for example, the degrees of freedom of the second sample).
• cumulative: A logical value that determines the type of function to return:
  • TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a value from the F-distribution is less than or equal to x.
  • FALSE: Returns the probability density function (PDF), which gives the likelihood that the value is exactly equal to x.

Formula:

• For the cumulative distribution function (CDF):

  $$F(x) = \int_0^x \frac{(deg\_freedom1^{deg\_freedom1} * deg\_freedom2^{deg\_freedom2})}{B(deg\_freedom1 / 2, deg\_freedom2 / 2)} * (1 + \frac{deg\_freedom1}{deg\_freedom2} * t)^(\frac{deg\_freedom1}{2} – 1)$$Where $B$ is the Beta function.

• For the probability density function (PDF):

  $$f(x) = \frac{(deg\_freedom1^{deg\_freedom1} * deg\_freedom2^{deg\_freedom2})}{B(deg\_freedom1 / 2, deg\_freedom2 / 2)} * \left(1 + \frac{deg\_freedom1}{deg\_freedom2} * t\right)^{\frac{deg\_freedom1}{2} – 1}$$

Example 1: Cumulative Distribution Function (CDF)

If you want to calculate the cumulative probability for an F-distribution with:

• $x = 2.5$
• $\text{deg\_freedom1} = 5$
• $\text{deg\_freedom2} = 10$

You would use the formula:

=F.DIST(2.5, 5, 10, TRUE)

This returns the probability that the value from the F-distribution is less than or equal to 2.5.

Example 2: Probability Density Function (PDF)

If you want to calculate the probability density at $x = 2.5$ for the same degrees of freedom:

=F.DIST(2.5, 5, 10, FALSE)

This will return the likelihood that the random variable follows the exact value of 2.5 under the F-distribution.

Key Points:

• The F-distribution is typically used in hypothesis testing to compare variances or to test the equality of variances across two groups.
• CDF (TRUE): Computes the cumulative probability that a value from the F-distribution is less than or equal to x.
• PDF (FALSE): Computes the likelihood (density) of a particular value from the F-distribution.

Use Cases:

• ANOVA (Analysis of Variance): To compare variances from two or more groups.
• Regression analysis: To test the significance of models or individual predictors in a dataset.
• Testing hypotheses: Particularly in comparing the variability between two datasets or groups in scientific and industrial research.