Special Edition Using® Microsoft® Office Excel 2003

Chapter 16. Statistical Functions

In this chapter

• Statistical Functions Overview

• AVERAGE

• BINOMDIST

• CHIDIST

• CONFIDENCE

• CORREL

• COUNT

• COVAR

• EXPONDIST

• FDIST

• FORECAST

• FREQUENCY

• GEOMEAN

• GROWTH

• INTERCEPT

• LARGE

• LINEST

• LOGEST

• MAX

• MEDIAN

• MIN

• MINA

• MODE

• NORMDIST

• NORMINV

• PERCENTILE

• PERCENTRANK

• POISSON

• RANK

• SLOPE

• SMALL

• STDEV

• STDEVA

• TREND

• VAR

• VARA

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. For example, the BETADIST function is used to measure variations in the percentage of a particular variable across samples. This chapter describes 38 of the 81 statistical functions in Excel and most are accompanied by an example to help illustrate ...