NORMINV

Description Computes the inverse of the cumulative normal distribution. This is the inverse of the NORMDIST function when the last argument is TRUE.

Syntax NORMINV (probability, mean, st_dev)

Argument Description

probability A number between 0 and 1 that indicates the probability associated with the cumulative normal distribution.

mean The arithmetic mean of the distribution.

st_dev The standard deviation of the distribution. It must be a number greater than 0.

Argument	Description
probability	A number between 0 and 1 that indicates the probability associated with the cumulative normal distribution.
mean	The arithmetic mean of the distribution.
st_dev	The standard deviation of the distribution. It must be a number greater than 0.

Examples This function returns 21.64:

NORMINV (0.95, 20, 1)

See Also NORMDIST