IDAX.QHYPER - Inverse hypergeometric distribution

The QHYPER function returns the value x of a variable that follows the hypergeometric distribution for which the probability of being smaller or equal to x is equal to the specified percentage. x is the number of white balls that are drawn without replacement from an urn that contains black balls and white balls.

Syntax

IDAX.QHYPER(DOUBLE percentage, BIGINT wu, BIGINT bu, BIGINT
N)

Parameter descriptions

percentage: Mandatory.; The requested limit of the percentage.; If percentage is not in the range of 0 - 1, QHYPER(percentage,wu,bu,N) is null for all N values, wu values, and bu values.; Min: 0.00000000001; Max: 0.99999999999; Data type: DOUBLE
wu: Mandatory.; The number of white balls in the urn.; If wu is negative, QHYPER(percentage,wu,bu,N) is null for all percentage values and N values.; Min: 0; Data type: BIGINT
bu: Mandatory.; The number of black balls in the urn.; If bu is negative, QHYPER(percentage,wu,bu,N) is null for all percentage values and N values.; Min: 0; Data type: BIGINT
N: Mandatory.; The number of balls that drawn from the urn without replacement.; If N is 0 or less, QHYPER(percentage,wu,bu,N) is null for all percentage values, wu values, and bu values.; Min: 1; Data type: BIGINT

If PHYPER(x,wu,bu,N)=percentage, QHYPER(percentage,wu,bu,N)=x for all x values, and for all positive wu values, positive bu values, and positive N values.

Returned information

BIGINT the point x, where PHYPER(x,wu,bu,N)=percentage.