00:47:00
Norm s inv function
NORM.S.INV function
Objective : Returns the inverse of the standard normal
cumulative distribution. The distribution has a mean of zero and a standard
deviation of one.
Syntax
NORM.S.INV(probability)The NORM.S.INV function syntax has the
following arguments (argument: A value that provides information to an action,
an event, a method, a property, a function, or a procedure.):
Probability
Required. A probability corresponding to the normal distribution.
Remarks
If probability is nonnumeric, NORMS.INV returns the #VALUE!
error value.
If probability <= 0 or if probability >= 1, NORMS.INV
returns the #NUM! error value.
Given a value for probability, NORM.S.INV seeks that value z
such that NORM.S.DIST(z,TRUE) = probability. Thus, precision of NORM.S.INV
depends on precision of NORM.S.DIST. NORM.S.INV uses an iterative search
technique.
Example
