NORMSINV

Description: Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax: NORMSINV(Probability)

• Probability is a probability corresponding to the normal distribution.

Remarks:

• Probability must be a number.
• Probability must be => 0 and <= 1.

• When used in an event analysis flowchart, Probability must evaluate to a numerical value. It can include:

• Numerical values

• Standard operands (+, -, *, /)

• Predefined mathematical functions (exp, log, sin, etc.)

• Event analysis internal functions

• Event analysis resources

• References to any ReliaSoft Workbooks

Example:

• NORMSINV(0.908789) = 1.3333