NORMINV

Definition: NORMINV is a function that returns the inverse of the normal distribution for a specified mean and standard deviation.

Syntax: =NORMINV(probability, mean, standard_dev)

Situation: This formula is appropriate when you need to calculate the inverse of the normal distribution for a specified mean and standard deviation.

Example: If you have a normal distribution with a mean of 10 and a standard deviation of 2, and want to find the value that corresponds to a cumulative probability of 0.3, the formula =NORMINV(0.3, 10, 2) can be used, which returns 7.725.