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

Syntax

CHISQ.INV(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

If the argument is nonnumeric, the function returns the #VALUE! error value.

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

CHISQ.INV(B5,D7)

CHISQ.INV(R5C2,R7C4)

CHISQ.INV(0.75,4) gives the result 5.385269057779394