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

As you can see from Figure 5.5, the sample range equals 7 meals, the sample variance equals 6.7, ...

Start Free Trial

No credit card required