Microsoft Office Tutorials and References
In Depth Information
LOGNORMDIST
LOGNORMDIST
LOGNORMDIST returns the cumulative lognormal distribution of x, where ln(x) is normally
distributed with parameters mean and standard deviation.
=LOGNORMDIST(x,mean,standard_dev)
The LOGNORMDIST function is used to analyze logarithmically transformed data. For example,
LOGNORMDIST(5,4.5,1.7) equals 0.044534344 .
Is the value at which to evaluate the function.
X
Is the mean of the logarithm of x, ln(x) .
MEAN
Is the standard deviation of the logarithm of x, ln(x) .
STANDARD_DEV
The equation for LOGNORMDIST is
MAX MAX returns the largest value in a set of values.
=MAX(number1,number2,...)
Use the MAX function to display the largest sales figure, production throughput, score, and so
on, in a group of values. Figure 11.26 shows an example of the MAX function.
Is the cell reference(s), range name, or array that makes up the data set.
Up to 30 unique arguments (data sets) can be specified.
NUMBER N
Figure 11.26
While the MAX function
evaluates cells
containing numerical data, you
can use MAXA when
you need to evaluate
data containing text or
logical values.
Search JabSto ::

Custom Search