NORMINV
Name
Inverse normal distribution
Description
Returns the inverse of the normal cumulative distribution for the given mean and standard deviation.
Syntax
NORMINV(prob,mean,stdev)
Remarks
This function has the following arguments:
Argument | Description |
---|---|
prob | Probability of the normal distribution |
mean | Arithmetic mean of the distribution |
stdev | Standard deviation of the distribution. Must be greater than zero |
Data Type
Accept numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
NORMINV(B3,C12,D14)
NORMINV(R3C1,R12C3,R14C4)
NORMINV(0.978,32,0.252)=32.50755174