Chapter 5

Deviating from the Average

IN THIS CHAPTER

check Finding out what variation is all about

check Working with variance and standard deviation

check Exploring Excel worksheet functions that calculate variation

check Using workarounds for missing worksheet functions

check Using additional worksheet functions for variation

Here are three pieces of wisdom about statisticians:

  • Piece of Wisdom #1: “A statistician is a person who stands in a bucket of ice water, sticks their head in an oven, and says, 'On average, I feel fine.'” (K. Dunning)
  • Piece of Wisdom #2: “A statistician drowned crossing a stream with an average depth of 6 inches.” (Anonymous)
  • Piece of Wisdom #3: “Three statisticians go deer hunting with bows and arrows. They spot a big buck and take aim. One shoots and his arrow flies off, ten feet to the left. The second shoots and his arrow goes ten feet to the right. The third statistician jumps up and down, yelling, 'We got him! We got him!'” (Bill Butz, quoted by Diana McLellan in Washingtonian ...

Get Statistical Analysis with Excel For Dummies, 5th Edition 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.