Calc Guide

Syntax Description
GAMMAINV(number; alpha;
beta)
Returns the inverse of the Gamma cumulative
distribution. This function allows you to search for
variables with different distribution.
Number is the probability value for which the
inverse Gamma distribution is to be calculated.
Alpha is the parameter Alpha of the Gamma
distribution. Beta is the parameter Beta of the
Gamma distribution.
GAMMALN(number) Returns the natural logarithm of the Gamma
function, G(x), for the given number.
GAUSS(number) Returns the standard normal cumulative distribution
for the given number.
GEOMEAN(number_1;
number_2; ... number_30)
Returns the geometric mean of a sample. Number_1;
number_2; ... number_30 are numerical arguments
or ranges that represent a random sample.
HARMEAN(number_1;
number_2; ... number_30)
Returns the harmonic mean of a data set.
Number_1; number_2; ... number_30 are values or
ranges that can be used to calculate the harmonic
mean.
HYPGEOMDIST(X; n_sample;
successes; n_population)
Returns the hypergeometric distribution. X is the
number of results achieved in the random sample.
N_sample is the size of the random sample.
Successes is the number of possible results in the
total population. N_population is the size of the total
population.
INTERCEPT(data_Y; data_X) Calculates the y-value at which a line will intersect
the y-axis by using known x-values and y-values.
Data_Y is the dependent set of observations or data.
Data_X is the independent set of observations or
data.
Names, arrays or references containing numbers
must be used here. Numbers can also be entered
directly.
KURT(number_1;
number_2; ... number_30)
Returns the kurtosis of a data set (at least 4 values
required). Number_1; number_2; ... number_30
are numerical arguments or ranges representing a
random sample of distribution.
LARGE(data; rank_c)
Returns the Rank_c-th largest value in a data 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.
396 OpenOffice.org 3.3 Calc Guide