Calc Guide

Syntax Description
distribution.
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
Appendix B Description of Functions 453