Chapter 26. Using Statistical Functions
In this chapter
Examples of Functions for Descriptive Statistics 642
Examples of Functions for Regression and Forecasting 658
Examples of Functions for Inferential Statistics 682
Using the Analysis Toolpak to Perform Statistical Analysis 711
Statistics in Excel fall into three broad categories:
- Descriptive statistics that describe a dataset—These include measures of central tendency and dispersion.
- Regression tools—These allow you to predict future values based on past values.
- Inferential statistics—This type of statistic allows you to predict the likelihood of an event happening, based on a sample of a population.
Table 26.1 provides an alphabetical list of all of Excel 2007’s statistical functions. ...