How to Change a Variable Set From Displaying Averages to Percentages

Sometimes with scaled questions or numeric variables, you may want to bucket ranges or see a breakdown of the proportion of people giving certain scores. By default, Numeric Variables Sets show the Average in tables created, but if you'd like to see percentages of the different proportions, you can change the Structure to a Nominal or Binary variable set. This article describes how to go from displaying averages for each variable in a table:

To a table displaying categories and percentages for each variable in the variable set: 

Requirements

• Familiarity with the Structure and Value Attributes of Variable Sets.
• A Numeric variable or Numeric - Multi variable set for which you want to display as categories and percentages for each numeric value. 

Method - Automatically Restructure

1. Select the variable or variable set in the Data Sources tree.
2. OPTIONAL: Right-click and select Duplicate if wanting to preserve a copy of the variable set shown as averages.
3. From the object inspector , click Data > Modify Variable Sets > Restructure > Percentages (if a numeric variable) or Percentages Grid (if a numeric - multi variable set).
4. OPTIONAL: If prompted, select the values to count and click OK.

Method - Manually Restructure

1. Select the variable or variable set in the Data Sources tree.
2. OPTIONAL: Right-click and select Duplicate if wanting to preserve a copy of the variable set shown as averages.
3. In the object inspector , change the Structure to the appropriate Nominal or Ordinal structure per Variable Sets. Note if you'd like to see the proportion of select scores (like a top or bottom box), you can also change Structure > Binary-Multi and click Fix to check Count this Value on values to include in the proportion.

Next

How to Change a Variable Set From Displaying Percentages to Averages

Manipulating Data Video