Chapter 17. Functions for Analyzing Statistics

Microsoft Office Excel 2007 provides a wide range of features that can help you analyze statistical 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 to augment the built-in analytical capabilities of Office Excel 2007. You can use these tools to create histograms, create rank-and-percentile tables, extract samples from a data set, perform regression analysis, generate ...

Get Microsoft® Office Excel® 2007 Inside Out now with O’Reilly online learning.

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