FDIST

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 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/BooleanLogical argument which defines the type of distribution to be calculated
Trueuses the cumulative distribution function
Falseuses the probability density function

Examples

FDIST(#input!VALUE; #input!DF1; #input!DF2; cumulative value)

VALUE
DF1
DF2
Cumulative valueFDIST returns
125false0.308
125true0.5688

Common Errors

#NUM!-

Occurs if either:

  • The x value is less than 0
  • The numerator or denominator is less than 1
#VALUE!-Occurs if the argument type isn't numeric