The NORMINV function returns the inverse of the cumulative normal distribution. All arguments are number values.
NORMINV(probability, average, stdev)
probability: A value representing the probability associated with the distribution. probability must be greater than 0 and less than 1.
average: A value representing the known average (arithmetic mean) rate at which events occur.
stdev: The standard deviation of the population. stdev must be greater than 0.
Notes
If average is 0 and stdev is 1, NORMINV returns the same value as the inverse of the cumulative standard normal distribution returned by NORMSINV.
Example |
|---|
=NORMINV(0.89, 15, 2.5) returns 18.0663203000915. |