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.