GAMINV Function

Returns a quantile from the gamma distribution.

Category:	Quantile
Returned data type:	DOUBLE

Syntax

Arguments

Details

Example

Syntax

GAMINV(p, a)

Arguments

p

specifies any valid expression that evaluates to a numeric probability.

Range	0 ≤ p < 1
Data type	DOUBLE
See	<sql-expression>
See	FedSQL Expressions

a

specifies any valid expression that evaluates to a numeric shape parameter.

Range	a > 0
Data type	DOUBLE
See	<sql-expression>
See	FedSQL Expressions

Details

The GAMINV function returns the p^th quantile from the gamma distribution, with shape parameter a. The probability that a row from a gamma distribution is less than or equal to the returned quantile is p.

Note: GAMINV is the inverse of the PROBGAM function.

Example

The following statements illustrate the GAMINV function:

Statement	Result
select gaminv(0.5, 9);	8.6689511844
select gaminv(0.1, 2.1);	0.5841932369

GAMINV Function

Syntax

Arguments

p

a

Details

Example

See Also