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

LOGINV(probability, mean, standard_dev)

 
 Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev

 probabilityThe probability associated with the lognormal distribution.
 meanThe mean of ln(x).
 standard_devThe standard deviation of ln(x).

 REMARKS
 
  		• Use the lognormal distribution to analyze logarithmically transformed data.
     
  		• If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x.
     
  		• If any of the arguments are 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.

     EXAMPLES
     
     A
    1=LOGINV(0.029084,3.5,1.2) = 3.410
    2=LOGINV(0.5,2,1) = 7.389
    		 
     Functions - L | Index - L | Office Online 

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