December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...