Calc Guide

Syntax Description
the dependent array or range of data for the
second record. Mode = 1 calculates the one-
tailed test, Mode = 2 the two- tailed test. Type
of t-test to perform: paired (1), equal variance
(homoscedastic) (2), or unequal variance
(heteroscedastic) (3).
VAR(number_1;
number_2; ... number_30)
Estimates the variance based on a sample.
Number_1; number_2; ... number_30 are
numerical values or ranges representing a
sample based on an entire population.
VARA(value_1; value_2; ...
value_30)
Estimates a variance based on a sample. The
value of text is 0. Value_1; value_2; ...
value_30 are values or ranges representing a
sample derived from an entire population. Text
has the value 0.
VARP(Number_1;
number_2; ... number_30)
Calculates a variance based on the entire
population. Number_1; number_2; ...
number_30 are numerical values or ranges
representing an entire population.
VARPA(value_1; value_2; ..
.value_30)
Calculates the variance based on the entire
population. The value of text is 0. Value_1;
value_2; ... value_30 are values or ranges
representing an entire population.
WEIBULL(number; alpha;
beta; C)
Returns the values of the Weibull distribution
for the given Number. Alpha is the Alpha
parameter of the Weibull distribution. Beta is
the Beta parameter of the Weibull distribution.
C indicates the type of function: C= 0 the form
of the function is calculated, C=1 the
distribution is calculated.
ZTEST(data; number;
sigma)
Returns the two-tailed P value of a z test with
standard distribution. Data is the array of the
data. Number is the value to be tested. Sigma
(optional) is the standard deviation of the total
population. If this argument is missing, the
standard deviation of the sample is processed.
Date and time functions
Use these functions for inserting, editing, and manipulating dates and
times. OpenOffice.org handles and computes a date/time value as a
number. When you assign the number format “Number” to a date or
458 OpenOffice.org 3.x Calc Guide