O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required