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
Search JabSto ::




Custom Search