Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 133

but you can use the one supplied with the StatPlus add-in. Use StatPlus

now to create a frequency table of the home prices in the Housing Statistics

workbook.

To create a frequency table of home prices:

1 Click Descriptive Statistics from the StatPlus menu on the Add-Ins

tab and then click Frequency Tables.

2 Click the Data Values button, click the Use Range Names option

button, and click Price. Click the OK button.

The Frequency Table command gives you three options for organiz-

ing your table. You can use discrete values so that the table is tabu-

lated over individual price values, or you can organize the values

into bins (you’ll learn about bins shortly). For now, leave Discrete as

the selected option.

3 Click the Output button, click the New Worksheet option button,

and type Price Table in the New Worksheet name box. Click the OK

button.

4 Click OK to start generating the frequency table. Figure 4-2 displays

the completed table.

Figure 4-2
Frequency of
housing prices