Table of contents
TOC
Collapse the table of content
Expand the table of content

NORM.INV Function

Owen Duncan|Last Updated: 8/14/2018

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

Syntax

NORM.INV(Probability, Mean, Standard_dev)

Parameters

TermDefinition
ProbabilityA probability corresponding to the normal distribution.
MeanThe arithmetic mean of the distribution.
Standard_devThe 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

© 2018 Microsoft