Calc Guide

Syntax Description
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.
MDETERM(array) Returns the array determinant of an array. This function
returns a value in the current cell; it is not necessary to
define a range for the results. Array is a square array in
which the determinants are defined.
MINVERSE(array)
Returns the inverse array. Array is a square array that is
to be inverted.
MMULT(array; array) Calculates the array product of two arrays. The number
of columns for array 1 must match the number of rows
for array 2. The square array has an equal number of
rows and columns. Array at first place is the first array
used in the array product. Array at second place is the
second array with the same number of rows.
MUNIT(dimensions) Returns the unitary square array of a certain size. The
unitary array is a square array where the main diagonal
elements equal 1 and all other array elements are equal
to 0. Dimensions refers to the size of the array unit.
SUMPRODUCT(array 1;
array 2; ...array 30)
Multiplies corresponding elements in the given arrays,
and returns the sum of those products. Array 1; array
2;...array 30 are arrays whose corresponding elements
are to be multiplied. At least one array must be part of
the argument list. If only one array is given, all array
elements are summed.
SUMX2MY2(array_X;
array_Y)
Returns the sum of the difference of squares of
corresponding values in two arrays. Array_X is the first
array whose elements are to be squared and added.
Array_Y is the second array whose elements are to be
squared and subtracted.
Appendix B Description of Functions 409