The F.DIST function returns the left-tailed F distribution for two data sets.
Allows to determine the probability that the difference between variances occurred randomly.
This function can be useful for analyzing probabilities and statistical data.
Syntax
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
Argument |
Description |
Permitted values |
|---|---|---|
x |
Ratio of variances |
Any real non-negative number ≥0 or a reference to a cell containing a number |
deg_freedom1 |
Number of degrees of freedom for the variance in the numerator |
Positive real number or a reference to a cell containing a number |
deg_freedom2 |
Number of degrees of freedom for the variance in the denominator |
Positive real number or a reference to a cell containing a number |
cumulative |
Boolean value that determines the form of the function to be returned: the normal cumulative distribution function (TRUE) or the probability density function (FALSE) |
TRUE or FALSE |
Examples of use
Calculation of the cumulative value of the Fisher distribution for x = 2.5, degrees of freedom 5 and 10:
=F.DIST(2.5, 5, 10, TRUE)
Result: approximately 0.89799.
Calculation of the probability density function at point x = 2.5:
=F.DIST(2.5, 5, 10, FALSE)
Result: approximately 0.09359.
Notes
–The values of the arguments for degrees of freedom (deg_freedom1 and deg_freedom2) are rounded to integers if they are fractional.
–The values of the arguments for degrees of freedom (deg_freedom1 and deg_freedom2) must be greater than 1 and cannot exceed 10 to the power of 10.