Related Topics:
	Spreadsheet Math Functions Formulas Tab and Insert Function Data Entry Tips for Functions Function Wizard

FDIST

Description: Returns the F probability distribution.

Syntax: FDIST(Number, Deg_Freedom1, Deg_Freedom2)

• Number is the value at which to evaluate the function.

• Deg_Freedom1 is the numerator degrees of freedom.

• Deg_Freedom2 is the denominator degrees of freedom.

Remarks:

• All arguments must be numerical.

• Number cannot be negative.

• If Deg_Freedom1 or Deg_Freedom2 is not an integer, it is truncated.

• Deg_Freedom1 and Deg_Freedom2 must be >= 1 and < 10^10.

• FDIST is calculated as FDIST=P(F>x), where Number = x and where F is a random variable that has an F distribution with Deg_Freedom1 and Deg_Freedom2 degrees of freedom.

Example:

• FDIST(15.20686468, 6, 4) = 0.01

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link