NORMINV


Calculates the inverse of the cumulative NORMDIST normal distribution function.

Syntax:

NORMINV(p, α, λ)

The normal distribution is a family of continuous probability distributions, with two controlling parameters α and λ.
NORMINV returns the value n, such that NORMDIST(n, α, λ, 1) is p.

Example:

NORMINV(0.92, 63, 5)
returns approximately 70.






 
Created with Zapof