546
VAR VAR(number1, number2,.. .) returns the sample
variance of up to 30 numbers (or an array or
reference).
VARP VARP(number1, number2,.. .) returns the
population variance of up to 30 numbers (or an
array or reference).
Descriptive Statistics for Two or More
Variables
Function Name Description
CORREL CORREL(array1, array2) returns the coeffi cient of
correlation between array1 and array2.
COVAR COVAR(array1, array2) returns the covariance of
array1 and array2.
PEARSON PEARSON(array1, array2) returns the Pearson
correlation coeffi cient between array1 and array2.
RSQ RSQ(known-y’s, known-x’s) returns the square of
Pearson’s product moment correlation coeffi cient.
SUMPRODUCT SUMPRODUCT(array1, array2,.. .) returns the sum
of the products of corresponding entries in up to 30
arrays.
SUMX2MY2 SUMX2MY2(array1, array2) returns the sum of the
differences of squares of corresponding entries in
two arrays.
SUMX2PY2 SUMX2PY2(array1, array2) returns the sum of the
sums of squares of corresponding entries in two
arrays.
SUMXMY2 SUMXMY2(array1, array2) returns the sum of the
squares of differences of corresponding entries in
two arrays.
Distributions
Function Name Description
BETADIST BETADIST(x, alpha, beta, a, b) returns the value of
the cumulative beta probability density function.
BETAINV BETAINV(p, alpha, beta, a, b) returns the value
of the inverse of the cumulative beta probability
density function.
