Related Topics: | ||
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
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.