top of page

### Interactive data visualization

Goals:

Deepen the knowledge of Statistics Tables in all its potential for reporting and data analysis

â€‹

Techniques presented:

All the main advanced and customized reporting techniques will be illustrated, such as tiling, nesting and stratification, the calculation of new categories, multiple choice sets and statistical tests

â€‹

Tutorials:

There are exercises for each of the topics covered.

â€‹

Prerequisites:

Attendance at the INTRO course or having an intermediate knowledge of Statistics for Data Analysis is a prerequisite

â€‹

Subjects:

• Introduction to Custom Tables

• The structure of the tables and the terminology used.

• Measurement level of the variables

Basic elements of tables

• The basic components of the table generator interface.

• The basic characteristics of summary statistics, categories and totals.

• Tables for categorical variables.

• Create a cross-tab.

• Check labels and display formats of summary statistics

• Tiling, Nesting and Statification

• Create tables with side by side (stacking).

• Create nested tables.

• Create tables with layers.

• Tables for scale variables.

• Tiling of  scale variables-

• Create tables for summary statistics of scale variables grouped into categories.

• Use of summary statistics for different scale variables.

Totals, Subtotals and Categories

• Create totals and subtotals for categorical variables.

• Hide categories for subtotals.

• Sort and exclude categories.

Calculate new Categories

• Calculate the differences as part of the Custom Tables procedure.

• Calculate ratios as part of the Custom Tables procedure.

• Calculate percentages as part of the Custom Tables procedure.

• Nest tables with shared categories.

Tables for variables with shared categories

• Get summary statistics and totals for tables with shared categories.

• Create tables with percentages and averages.

Multiple choice sets

• Defining multiple response sets in Statistics for Data Analysis.

• Create tables with multiple response sets in custom tables.

• Create co-occurrence tables of multiple response sets in custom tables.

• Create tables with multiple response sets and other variables.

Statistics Tests

• Use statistical tests to verify the independence of the variables.

• Use statistical tests for comparing column proportions.

• Use statistical tests to compare column means.

Formatting and editing tables within Custom Tables

• Change data cell appearance.

• Hide cells with low values.

• Add titles, captions and corner texts to tables.

Formatting and editing Tables outside Custom Tables

• Use the features of the Pivot Table Editor.

• Change cell and table properties.

• Change the default TableLook applied to tables.

Missing values

• The default handling of missing values.

• Include missing values in tables.

• Get totals net of missing values.

Moving tables from other software

• Using the clipboard to export output to other applications.

• Using the Export Tool for PivotTables.

• Use of the OMS (Output Management System) functionality to manage the export of the statistics tables obtained in Statistics for Data Analysis.

Introduction to the Syntax for Custom Tables

• Syntax creation and execution.

• Description and use of the features of the Syntax Editor.

Using syntax for recurring analysis

• Produce multiple tables using syntax.

• Make simple syntax changes.

• Get the syntax from the journal file.

• Describe and use the features of the Production Job dialog.

Special tables for objective

• Create tables for comparing specific groups.

• Create tables for the differences between the variables.

• Create tables for aspect ratios (ratios)

• Create tables for differences in count variables.

Table recommendations

• Initial placement of variables.

• Create tables with percentages and averages.

• Create charts from tables and view large tables.