Calc Guide

Syntax Description
PEARSON(data_1; data_2) Returns the Pearson product moment correlation
coefficient r. Data_1 is the array of the first data set.
Data_2 is the array of the second data set.
PERCENTILE(data; alpha) Returns the alpha-percentile of data values in an
array. Data is the array of data. Alpha is the
percentage of the scale between 0 and 1.
PERCENTRANK(data; value) Returns the percentage rank (percentile) of the given
value in a sample. Data is the array of data in the
sample.
PERMUT(count_1; count_2) Returns the number of permutations for a given
number of objects. Count_1 is the total number of
objects. Count_2 is the number of objects in each
permutation.
PERMUTATIONA(count_1;
count_2)
Returns the number of permutations for a given
number of objects (repetition allowed). Count_1 is
the total number of objects. Count_2 is the number
of objects in each permutation.
PHI(number) Returns the values of the distribution function for a
standard normal distribution for the given Number.
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.
398 OpenOffice.org 3.3 Calc Guide