Creating Tables

To create a table containing one or more of the variables from a survey dataset:

  1. Select a dataset from the browse list.
  2. Open it by clicking on survey.
  3. Click on the Tabulation tab, which is now active.
  4. Expand the Variable Description folder, and subsequent folders, to locate the survey variables.
  5. Select a variable by clicking on the variable name.
  6. Select one of the four variable menu options, e.g. add to row.
  7. Repeat this process for any other variables that are to be added to the table.

The variable menu options are:


[click to enlarge image]

Add to row and Add to column

These options will display the data as a frequency distribution for one variable, or a cross-tabulation for two or more variables. The table cells represent the frequency that particular categories, or combination of categories, occurred.

If more than one variable is added to a row or column, the variables will appear nested in the table as shown below.


  [click to enlarge image]

Use as filter

By using a variable as a filter, only one category of the chosen variable will be visible in the table at any one time. A 'variable' box will be created above the table which will display the currently selected category. This box can also be used to select other categories or to move the whole variable into the table so that all categories are displayed.

For information on how to use the drop-down boxes above the table please refer to Manipulate Tables.

Add as measure

It is also possible to add continuous variables, e.g. age, or a person's height measurement, to a table as a measure. For example, if a table contains 'Marital status' as the 'row' variable, and 'Gender' as the 'column' variable, and 'Age' is then added as a measure variable, the data displayed will represent the average age for each combination of 'Marital status' and 'Gender'.

A 'Measure' box will also become available from which other options are available, e.g. Min, Max, Count, etc. It is only possible to add one measure variable at a time, but the current selection can be changed simply by selecting a different variable from the browse list and adding it as a measure variable.

If a table is created containing only a 'measure' variable, statistical information will be displayed, e.g. Median, Mean, Standard deviation etc.


  [click to enlarge image]

Selecting variables from hierarchical files:

Variables can be selected from files at different hierarchical levels. For example, one variable can be selected from a household level file and another from an individual level file, and Nesstar will then merge the data to produce the analysis.

Note: Only files that are directly linked, i.e. are part of the same study, can be used in this way.