Calc Guide

Syntax Description
LOGNORMDIST(number;
mean; STDEV)
Returns the cumulative lognormal distribution for the
given Number, a probability value. Mean is the
mean value of the standard logarithmic distribution.
STDEV is the standard deviation of the standard
logarithmic distribution.
MAX(number_1; number_2; ...
number_30)
Returns the maximum value in a list of arguments.
Number_1; number_2; ... number_30 are
numerical values or ranges.
MAXA(value_1; value_2; ...
value_30)
Returns the maximum value in a list of arguments.
Unlike MAX, text can be entered. The value of the
text is 0. Value_1; value_2; ... value_30 are values or
ranges.
MEDIAN(number_1;
number_2; ... number_30)
Returns the median of a set of numbers. Number_1;
number_2; ... number_30 are values or ranges,
which represent a sample. Each number can also be
replaced by a reference.
MIN(number_1; number_2; ...
number_30)
Returns the minimum value in a list of arguments.
Number_1; number_2; ... number_30 are
numerical values or ranges.
MINA(value_1; value_2; ...
value_30)
Returns the minimum value in a list of arguments.
Here text can also be entered. The value of the text is
0. Value_1; value_2; ... value_30 are values or
ranges.
MODE(number_1;
number_2; ... number_30)
Returns the most common value in a data set.
Number_1; number_2; ... number_30 are
numerical values or ranges. If several values have
the same frequency, it returns the smallest value. An
error occurs when a value does not appear twice.
NEGBINOMDIST(X; R; SP)
Returns the negative binomial distribution. X is the
value returned for unsuccessful tests. R is the value
returned for successful tests. SP is the probability of
the success of an attempt.
NORMDIST(number; mean;
STDEV; C)
Returns the normal distribution for the given
Number in the distribution. Mean is the mean value
of the distribution. STDEV is the standard deviation
of the distribution. C = 0 calculates the density
function, and C = 1 calculates the distribution.
NORMINV(number; mean;
STDEV)
Returns the inverse of the normal distribution for the
given Number in the distribution. Mean is the mean
value in the normal distribution. STDEV is the
standard deviation of the normal distribution.
NORMSDIST(number) Returns the standard normal cumulative distribution
for the given Number.
NORMSINV(number) Returns the inverse of the standard normal
distribution for the given Number, a probability
value.
Appendix B Description of Functions 397