Skip to main content

NORMINV function

The NORMINV 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​

NORMINV(probability, mean, standard_dev)

The NORMINV 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 NORMINV function.

Examples​

The figure below displays the result returned by the NORMINV function.

NORMINV Function