# FDIST

The FDIST function in Excel is used to calculate the two-tailed F probability density function. It is commonly employed in statistical analysis to determine the probability of a specific F-statistic occurring in a F-test.

## Syntax

=FDIST(`x`

, `deg_freedom1`

, `deg_freedom2`

)

`x` | The value at which to evaluate the function. |

`deg_freedom1` | The number of degrees of freedom in the numerator. |

`deg_freedom2` | The number of degrees of freedom in the denominator. |

## About FDIST

When diving into statistical analyses and entering the domain of F-tests, the FDIST function emerges as a vital component within Excel's arsenal. It efficiently computes the probability density function for specific F-statistics, offering valuable insights into the probability distribution of F-values obtained from an F-test. This function aids researchers, analysts, and students in making informed decisions based on statistical significance and hypothesis testing outcomes. By utilizing the FDIST function, one can gain a deeper understanding of the likelihood of observing a particular F-statistic in a given context, thereby enhancing the analytical processes and conclusions drawn from statistical experiments.

## Examples

Suppose you are conducting an F-test with 3 and 6 degrees of freedom for the numerator and denominator, respectively, and you want to find the probability of observing an F-statistic of 4. The FDIST formula would be: =FDIST(4,3,6)

In another scenario, if you have 5 and 10 degrees of freedom for the numerator and denominator and you wish to determine the probability of obtaining an F-statistic of 3, the formula would be: =FDIST(3,5,10)

## Questions

**What does the FDIST function calculate in Excel?**

The FDIST function computes the probability density function for a specific F-statistic in an F-test, providing insights into the likelihood of observing that particular value in a given statistical experiment.

**How should I interpret the result obtained from the FDIST function?**

The output of the FDIST function represents the probability of obtaining an F-statistic equal to or less extreme than the specified value in a two-tailed test. It aids in assessing the significance of the calculated F-value within the context of hypothesis testing.

**Can the FDIST function handle non-integer values for degrees of freedom?**

No, the FDIST function requires that the degrees of freedom parameters be specified as non-negative integers. Ensure to input whole numbers for the degrees of freedom in both the numerator and denominator when using the FDIST function.

## Related functions

F.DIST RTD TDIST WEIBULL.DIST Z.DIST BINOM.DIST FDIST