Calc Guide

Syntax Description
DVARP(database;
database_field;
search_criteria)
Calculates the variance of all cell values in a
database field in all records that match the
specified search_criteria. The records are from
the example are treated as an entire population.
Array functions
Table 42: Array functions
Syntax Description
FREQUENCY(data;
classes)
Calculates the frequency distribution in a one-
column-array. The default value supply and the
number of intervals or classes are used to count
how many values are omitted on the single
intervals. Data is the array of, or reference to, the
set of values to be counted. Classes is the array of
the class set.
GROWTH(data_Y;
data_X; new_data_X;
function_type)
Calculates the points of an exponential trend in an
array. Data_Y is the Y Data array. Data_X
(optional) is the X Data array. New_Data_X
(optional) is the X data array, in which the values
are recalculated. Function_type is optional. If
function_type = 0, functions in the form y = m^x
are calculated. Otherwise, y = b*m^x functions
are calculated.
LINEST(data_Y;
data_X; linear_type;
stats)
Returns the parameters of a linear trend. Data_Y
is the Y Data array. Data_X (optional) is the X Data
array. Linear_Type (optional): If the line goes
through the zero point, then set Linear_Type = 0.
Stats (optional): If Stats=0, only the regression
coefficient is calculated. Otherwise, other
statistics will be seen.
LOGEST(data_Y;
data_X; function_type;
stats)
Calculates the adjustment of the entered data as
an exponential regression curve (y=b*m^x).
Data_Y is the Y Data array. Data_X (optional) is
the X Data array. Function_type (optional): If
function_type = 0, functions in the form y = m^x
are calculated. Otherwise, y = b*m^x functions
are calculated. Stats (optional). If Stats=0, only
the regression coefficient is calculated.
468 OpenOffice.org 3.x Calc Guide