NORMSINV function

Description

Returns a Standardized Normal deviate. NORMSINV(P) returns the standardized Normal deviate z corresponding with the one-tailed probability P. P must be a value between 0 and 1 (0<P<1).

NORMSINV is the inverse function of the NORMSDIST function.

Examples

NORMSINV(0.025)  returns -1.96 (rounded).

NORMSINV(0)  returns an error.

Calculator

NORMSINV()

Graph

NORMSINV function
Function: NORMSINV()
  X-axis Y-axis
Minimum:
Maximum:
Help  

See also

This site uses cookies to store information on your computer. More info...