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.

[Example:

NORMINV(0.908789,40,1.5) results in 42.00000201

end example]