This function 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)
Arguments
The argument is the probability for the normal distribution.
Data Types
Accepts numeric data. Returns numeric data.
Examples
NORMSINV(A3)
NORMSINV(R1C2)
NORMSINV(0.9244) gives the result 1.43530571453713
Version Available
This function is available in product version 1.0 or later.
See Also
NORMINV | NORMSDIST | Statistical Functions