Download Spreadsheets 2013

Spreadsheets 2013 User Manual
Function Name
Explanations
cumulative distribution.
PEARSON (array 1, array 2)
Returns the Pearson product moment correlation
coefficient.
PERCENTILE (array, percent)
PERCENTRANK
(array,
Returns the k-th percentile of values in a range.
number, Returns the rank of a value in a data set as a
num_digits)
percentage (0..1, exclusive) of the data set.
PERMUT (number, number_chosen)
Returns the number of permutations for a given
number of objects.
POISSON (number, arithmetic average, Returns the Poisson distribution.
return
the
cumulative
distribution
function )
PROB (x_range, prob_range, lower Returns the probability that values in a range are
bound of the x range, upper bound of between two limits.
the x range)
QUARTILE (array, quartile)
Returns the quartile of a data set.
RANK (number, ref, order)
Returns the rank of a number in a list of
numbers.
RSQ (known_y’s, known_x’s)
Returns the square of the Pearson product
moment correlation coefficient.
SKEW (number 1, number 2)
Returns the skewness of a distribution.
SLOPE (known_y’s, known_x’s)
Returns the slope of the linear regression line.
SMALL (array, k)
Returns the k-th smallest value in a data set.
STANDARDIZE (number, arithmetic Returns a normalized value.
average, standard deviation)
STDEV (number 1, number 2, ...)
calculates standard deviation based on a sample
(ignore text values and logical values).
STDEVA (number 1, number 2)
Estimates standard deviation based on a sample,
including numbers, text, and logical values.
134