How To

The Web Tab is a secure Java application launched on-site that enables users to design and generate cross-national descriptive tables based on the underlying LIS datasets without the need for programming.

Users must register to access the Web Tab.

Web Tabulator Tables

There are two types of cross-national descriptive tables: Univariate Statistics and Cross-Classified Statistics. Below you will find instructions for generating these tables.

Tables with Univariate Statistics

  1. Selecting the Dataset(s)
    • Click on the Define table pane.
    • Select a database (LIS).
    • Select the datasets level (Household).
    • Select/Deselect dataset(s) by left-clicking dataset(s) in the list of datasets pane.

    After making this selection, the available list of discrete, continuous, and weight variables for the selected datasets are displayed in their respective panes.

  2. Designing the Table
    If you are interested in getting frequencies:

    • Check (or drag) one or more discrete variables from the discrete variables pane.

    If you are interested in calculating statistics on continuous variables:

    • Check (or drag) one or more continuous variables from the continuous variables pane.
  3. Adjusting the Design of the Table by Choosing:
    • Whether weights should be applied.
    • How your data should be sorted.
    • The number of decimals you desire (between 0 and 4).
    • Whether figures are calculated including or excluding zero values. This option is only available when calculating statistics on continuous variables.
    • Whether figures are calculated including or excluding missing/not applicable values. This option is only available when calculating statistics on discrete variables.

    Notes

    • Click on rotate table to transpose your results.
    • Click on reset all to start over with a new table.
  4. Displaying and/or Exporting the Results
    Click on the final results tab to see the results. Note that results based on fewer than 15 observations are not presented (signified by ***).

    Results can be exported in:

    • ASCII/plain text format by clicking on save in clipboard and paste (CTRL+v) the table into an editor.
    • Excel format by clicking on save as spreadsheet.

Tables with Cross-Classified Statistics

  1. Selecting the Dataset(s)
    • Click on the Define tab pane.
    • Select a database (LIS).
    • Select the datasets level (Household).
    • Select/Deselect dataset(s) by left-clicking dataset(s) in the list of datasets pane.

    After making this selection, the available list of discrete and outcome variables for the selected datasets are displayed in their respective panes.

  2. Designing the Table
    If you are interested in getting cross-tabulated frequencies.

    • Drag a discrete variable in the table row-zone.
    • Drag a discrete variable in the table col-zone.
    • In the table design pane, define the content of the cell by choosing the type of statistics (frequencies count, frequencies percentage, row percentage, column percentage).
  3. Calculating Statistics on Continuous Variables
    • Drag a discrete variable in the table row-zone.
    • Drag a discrete variable in the table col-zone.
    • Drag (or check) outcome variable(s) in the table data-zone.
    • In the table design pane, define the content of the cell by choosing the type of statistics (mean, standard deviation, median).
  4. Adjusting the Design of the Table by Choosing:
    • Whether weights should be applied.
    • Whether figures are calculated including or excluding zero values. This option is only available when calculating statistics on continuous variables.
    • Whether figures are calculated including or excluding missing/not applicable values. This option is only available when calculating statistics on discrete variables.
    • The number of decimals you desire (between 0 and 4).
    • Whether you want to display totals.

    Notes

    • Click on rotate table to transpose your results.
    • Click on reset all to start over with a new table.

    Warnings

    If you change the selection of one or more discrete or continuous variables, or number of decimals, etc., the table design remains unchanged. However, because the number of available variables varies across datasets, the table must be redesigned if the selection of datasets changes.

  5. Displaying and/or Exporting the Results
    Click on the final results tab to see the results.
    Note that results based on fewer than 15 observations are not presented (indicated by ***). Results can be exported in:

    • The ASCII/plain text format by clicking on save in clipboard and paste (CTRL+v) the table into an editor.
    • Excel format by clicking on save as spreadsheet.