|
NORMINV function |
  
|
|
NORMINV function |
|
Returns the inverse of the cumulative distribution function for the specified mean and standard deviation.
Syntax
NORMINV(probability,mean,standard_dev)
where
Probability |
is a probability corresponding to the normal distribution (must be > 0 and < 1). |
Mean |
is the arithmetic mean of the distribution. |
Standard_dev |
is the standard deviation of the distribution (must be greater than 0.) |
The result of norminv is the inverse of the NORMDISTCDF function, i.e. NORMINV(NORMDISTCDF(x,5,2),5,2)=x.
____________________________
See also: