Syntax. F.DIST(x,degrees_freedom1,degrees_freedom2,cumulative)

Definition. This function returns the values of a distribution function (1 alpha) of a left F-distributed random variable. Use this function to determine whether two data sets have different variances.

For example, you can examine the test scores of men and women taking a recruitment test and determine whether the variance for the females is different from the variance for the males.


  • x (required). The value at which to evaluate the function.

  • degrees_freedom1 (required). The degrees of freedom in the numerator.

  • degrees_freedom2 (required). The degrees of freedom in the denominator.

  • cumulative (required). The logical value that represents the type of the function. If cumulative ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.