Name
LOGNORMDIST
Synopsis
Use LOGNORMDIST to find the cumulative probability for the lognormal distribution for the specified numeric value. This function is typically used to analyze logarithmically transformed data.
To Calculate
=LOGNORMDIST(X,Mean,Standard_Dev)
All of the arguments are required for this function.
-
X Indicates a positive numeric value.
-
Mean Indicates a numeric value that specifies the mean of the natural logarithm of the distribution.
-
Standard_Dev Indicates a positive numeric value that specifies the standard deviation for the natural logarithm of the distribution.
Example
Figure 15-27 illustrates how to use LOGNORMDIST to find the lognormal cumulative distribution.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
