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.


=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.


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.


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)


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