NORMINV

Description: Returns the inverse of the normal cumulative distribution.

Syntax: NORMINV(Probability, Mean, Standard_dev)

  • Probability is a probability corresponding to the normal distribution.
  • Mean is the arithmetic mean of the distribution.
  • Standard_dev is the standard deviation of the distribution.

Remarks:

  • All arguments must be numerical.
  • Probability must be =>0 and <= 1.
  • Standard_dev must be > 0.
  • If Mean = 0 and Standard_dev = 1, NORMINV uses the standard normal distribution (see NORMSINV).

Example:

  • NORMINV(0.908789, 40, 1.5) = 42

Related Topics and Links