Spread Formula Reference
NORMSINV
Support Options
Formula Functions > Functions M to Q > NORMSINV

Glossary Item Box

This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax

NORMSINV(prob)

Arguments

The argument is the probability for the normal distribution.

Data Types

Accepts numeric data. Returns numeric data.

Examples

NORMSINV(A3)

NORMSINV(R1C2)

NORMSINV(0.9244) gives the result 1.43530571453713

Version Available

This function is available in product version 1.0 or later.

See Also

NORMINV | NORMSDIST | Statistical Functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.