14. Using Statistical Functions
Statistics in Excel fall into three broad categories:
• Descriptive statistics that describe a data set—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 14.1. Alphabetical List of Statistical Functions