Navigation:  Formula Reference > Spreadsheet Formula Functions >

F.DIST.RT

Previous pageReturn to chapter overviewNext page

 

This function calculates the F probability distribution, to see degrees of diversity between two sets of data.

Syntax

F.DIST.RT(value,degnum,degden)

Arguments

This function has these arguments:

Argument

Description

value

Value at which to evaluate the function

degnum

Number of degrees of freedom for the numerator; if not an integer, the number is truncated

degden

Number of degrees of freedom for the denominator; if not an integer, the number is truncated

Remarks

The #VALUE! error value is returned if any argument is nonnumeric.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

F.DIST.RT(A1,2,2)

F.DIST.RT(R1C1,2,1)

F.DIST.RT(16.83975,5,3) gives the result 0.021000082461949843