Chapter 17. Functions for Analyzing Statistics
Analyzing Distributions of Data
Understanding Linear and Exponential Regression
Using the Analysis Toolpak Data Analysis Tools
MICROSOFT Excel 2010 provides a wide range of features that can help you perform statistical analysis 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 2010. You can use these tools to create histograms and rank-and-percentile tables, extract samples from a data set, perform regression analysis, generate ...
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.