Selecting and Sorting Cases

The first task is to select only those homes selling for $335,000 or more. From the Data Editor menus choose:

Data > Select Cases...

Figure 1. Select Cases dialog box
Select Cases dialog box with If condition is satisfied option selected
  1. Select If condition is satisfied.
  2. Click If.
    Figure 2. If dialog box for case selection
    If dialog box for defining conditions for case selection
  3. Select Purchase Price. Note that the variable name, value, is pasted in the Expression area.
  4. Select ">=" on the calculator pad.
  5. To complete the expression, type 335000.
  6. Click Continue.
  7. Click OK in the Select Cases dialog box.

    Next, sort the selected homes by their value and length of time on the market. This will order the case listings in the Summarize table.

  8. To sort the data, from the Data Editor menus choose:

    Data > Sort Cases...

    Figure 3. Sort Cases dialog box
    Sort Cases dialog box for selecting variables to sort by
  9. Select Purchase Price as the first variable to sort by.
  10. Select Descending as the sort order.
  11. Select Days on the Market Before Sold as the second variable. Note that it, too, will be sorted in descending order.
  12. Click OK.

Next