Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 153

7 Click the OK button to create the table of percentiles. Figure 4-16

shows the completed table.

Figure 4-16

Table of

percentiles

for the price

variable

The table of percentiles gives us some additional information about

the housing prices. The values are pretty close between the two locations

up to the 50th percentile, after which large differences begin to appear.

Figure 4-15
The Univariate
Statistics
dialog box