Microsoft Office Tutorials and References

In Depth Information

**Statistical Functions**

Returns a subtotal from a list or database. It has 11 commands.

Subtotal can tally
AVERAGE
,
COUNT
,
COUNTA
,
MAX
,
MIN
,
PRODUCT
,

STDEV
,
STDEVP
,
SUM
,
VAR
, and
VARP
.

SUBTOTAL

Adds the numbers in a range of cells.

SUM

Adds the cells specified by criteria.

SUMIF

Multiplies corresponding components in the given array, and

returns the sum of those products.

SUMPRODUCT

Returns the sum of the squares of the arguments.

SUMSQ

Returns the sum of the difference of squares of corresponding

values in two arrays.

SUMX2MY2

Returns the sum of the sum of squares in corresponding values

in two arrays.

SUMX2PY2

Returns the sum of squares of differences of corresponding

values in two arrays.

SUMXMY2

Returns the tangent of the given angle.

TAN

Returns the hyperbolic tangent of number.

TANH

Truncates number to an integer, removing the fractional part of

the number.

TRUNC

Statistical Functions

AVEDEV

Returns the average of the absolute deviations of data points from

their mean.

Returns the average of the arguments.

AVERAGE

Calculates the average of the values in the list of arguments.

AVERAGE A

Returns the cumulative beta probability density function.

BETADIST

Returns the inverse of the cumulative beta probability density

function.

BETAINV

Returns the individual term binomial distribution probability.

BINOMDIST

Returns the one-tailed probability of the chi-squared distribution.

CHIDIST

Returns the inverse of the one-tailed probability of the chi-squared

distribution.

CHINV

Returns the test for independence.

CHITEST

Returns the confidence inter val for a population mean.

CONFIDENCE

Returns the correlation coefficient of the array1 and array2 cell

ranges.

CORREL

Counts the number of cells that contain numbers within the list of

arguments.

COUNT