Skip to main content

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:

ArgumentDescription
probabilityThe probability corresponding to the normal distribution, any numeric value greater than 0, but less than 1.
meanThe arithmetic mean of the distribution, any numeric value.
standard_devThe 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