NORMSINV ( probability )

Description: Computes the inverse of the standard normal distribution. The distribution has a mean of zero and a standard deviation of 1. NORMSINV uses an iterative search technique.

Arguments:

Name	Type	Description
probability	number	The probability corresponding to the normal distribution.

Return Type and Value: number – The inverse of the standard normal distribution.

However, if

• probability < 0 or if probability > 1, #NUM! is returned.

• The search has not converged after an implementation-defined number of iterations, #N/A is returned.

[Example:

NORMSINV(0.945) results in 1.59819314
NORMSINV(0.13) results in -1.12639113

end example]