Calc Guide

Statistical analysis functions
Calc includes over 70 statistical functions which enable the evaluation of data from
simple arithmetic calculations, such as averaging, to advanced distribution and
probability computations. Several other statistics-based functions are available
through the Add-ins which are noted at the end of this appendix.
Table 37: Statistical analysis functions
Syntax Description
AVEDEV(number1;
number2; ... number_30)
Returns the average of the absolute deviations of
data points from their mean. Displays the diffusion in
a data set. Number_1; number_2; ... number_30
are values or ranges that represent a sample. Each
number can also be replaced by a reference.
AVERAGE(number_1;
number_2; ... number_30)
Returns the average of the arguments. Number_1;
number_2; ... number_30 are numerical values or
ranges. Text is ignored.
AVERAGEA(value_1;
value_2; ... value_30)
Returns the average of the arguments. The value of a
text is 0. Value_1; value_2; ... value_30 are values
or ranges.
B(trials; SP; T_1; T_2) Returns the probability of a sample with binomial
distribution. Trials is the number of independent
trials. SP is the probability of success on each trial.
T_1 defines the lower limit for the number of trials.
T_2 (optional) defines the upper limit for the number
of trials.
BETADIST(number; alpha;
beta; start; end)
Returns the cumulative beta probability density
function. Number is the value between Start and
End at which to evaluate the function. Alpha is a
parameter to the distribution. Beta is a parameter to
the distribution. Start (optional) is the lower bound
for number. End (optional) is the upper bound for
number.
BETAINV(number; alpha;
beta; start; end)
Returns the inverse of the cumulative beta
probability density function. Number is the value
between Start and End at which to evaluate the
function. Alpha is a parameter to the distribution.
Beta is a parameter to the distribution. Start
(optional) is the lower bound for number. End
(optional) is the upper bound for number.
BINOMDIST(X; trials; SP; C) Returns the individual term binomial distribution
probability. X is the number of successes in a set of
trials. Trials is the number of independent trials. SP
is the probability of success on each trial. C = 0
calculates the probability of a single event and C = 1
calculates the cumulative probability.
Appendix B Description of Functions 393