Norm_S_Inv Method
TOC
Collapse the table of content
Expand the table of content

WorksheetFunction.Norm_S_Inv Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.

expression .Norm_S_Inv(Arg1)

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.

Return Value

Double

  • If probability is non-numeric, NORM_S_INV returns the #VALUE! error value.

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

Given a value for probability, NORM_S_INV seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of NORM_S_INV depends on precision of NORM_S_DIST. NORM_S_INV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.

Show:
© 2016 Microsoft