Adding summary statistics to a grid

Survey Tabulation > Working with variables > 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. See Adding summary statistics to a categorical variable for more information.

These instructions describe how to create a mean in a grid variable so that it applies to all tables that use the variable. If you want to create the mean in a specific table, see Creating your first grid table first, and then use the Edit Axis dialog box instead of the Edit Variable dialog box. The steps within the dialog box are the same. See Edit Axis dialog box for more information.

1 In the main UNICOM Intelligence Reporter - Survey Tabulation window, select the Define tab.

2 In the Variable List, expand the grid or loop.

3 Select the variable that is inside the grid or loop. This variable is often called Column.

4 From the menu, choose Variables > Edit.

This opens the Edit Variable dialog box: see Edit Variable dialog box.

5 Select the item in front of which you want the mean to appear. To add the mean at the end, do not select anything.

6 From the menu at the top of the Edit tab, choose Insert.

This opens the Insert Item dialog box: see Insert Item dialog box.

7 In the list of Available Items, select Mean.

8 Click Add.

9 Click OK.

This inserts the mean into the list of items on the Edit tab and automatically assigns factors to all of the categories, including user-defined categories, in the list. A factor of 1 is assigned to the first one, a factor of 2 to the second one, etc. However, you can change the factors if necessary. See Adding summary statistics to a categorical variable for more information.

10 Click OK.

11 Create a table using the grid variable. See Creating your first grid table for more information.

Note The changes will be applied to any existing tables that include the variable next time you populate them (provided you have not used the Edit Axis dialog box to specify how the variable is to appear in any of those tables).