Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Functions for analyzing statistics
CHAPTER 17
Functions for analyzing statistics
Analyzing distributions of data ....................601
Understanding linear and exponential regression ....608
Using the Analysis Toolpak data analysis tools .......616
MICROSOFT E XCEL 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 random-number sets,
apply Fourier and other transformations to your data, and more. In this chapter, we explore
the most important statistical-analysis functions that are built into Excel, as well as those
included with the Analysis Toolpak.
Analyzing distributions of data
In statistics, a collection of measurements is called a distribution . Excel has several methods
you can use to analyze distributions: built-in statistical functions, the sample and
population statistical functions, and the rank-and-percentile functions together with the Rank And
Percentile tool.
Note
You can also analyze distributions using the Descriptive Statistics and Histogram tools,