NORMDIST NORMSDIST

NORMINV

NORMINV —

Synopsis

NORMINV(p,mean,stddev)

Description

NORMINV function returns the inverse of the normal cumulative distribution. p is the given probability corresponding to the normal distribution, mean is the arithmetic mean of the distribution, and stddev is the standard deviation of the distribution.

  • If p < 0 or p > 1 or stddev <= 0 NORMINV returns #NUM! error.
  • This function is Excel compatible.

Examples

NORMINV(0.76,2,3) equals 4.118907689.

See also

NORMDIST, NORMSDIST, NORMSINV, STANDARDIZE, ZTEST.

NORMDIST NORMSDIST