544
This section documents all the functions provided with Excel that are
relevant to statistics. So that you can more easily find the function you
need, similar functions are grouped together in six categories: Descriptive
Statistics for One Variable, Descriptive Statistics for Two or More
Variables, Distributions, Mathematical Formulas, Statistical Analysis, and
Trigonometric Formulas.
Descriptive Statistics for One Variable
Function Name Description
AVEDEV AVEDEV(number1, number2,.. .) returns the
average of the (absolute) deviations of the points
from their mean.
AVERAGE AVERAGE(number1, number2,.. .) returns the
average of the numbers (up to 30).
CONFIDENCE CONFIDENCE(alpha, standarddev, n) returns a
confi dence interval for the mean.
COUNT COUNT(value1, value2,.. .) returns how many
numbers are in the value(s).
COUNTA COUNTA(value1, value2,.. .) returns the count of
nonblank values in the list of arguments.
COUNTBLANK COUNTBLANK(range) returns the count of blank
cells in the range.
COUNTIF COUNTIF(range, criteria) returns the count of
nonblank cells in the range that meet the criteria.
DEVSQ DEVSQ(number1, number2,.. .) returns the sum of
squared deviations from the mean of the numbers.
FREQUENCY FREQUENCY(data-array, bins-array) returns the
frequency distribution of data-array as a vertical
array, on the basis of bins-array.
GEOMEAN GEOMEAN(number1, number2,.. .) returns the
geometric mean of up to 30 numbers.
HARMEAN HARMEAN(number1, number2,.. .) returns the
harmonic mean of up to 30 numbers.
KURT KURT(number1, number2,.. .) returns the kurtosis
of up to 30 numbers.
LARGE LARGE(array, n) returns the nth-largest value in
array.
MAX MAX(number1, number2,.. .) returns the largest of
up to 30 numbers.
Excel’s Math and Statistical
Functions
