NORMINV

Calculates the inverse normal distribution for a specific probability to determine the corresponding value based on a given mean and standard deviation.

The NORMINV function calculates the inverse of the normal cumulative distribution for a specified mean and standard deviation. It allows you to work backward from a given probability to find the corresponding value on the normal distribution curve.

Syntax#

NORMINV(probability, mean, std_dev)

Arguments#

The NORMINV function syntax has the following required arguments:

• probability - A probability corresponding to the normal distribution. Required.
• mean - The arithmetic mean of the distribution. Required.
• std_dev - The standard deviation of the distribution. Required.

Example#

NORMINV(0.90, 50, 5)
// Returns 56.41

You can use the NORMINV function to determine critical values or thresholds, such as calculating the specific score required to be in the top 10% of a dataset or finding the target level needed to meet a certain probability.

Excel Equivalent#

NORMINV

FAQs#

Q1. What is the relationship between NORMDIST and NORMINV?

• NORMINV is the mathematical inverse of NORMDIST (when cumulative is set to TRUE).
• While NORMDIST tells you the probability of a value occurring, NORMINV tells you what the value is for a specific target probability.