NTNORMINV

Returns the inverse of the cumulative distribution function for a specified standard normal distribution.

Syntax

Parameters

• prob is a probability corresponding to the normal distribution (0 < prob < 1).

Remarks

• This function is same as Excel function “NORMSINV”.

Example

• The example may be easier to understand if you copy it to a blank worksheet
  How to copy an example
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic.

     Note  Do not select the row or column headers.

     

     Selecting an example from Help

  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

  1 2 3 4

  A B Data Description 0.5 Probability associated with the standard normal distribution Formula Description (Result) =NTNORMINV(A2) Inverse of the cumulative distribution function for the terms above

• Download sample excel sheet

See also

• NTRANDNORM
• NTNORMDIST
• Normal distribution (Single variable)