FDIST

Formulas / FDIST
Determine whether two data sets have different amounts of diversity.
FDIST(x, degrees_freedom1, degrees_freedom2)
  • x - value to evaluate the function on
  • degrees_freedom1 - numerator of degrees of freedom
  • degrees_freedom2 - denominator of degrees of freedom

Examples

  • =FDIST(5, 10, 20)

    The FDIST function can be used to calculate the F probability distribution for a given set of numbers, and will return the F probability distribution for the numbers 5, 10, and 20.

  • =FDIST(A2, B2, C2)

    The FDIST function can also be used to calculate the F probability distribution for a set of cell references in a Sourcetable worksheet, and will return the F probability distribution for the numbers contained in cells A2, B2, and C2 of the worksheet.

  • =FDIST(A2, 10, C2)

    The FDIST function can also be used to calculate the F probability distribution for a combination of cell references and numbers. This function will return the F probability distribution for the numbers contained in cell A2, the number 10, and cell C2 of the worksheet.

  • =FDIST(SUM(A2:A4), 10, AVERAGE(B2:B4))

    The FDIST function can be used in combination with other Sourcetable functions to calculate more complex F probability distributions. For example, this formula will return the F probability distribution for the sum of the numbers in cells A2 through A4, the number 10, and the average of the numbers in cells B2 through B4.

Summary

The FDIST function is a Sourcetable function used to calculate the F probability distribution, which is a measure of diversity between two data sets. It has been replaced with more accurate functions, F.DIST and F.DIST.RT.

  • The FDIST function is used to compare the degree of diversity between two data sets.
  • It is replaced with newer functions that calculate the same result.


Frequently Asked Questions

What is the FDIST function?
The FDIST function calculates the F probability distribution. It estimates the degree of diversity in a data set. The FDIST function calculates FDIST as FDIST=P(F>x).
Are there newer versions of the FDIST function?
Yes, the new functions are F.DIST and F.DIST.RT. F.DIST.RT is available in later versions of Excel than FDIST.
What are the benefits of using the newer versions of the FDIST function?
The newer versions of the FDIST function offer better accuracy.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.