F.DIST()

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.

Arguments

  • 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.