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

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

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.

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

Yes, the new functions are F.DIST and F.DIST.RT. F.DIST.RT is available in later versions of Excel than FDIST.

The newer versions of the FDIST function offer better accuracy.

Drop CSV