Adding summary statistics to a grid
Grid questions frequently ask respondents to choose a rating on a predefined scale for a number of products in a list. You can add summary statistics to these questions, for example, a mean to show the average rating, just like you can in any other categorical variable.
To add summary statistics to a grid
1 In the Variables pane, expand the grid or loop.
2 Select the variable that is inside the grid or loop. This variable is often called Column.
3 From the menu, choose Variables > Edit Variable.
This opens the Edit Variable window and displays a list of the categories in the variable.
4 Select the item after which you want the mean to appear.
5 From the menu, choose Categories > Insert Categories.
This opens the Insert Categories dialog box.
6 In the list of Available Items, select the summary statistic that you want to use. For example, select Mean or Standard Deviation.
7 Click the >> button to add it to the list of items to insert.
8 If required, edit the default description and decimal places for the inserted item.
9 Click OK to close the Insert Categories dialog box.
This inserts the statistic into the list of items in the variable. The statistic will be calculated based on factors assigned to the categories in the variable. To add factors:
10 In the Edit Variable dialog box menu, choose Categories > Add Factors.
11 In the Add Factors dialog box, enter a starting value and an increment, and 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.
12 Choose Save and Close from the toolbar.
See also