Calc Guide

Syntax Description
set. Data is the cell range of data. Rank_c is
the ranking of the value (2nd largest, 3rd
largest, etc.) written as an integer.
LOGINV(number; mean;
STDEV)
Returns the inverse of the lognormal
distribution for the given Number, a
probability value. Mean is the arithmetic mean
of the standard logarithmic distribution.
STDEV is the standard deviation of the
standard logarithmic distribution.
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;
Returns the negative binomial distribution. X is
454 OpenOffice.org 3.x Calc Guide