Microsoft Excel 2013 Inside Out

Chapter 17. Functions for analyzing statistics

• Analyzing distributions of data

• Understanding linear and exponential regression

• Using the Analysis Toolpak data analysis tools

MICROSOFT EXCEL provides a wide range of features that can help you perform statistical analyses of your data. A number of functions that assist in simple analysis tasks—such as AVERAGE, MEDIAN, and MODE—are built into the program. If the built-in statistical functions aren’t enough, you can turn to the Analysis Toolpak, an add-in that provides a collection of tools that augment the built-in analytical capabilities of Excel. You can use these tools to create histograms and rank-and-percentile tables, extract samples from a data set, perform regression analysis, generate special ...