NORMINV
Syntax:
NORMINV ( probability , mean , standard-deviation )
Description: Computes the inverse of the normal distribution for the specified mean and standard deviation. NORMINV
uses an iterative search technique.
Arguments:
Name |
Type |
Description |
---|---|---|
probability |
number |
The probability corresponding to the normal distribution. |
mean |
number |
The arithmetic mean of the distribution. |
standard-deviation |
number |
The standard deviation of the distribution. |
Return Type and Value: number – The inverse of the normal distribution for the specified mean and standard deviation.
However, if
probability < 0 or if probability > 1,
#NUM!
is returned.standard-deviation ≤ 0,
#NUM!
is returned.The search has not converged after an implementation-defined number of iterations,
#N/A
is returned.