O'Reilly logo

The Complete Idiot's Guide to Statistics, 2nd Edition by Robert Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Excel to Calculate Measures of Dispersion

Excel enables you to conveniently calculate the range, variance, and standard deviation of a sample using the Data Analysis selection under the Tools menu. Use the exact same steps to calculate these measures as those used to calculate measures of central tendency shown in Chapter 4. Repeating those steps (see the section “Using Excel to Calculate Central Tendency”) with the grilling example from this chapter will produce Figure 5.5.
Figure 5.5
Measures of dispersion for the turbo grill example.
141
As you can see from Figure 5.5, the sample range equals 7 meals, the sample variance equals 6.7, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required