IDAX.QBINOM - Inverse binomial distribution

The IDAX.QBINOM function returns the value x of a variable that follows the binomial distribution for which the probability of being smaller or equal to x is equal to the specified percentage.

Syntax

IDAX.QBINOM(DOUBLE percentage, INT8 N, DOUBLE p)

Parameter descriptions

percentage: Mandatory.; The requested limit of the percentage.; If percentage is not in the range of 0 - 1, QBINOM(percentage,N,p) is null for all p values.; Min: 0.00000000001; Max: 0.99999999999; Data type: DOUBLE
N: Mandatory.; The number of trials.; If N is 0 or less, QBINOM(perc,N,p) is null for all perc values and p values.; Min: 1; Data type: INT8
p: Mandatory.; The probability of success.; If p is not in the range of 0 - 1, QBINOM(percentage,N,p) is null for all percentage values and N values.; Min: 0.00000000001; Max: 1-0.00000000001; Data type: DOUBLE

If PBINOM(x,N,p)=perc, QBINOM(perc,N,p)=x for all positive x values, positive N values, and p values in the range of 0 - 1.

Returned information

INT8 the point x, where PBINOM(x,N,p)=percentage.