How to summarize repeating categories

Suppose you have categories that repeat in C1 with their corresponding numeric values in C2. You can summarize each category and list them one time without manually deleting each additional entry.

  1. Choose Stat > Basic Statistics > Store Descriptive Statistics.
  2. In Variables, enter C2.
  3. In By variables (optional), enter C1.
  4. Click Statistics.
  5. Select Mean, and deselect N nonmissing.
  6. Click OK in each dialog box.

The list of categories and their corresponding numbers will be stored in the next available columns in the active Worksheet.