Expand Minimize

WorksheetFunction.Norm_Inv Method (Excel)

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

Version Added: Excel 2010

expression .Norm_Inv(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Probability - A probability corresponding to the normal distribution.

Arg2

Required

Double

Mean - The arithmetic mean of the distribution.

Arg3

Required

Double

Standard_dev - The standard deviation of the distribution.

Return Value

Double

  • If any argument is non-numeric, NORM_INV returns the #VALUE! error value.

  • If probability <= 0 or if probability >= 1, NORM_INV returns the #NUM! error value.

  • If standard_dev ≤ 0, NORM_INV returns the #NUM! error value.

  • If mean = 0 and standard_dev = 1, NORM_INV uses the standard normal distribution (see NORM_S_INV).

Given a value for probability, NORM_INV seeks that value x such that NORM_DIST(x, mean, standard_dev, TRUE) = probability. Thus, precision of NORM_INV depends on precision of NORM_DIST.

Show:
© 2014 Microsoft