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

Glossary Item Box

GAMMAINV


Name

Gamma distribution

Description

Returns the inverse of the gamma cumulative distribution.

Syntax

GAMMAINV(p,alpha,beta)

Remarks

This function has the following arguments:

Argument Description
p Probability
alpha Alpha parameter of the distribution
beta Beta parameter of the distribution

This function calculates the inverse of the F probability distribution, so if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.

Data Type

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

Example

GAMMAINV(A3,3,4)
GAMMAINV(0.8902,R3C8,R3C9)
GAMMAINV(0.75,2,3)=8.0779035867

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