Spread Formula Reference
CHISQ.INV.RT
Formula Functions > Functions A to C > CHISQ.INV.RT

This function calculates the inverse of the right-tailed probability of the chi-squared distribution.

Syntax

CHISQ.INV.RT(prob,deg)

Arguments

This function has these arguments:

Argument Description
prob Probability of the chi-squared distribution
deg Number of degrees of freedom; if not an integer, the number is truncated

Remarks

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

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

CHISQ.INV.RT(B5,D7)

CHISQ.INV.RT(R5C2,R7C4)

CHISQ.INV.RT(0.75,4) gives the result 1.9225575262293264

Version Available

This function is available in Spread for Windows Forms 11.0 or later.

See Also

CHISQ.DIST