Chapter 10

Descriptive Statistics

In This Chapter

arrow Using the Descriptive Statistics tool

arrow Creating a histogram

arrow Ranking by percentile

arrow Calculating moving averages

arrow Using the Exponential Smoothing tool

arrow Sampling a population

In this chapter, I describe and discuss the simple descriptive statistical data analysis tools that Excel supplies through the Data Analysis add-in. I also describe some of the really simple-to-use and easy-to-understand inferential statistical tools provided by the Data Analysis add-in — including the tools for calculating moving and exponential averages as well as the tools for generating random numbers and sampling.

tip.eps Descriptive statistics simply summarizes large (sometimes overwhelming) data sets with a few, key calculated values. For example, when you say something ...

Get Excel Data Analysis For Dummies, 2nd Edition now with O’Reilly online learning.

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