Calc Guide

Syntax Description
POISSON(number; mean;
C)
Returns the Poisson distribution for the given
Number. Mean is the middle value of the
Poisson distribution. C = 0 calculates the
density function, and C = 1 calculates the
distribution.
PROB(data; probability:
start; end)
Returns the probability that values in a range
are between two limits. Data is the array or
range of data in the sample. Probability is the
array or range of the corresponding
probabilities. Start is the start value of the
interval whose probabilities are to be summed.
End (optional) is the end value of the interval
whose probabilities are to be summed. If this
parameter is missing, the probability for the
Start value is calculated.
QUARTILE(data; type)
Returns the quartile of a data set. Data is the
array of data in the sample. Type is the type of
quartile. (0 = Min, 1 = 25%, 2 = 50%
(Median), 3 = 75% and 4 = Max.)
RANK(value; data; type)
Returns the rank of the given Value in a
sample. Data is the array or range of data in
the sample. Type (optional) is the sequence
order, either ascending (0) or descending (1).
RSQ(data_Y; data_X) Returns the square of the Pearson correlation
coefficient based on the given values. Data_Y
is an array or range of data points. Data_X is
an array or range of data points.
SKEW(number_1;
number_2; ... number_30)
Returns the skewness of a distribution.
Number_1; number_2; ... number_30 are
numerical values or ranges.
SLOPE(data_Y; data_X) Returns the slope of the linear regression line.
Data_Y is the array or matrix of Y data.
Data_X is the array or matrix of X data.
SMALL(data; rank_c) Returns the Rank_c-th smallest value in a data
set. Data is the cell range of data. Rank_c is
the rank of the value (2nd smallest, 3rd
smallest, etc.) written as an integer.
STANDARDIZE(number;
mean; STDEV)
Converts a random variable to a normalized
value. Number is the value to be standardized.
Mean is the arithmetic mean of the
distribution. STDEV is the standard deviation
of the distribution.
456 OpenOffice.org 3.x Calc Guide