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

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