Calc Guide

Syntax Description
be determined with CHIDIST, in which case the
chi square of the random sample must then be
passed as a parameter instead of the data row.
Data_B is the array of the observations.
Data_E is the range of the expected values.
CONFIDENCE(alpha;
STDEV; size)
Returns the (1-alpha) confidence interval for a
normal distribution. Alpha is the level of the
confidence interval. STDEV is the standard
deviation for the total population. Size is the
size of the total population.
CORREL(data_1; data_2) Returns the correlation coefficient between
two data sets. Data_1 is the first data set.
Data_2 is the second data set.
COUNT(value_1;
value_2; ... value_30)
Counts how many numbers are in the list of
arguments. Text entries are ignored. Value_1;
value_2; ... value_30 are values or ranges
which are to be counted.
COUNTA(value_1;
value_2; ... value_30)
Counts how many values are in the list of
arguments. Text entries are also counted, even
when they contain an empty string of length 0.
If an argument is an array or reference, empty
cells within the array or reference are ignored.
value_1; value_2; ... value_30 are up to 30
arguments representing the values to be
counted.
COVAR(data_1; data_2) Returns the covariance of the product of
paired deviations. Data_1 is the first data set.
Data_2 is the second data set.
CRITBINOM(trials; SP;
alpha)
Returns the smallest value for which the
cumulative binomial distribution is less than or
equal to a criterion value. Trials is the total
number of trials. SP is the probability of
success for one trial. Alpha is the threshold
probability to be reached or exceeded.
DEVSQ(number_1;
number_2; ... number_30)
Returns the sum of squares of deviations based
on a sample mean. Number_1; number_2; ...
number_30 are numerical values or ranges
representing a sample.
EXPONDIST(number;
lambda; C)
Returns the exponential distribution. Number
is the value of the function. Lambda is the
parameter value. C is a logical value that
determines the form of the function. C = 0
Appendix B Description of Functions 451