Spread Formula Reference
CHIINV
Formula Functions > Functions A to C > CHIINV

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

Syntax

CHIINV(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

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

CHIINV(B5,D7)

CHIINV(R5C2,R7C4)

CHIINV(0.75,4) gives the result 1.9225575262

Version Available

This function is available in product version 1.0 or later.

See Also

CHIDIST | CHITEST | Statistical Functions