IDAX.QNORM3P - Inverse normal distribution

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

Syntax

IDAX.QNORM3P(DOUBLE percentage, DOUBLE mean, DOUBLE
stdev)

Parameter descriptions

percentage: Mandatory.; The requested limit of the percentage.; If percentage is not in the range of 0 - 1, QNORM3P(percentage,mean,stdev) is null for all mean values and stdev values.; Min: 0.00000000001; Max: 0.99999999999; Data type: DOUBLE
mean: Mandatory.; The mean value of the distribution.; Data type: DOUBLE
stdev: Mandatory.; The standard deviation of the distribution.; If stdev is 0 or less, QNORM3P(percentage,mean,stdev) is null for all percentage values and mean values.; Min: 0.00000000001; Data type: DOUBLE

If PNORM3P(x,mean,stdev)=perc, QNORM3P(perc,mean,stdev)=x for all x values and mean values, and for all strictly positive stdev values.

Returned information

DOUBLE the point x where PNORM3P(x,mean,stdev)=percentage.