The NORMSINV function returns the inverse of the cumulative standard normal distribution.
NORMSINV(probability)
probability: A number value representing the probability associated with the distribution. probability must be greater than 0 and less than 1.
Notes
A standard normal distribution has an average (arithmetic mean) of 0 and a standard deviation of 1.
Example |
|---|
=NORMSINV(0.89) returns 1.22652812003661. |