NORM.INV Function

The NORM.INV function is one of the statistical functions. It is used to return the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORM.INV(probability, mean, standard_dev)

The NORM.INV function has the following arguments:

Argument Description
probability The probability corresponding to the normal distribution, any numeric value greater than 0, but less than 1.
mean The arithmetic mean of the distribution, any numeric value.
standard_dev The standard deviation of the distribution, a numeric value greater than 0.

Notes

How to apply the NORM.INV function.

Examples

The figure below displays the result returned by the NORM.INV function.

NORM.INV Function