Rank Cases

When you choose Ranks as the binning method, a new set of options is displayed in the dialog box.

Ranking creates new fields containing ranks, fractional ranks, and percentile values for numeric fields depending on the options specified below.

Rank order. Select Ascending (lowest value is marked 1) or Descending (highest value is marked 1).

Rank. Select to rank cases in ascending or descending order as specified above. The range of values in the new field will be 1–N, where N is the number of discrete values in the original field. Tied values are given the average of their rank.

Fractional rank. Select to rank cases where the value of the new field equals rank divided by the sum of the weights of the nonmissing cases. Fractional ranks fall in the range of 0–1.

Percentage fractional rank. Each rank is divided by the number of records with valid values and multiplied by 100. Percentage fractional ranks fall in the range of 1–100.

Extension. For all rank options, you can create custom extensions and specify whether the extension is added to the start (Prefix) or end (Suffix) of the field name. For example, you could generate a new field called income_P_RANK.