This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.
Syntax
NORMINV(prob,mean,stdev)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| prob | Probability of the normal distribution |
| mean | Arithmetic mean of the distribution |
| stdestdev | Standard deviation of the distribution Must be greater than zero. |
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
NORMINV(B3,C12,D14)
NORMINV(R3C2,R12C3,R14C4)
NORMINV(0.978,32,0.252) gives the result 32.50755174
Version Available
This function is available in product version 1.0 or later.
See Also
NORMDIST | NORMSINV | Statistical Functions