Creating tables using grid variables
Surveys frequently include grid questions. These typically ask respondents to choose a rating on a predefined scale for a number of products in a list. For example, the Museum sample survey contains a grid question called rating. It is generally easier to analyze data collected using a grid question as a grid table.
To create a table using a grid variable
1 From the menu, choose Tables > New > Table.
2 In the Variables pane, select the grid variable you want to use.
3 Click and drag the variable to the Add Grid button on the Design pane. The grid is added to the table.
4 Generate the table: click the Generate table button
.
Here is the table for the Rating grid question:
By default, the orientation of the grid table is taken from the definition of the grid question in the metadata. However, you can override the default orientation if required by choosing the Transpose Table button
.
To create multiple grid tables at the same time
1 Use Shift+click or Ctrl+click in the Variables pane to select the grid variables.
2 From the menu, choose Tables > New > Table For Each Selected Variable, or drag all the selected grid variables to the Add Grid/Loop button.
See also
