Products, services, and OS functions
may not be available in this country.

NORMINV

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.

See alsoNORMDISTNORMSINV
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.