Desktop User Guides > Reporter > Using variables > Editing variables > Adding summary statistics to a categorical variable
 
Adding summary statistics to a categorical variable
You can add a summary statistic to a categorical variable, for example, to show the mean score in a rating question. When you do this, by default the statistic is calculated on the basis of factors associated with the categories. Alternatively, you can base the calculation on a specific numeric variable.
A factor is a constant numerical value that is assigned to a category for use in statistical calculations. Factors are used when you want to base a statistic on the categories in a categorical variable rather than on a numeric variable. This is because statistics can be calculated on numeric data only and categories are not true numeric values. (Although the UNICOM Intelligence Data Model represents the responses to categorical questions as numeric values, these are in fact identifiers or codes and are not suitable for statistical analysis.)
To add a summary statistic to a categorical variable for all tables
1 In the Variables pane, select the categorical variable, and then click Variables > Edit Variable.
This opens the Edit Variable window.
2 Select the item after which you want the summary statistic to appear.
3 Click Categories > Insert Categories.
The Insert Categories dialog opens.
4 In the list of Available Items, select the summary statistic that you want to use. For example, select Mean or Standard Deviation.
5 Click the >> button to add it to the list of items to insert.
6 If required, edit the default description and decimal places for the inserted item.
7 Click OK to close the Insert Categories dialog.
This inserts the statistic into the list of items in the variable. By default, the statistic will be calculated based on factors assigned to the categories in the variable. To add factors:
8 In the Edit Variable dialog menu, choose Categories > Add Factors.
9 In the Add Factors dialog, enter a starting value and an increment, and then click OK.
Factors are assigned to each category in the variable. The order in which the categories appear in the list determines the order in which the increments are applied.
10 Choose Save and Close from the toolbar.
See also
Editing variables