Navigation:  Formula Reference > Spreadsheet Formula Functions >

CHISQ.INV.RT

Previous pageReturn to chapter overviewNext page

 

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