Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > NORMINV
 

NORMINV(probability, mean, standard_dev)

 
 Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

 probabilityThe probability below the z-score.
 meanThe arithmetic mean of the distribution.
 standard_devThe standard deviation of the distribution.

 REMARKS
 
  		• If any argument is not numeric, then #VALUE! is returned.
     
  		• If "probability" < 0, then #NUM! is returned.
     
  		• If "probability" > 1, then #NUM! is returned.
     
  		• If "standard_dev" = 0, then #NUM! is returned.
     
  		• If "mean" = 0 and "standard_dev" = 1, then the standard normal distribution is used.
     
  		• This function uses an iterative technique for calculating the function.
     
  		• Given a "probability" value, this function iterates until the result is accurate to within ± 3x10^-7.
     
  		• If this function does not converge after 100 iterations, then #N/A is returned.

     EXAMPLES
     
     A
    1=NORMINV(0.908789,40,1.5) = 42
    2=NORMINV(0.87,0,1) = 1.126
    3=NORMINV(NORMDIST(0.87,0,1,TRUE),0,1) = 0.87
    4=NORMINV(1,0,1) = #NUM!
    5=NORMINV(-1,40,1.5) = #NUM!
    6=NORMINV(2,40,1.5) = #NUM!
    7=NORMINV(0.908789,"some text",1.5) = #VALUE!
    		 
     Functions - N | Index - N | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top