Spread 8.0 Documentation
CHIINV
Support Options
Formula Reference > Built-In Functions > CHIINV

Glossary Item Box

CHIINV


Name

Inverse chi distribution

Description

Calculates the inverse of the one-tailed probability of the chi-squared distribution.

Syntax

CHIINV(prob,deg)

Remarks

This function has the following 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 Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

CHIINV(B2,D7)
CHIINV(R5C2,R7C4)
CHIINV(0.75,4)=1.9225575262

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.