Chapter 17. Functions for analyzing statistics

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

Get Microsoft Excel 2013 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.