FDIST
Syntax:
FDIST ( x , degrees-freedom-1 , degrees-freedom-2 )
Description: Computes the F probability distribution.
Mathematical Formula:
FDIST=P(F>x), where F is a random variable that has an F distribution with degrees-freedom-1 and degrees-freedom-2 degrees of freedom.
Arguments:
Name |
Type |
Description |
|---|---|---|
x |
number |
The value at which the function is to be evaluated. |
degrees-freedom-1 |
number |
The number of degrees of freedom for the numerator, truncated to an integer. |
degrees-freedom-2 |
number |
The number of degrees of freedom for the denominator, truncated to an integer. |
Return Type and Value: number – The F probability distribution.
However, if
x is negative,
#NUM!is returned.degrees-freedom-1 < 1 or degrees-freedom-1 ≥ 1010,
#NUM!is returned.degrees-freedom-2 < 1 or degrees-freedom-2 ≥ 1010,
#NUM!is returned.