|
NORM.INV |
  
|
|
NORM.INV |
|
This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.
Syntax
NORM.INV(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 |
Remarks
The #VALUE! error value is returned if any argument is nonnumeric.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
NORM.INV(B3,C12,D14)
NORM.INV(R3C2,R12C3,R14C4)
NORM.INV(0.978,32,0.252) gives the result 32.50755088397007