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.
Measures of dispersion for the turbo grill example.
As you can see from Figure 5.5, the sample range equals 7 meals, the sample variance equals 6.7, ...