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

LOGNORMDIST(x, mean, standard_dev)

 
 Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.

 xThe value at which to evaluate the function.
 meanThe mean of ln(x).
 standard_devThe standard deviation of ln(x).

 REMARKS
 
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "x" = 0, then #NUM! is returned.
     
  		• If "standard_dev" = 0, then #NUM! is returned.

     EXAMPLES
     
     A
    1=LOGNORMDIST(4,3.5,1.2) = 0.039
    2=LOGNORMDIST(4,"some text",1.2) = #VALUE!
    		 
     Functions - L | Index - L | Office Online 

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