AVERAGE | arithmetic mean |
CHITEST | probability from the chi-square test, given observed and expected values |
CONFIDENCE | confidence interval for a population mean, given confidence level, standard deviation, and sample size |
CORREL | correlation coefficient, given two lists of values |
COUNT | number of items with numeric values |
FREQUENCY | frequency distribution from a set of values |
MAX | largest numeric value in a set |
MEDIAN | median |
MIN | smallest numeric value in a set |
MODE | mode |
PERCENTILE | kth percentile, given k and a set of values |
QUARTILE | kth quartile, given k and a set of values |
RANK | rank of a value in a set |
STDEV | estimate of population standard deviation from sample set |
STDEVP | standard deviation |
TTEST | probability from t-test, given two data sets, number of tails (1 or 2), and type (paired, or two-sample equal or unequal variance) |
VAR | estimate of population variance from sample set |
VARP | variance |
To access any of these functions except FREQUENCY, do the following.
(To specify a set of values in an Excel formula, indicate the first and last cell in the range separated by a colon; e.g., a1:a10.)
The procedure for FREQUENCY is a bit more complicated:
These are referred to as bins. Generally, make the highest value in the series equal to or greater than the maximum value in the set of values for which you want a distribution.