/
FDIST
FDIST
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Analytics
Loading data...
Syntax
FDIST( <number>, <number>, <number>; <boolean>)
Description
Returns the F probability distribution for a certain value with given degrees of freedom for the numerator and degrees of freedom for the denominator.
or
Returns the Probability Density Function or the Cumulative Distribution Function for the F distribution. This function is frequently used used to measure the degree of diversity between two data sets.
The function arguments are:
- x: The value for which the distribution should be computed (NUMERIC)
- df1: Numerator degrees of freedom (NUMERIC)
- df2: Denominator degrees of freedom (NUMERIC)
- Cumulative: Constant indicating the form of the function. If true then the cumulative distribution function is used. If false then the probability mass function is used. (BOOLEAN)
| Cumulative/Boolean | Logical argument which defines the type of distribution to be calculated |
|---|---|
| True | uses the cumulative distribution function |
| False | uses the probability density function |
Examples
FDIST(#input!VALUE; #input!DF1; #input!DF2; cumulative value)
VALUE | DF1 | DF2 | Cumulative value | FDIST returns |
|---|---|---|---|---|
| 1 | 2 | 5 | false | 0.308 |
| 1 | 2 | 5 | true | 0.5688 |
Common Errors
| #NUM! | - | Occurs if either:
|
| #VALUE! | - | Occurs if the argument type isn't numeric |
, multiple selections available,