How to Change a Variable Set From Displaying Percentages to Averages

This article describes how to go from displaying individual categories and percentages for a categorical variable set:

To display an average for each variable: 

Requirements

• Familiarity with the Structure and Value Attributes of Variable Sets.
• A categorical (Nominal or Ordinal) variable set that contains meaningful underlying numeric values. For example, a 1-5 scale question for multiple brands. 

Method - Automatically Restructure

1. Select the variable set in the Data Sources tree.
2. OPTIONAL: If you want to keep the original variable set intact, you can create a duplicate copy of the variable first by right-clicking and selecting Duplicate.
3. For Nominal - Multi: Grid or Ordinal - Multi: Grid variables:
   From Properties , click Data > Modify Variable Set > Restructure > Averages Grid.
   
   For Nominal or Ordinal variables:
   From Properties , click Data > Modify Variable Set > Restructure > Averages.

Method - Manually Restructure

1. Select the variable set in the Data Sources tree.
2. OPTIONAL: If you want to keep the original variable set intact, you can create a duplicate copy of the variable first by right-clicking and selecting Duplicate.
3. In Properties , go to Data > Attributes > Structure > to the appropriate Numeric structure per Variable Sets.

Next

How to Change a Variable Set From Displaying Averages to Percentages

Manipulating Data Video