Microsoft® Office Excel 2003 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 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 module that provides a collection of functions and tools to augment the built-in analytic capabilities of Excel. You can use these tools to create histograms, rank-and-percentile tables, extract samples from a data set, perform regression analysis, generate special ...