Calc Guide

Syntax Description
TTEST(data_1; data_2; mode;
type)
Returns the probability associated with a Student’s t-
Test. Data_1 is the dependent array or range of data
for the first record. Data_2 is 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.
400 OpenOffice.org 3.3 Calc Guide