Calc Guide

Syntax Description
calculates the density function, and C = 1
calculates the distribution.
FDIST(number;
degrees_freedom_1;
degrees_freedom_2)
Calculates the values of an F probability
distribution. Number is the value for which
the F distribution is to be calculated.
Degrees_freedom_1 is the degrees of
freedom in the numerator in the F distribution.
Degrees_freedom_2 is the degrees of
freedom in the denominator in the F
distribution.
FINV(number;
degrees_freedom_1;
degrees_freedom_2)
Returns the inverse of the F probability
distribution. Number is probability value for
which the inverse F distribution is to be
calculated. Degrees_freedom_1 is the number
of degrees of freedom in the numerator of the
F distribution. Degrees_freedom_2 is the
number of degrees of freedom in the
denominator of the F distribution.
FISHER(number) Returns the Fisher transformation for the
given number and creates a function close to
a normal distribution.
FISHERINV(number) Returns the inverse of the Fisher
transformation for the given number and
creates a function close to a normal
distribution.
FORECAST(value; data_Y;
data_X)
Extrapolates future values based on existing x
and y values. Value is the x value, for which
the y value of the linear regression is to be
returned. Data_Y is the array or range of
known y’s. Data_X is the array or range of
known x’s. Does not work for exponential
functions.
FTEST(data_1; data_2)
Returns the result of an F test. Data_1 is the
first record array. Data_2 is the second record
array.
GAMMADIST(number;
alpha; beta; C)
Returns the values of a Gamma cumulative
distribution. Number is the value for which
the Gamma distribution is to be calculated.
Alpha is the parameter Alpha of the Gamma
distribution. Beta is the parameter Beta of the
Gamma distribution. C = 0 calculates the
density function, and C = 1 calculates the
452 OpenOffice.org 3.x Calc Guide