Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 163

7 Click the OK button to create the table. Figure 4-23 shows the vari-

ability statistics generated from the Univariate Statistics command.

Figure 4-22
Selecting
variability
statistics
from the
Univariate
Statistics
dialog box

Figure 4-23

Variability

statistics

On the basis of the output from Figure 4-23, we note that the variability of

the 1993 Albuquerque home prices was higher in the northeast sector than

outside of it (though it’s interesting to note that the range of home prices

was higher for nonnortheast sector homes).