NORMSINV

Name

Inverse standard normal distribution

Description

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax

NORMSINV(prob)

Remarks

The argument is the probability for the normal distribution.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

NORMSINV(A1)
NORMSINV(R1C6)
NORMSINV(0.9244)=1.4353057