Calc Guide

Syntax Description
success on each trial. T_1 defines the lower
limit for the number of trials. T_2 (optional)
defines the upper limit for the number of trials.
BETADIST(number; alpha;
beta; start; end)
Returns the cumulative beta probability
density function. Number is the value between
Start and End at which to evaluate the
function. Alpha is a parameter to the
distribution. Beta is a parameter to the
distribution. Start (optional) is the lower
bound for number. End (optional) is the upper
bound for number.
BETAINV(number; alpha;
beta; start; end)
Returns the inverse of the cumulative beta
probability density function. Number is the
value between Start and End at which to
evaluate the function. Alpha is a parameter to
the distribution. Beta is a parameter to the
distribution. Start (optional) is the lower
bound for number. End (optional) is the upper
bound for number.
BINOMDIST(X; trials; SP;
C)
Returns the individual term binomial
distribution probability. X is the number of
successes in a set of trials. Trials is the
number of independent trials. SP is the
probability of success on each trial. C = 0
calculates the probability of a single event and
C = 1 calculates the cumulative probability.
CHIDIST(number;
degrees_freedom)
Returns the probability value that a hypothesis
will be confirmed from the indicated chi
square. The probability determined by
CHIDIST can also be determined by CHITEST.
Number is the chi-square value of the random
sample used to determine the error probability.
Degrees_freedom is the degrees of freedom
of the experiment.
CHIINV(number;
degrees_freedom)
Returns the inverse of the one-tailed
probability of the chi-squared distribution.
Number is the value of the error probability.
Degrees_freedom is the degrees of freedom
of the experiment.
CHITEST(data_B; data_E) Returns the chi-square distribution from a
random distribution of two test series based on
the chi-square test for independence. The
probability determined by CHITEST can also
450 OpenOffice.org 3.x Calc Guide