NORMINV

Computes the value x such that the normal distribution with a given mean and standard deviation has cumulative probability equal to the input probability.

Parameter List

Syntax
NORMINV(probabilitymeanstandard_dev)
probability

Cumulative probability for which to compute the inverse normal value (0–1).

mean

The mean (average) of the normal distribution.

standard_dev

The standard deviation of the distribution; must be > 0.

Examples

NORMINV(0,95, 0, 1) returns 1.6448536270