Chapter 8

What’s Normal?

In This Chapter

arrow Meeting the normal distribution

arrow Working with standard deviations and the normal distribution

arrow Understanding Excel’s normal distribution-related functions

A main job of statisticians is to estimate population characteristics. The job becomes easier if they can make some assumptions about the populations they study.

One particular assumption works over and over again: A specific attribute, trait, or ability is distributed throughout a population so that most people have an average or near-average amount of the attribute, and progressively fewer people have increasingly extreme amounts of the attribute. In this chapter, I discuss this assumption and what it means for statistics. I also describe Excel functions related to this assumption.

Hitting the Curve

When you measure something in the physical world like length or weight, you deal with objects you can see and touch. Statisticians, social scientists, market researchers, and businesspeople, on the other hand, often have to measure something they can’t see or put their hands around. Traits like intelligence, musical ability, or willingness to buy a new product fall into this category.

These ...

Get Statistical Analysis with Excel For Dummies, 3rd Edition now with O’Reilly online learning.

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