Microsoft Office Tutorials and References
In Depth Information
CHAPTER 11 Statistical Functions
11
CHAPTER
Statistical Functions
Statistical Functions Overview
Statistical functions are among the most widely used functions in Excel. You can
calculate the average of a group of numbers and determine probabilities,
distributions, and trends. Each of the 80 statistical functions in Excel are described in
this chapter and most are accompanied by a figure to help illustrate the usage of
the function.
The following functions are discussed in this chapter.
AVEDEV
AVERAGE
AVERAGEA
BETAINV
BINOMDIST
CHIDIST
CHIINV
CHITEST
CONFIDENCE
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COVAR
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FREQUENCY
FTEST
GAMMAINV
GAMMALN
GEOMEAN
GROWTH
HARMEAN
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
POISSON
PROB
QUARTILE
RANK
RSQ
SKEW
SLOPE
SMALL
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
STEYX
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VARA
VARP
VARPA
WEIBULL
ZTEST
Search JabSto ::

Custom Search