Formula Functions > Functions M to Q > NORMSINV |
This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
NORMSINV(prob)
The argument is the probability for the normal distribution.
Accepts numeric data. Returns numeric data.
NORMSINV(A3)
NORMSINV(R1C2)
NORMSINV(0.9244) gives the result 1.43530571453713
This function is available in product version 1.0 or later.
NORMINV | NORMSDIST | Statistical Functions