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.

 

Advanced Tables - Editing

• Use the censor tables extension

• Use the modify tables extension