CHIINV
Spread WinRT Documentation > Formula Reference > Formula Functions > CHIINV

Summary

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

See Also