NORM.INV Function

The inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORM.INV(Probability, Mean, Standard_dev)

Parameters

Term Definition
Probability A probability corresponding to the normal distribution.
Mean The arithmetic mean of the distribution.
Standard_dev The standard deviation of the distribution.

Return value

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Example

EVALUATE { NORM.INV(0.908789, 40, 1.5) }

Returns

[Value]
42.00000200956628780274132

See Also

NORM.S.INV
NORM.S.DIST Function
NORM.DIST Function