IBM SPSS Custom Tables

Business Analytics

IBM Software

Create custom tables in no time

You often report the results of your analyses to decision makers,

colleagues, clients, grant committees or others. Building tabular

reports, however, can be a time-consuming, trial-and-error process.

IBM

SPSS

Custom Tables enables you to view your tables as you

build them, so you can create polished, accurate tables in less time.

SPSS Custom Tables makes it easy for you to summarize your IBM

SPSS Statistics data in dierent styles for dierent audiences. Its

build-as-you-go interface updates in real time, so you always know

what your tables will look like. You can add descriptive and inferential

test statistics, for example, and then customize the table so your

audience can easily understand the information. When your tables are

complete, you can export them to Word, Excel and PowerPoint, as well

as HTML.

This software is ideal for anyone who creates and updates reports on

a regular basis, including people who work in survey or market research,

the social sciences, database or direct marketing and institutional research.

Highlights

• Build tables quickly and easily using

drag-and-drop functionality.

• Preview tables as you build them and

make changes in real time.

• Exclude specific categories, display

missing value cells, add subtotals to your

table, and more.

• Easily export tables to Microsoft Word,

Microsoft Excel or Microsoft PowerPoint

for use in reports.

• Automate the reports you use frequently.

SPSS Custom Tables oers features that make it easier than

ever to deliver information your colleagues can act on without

further processing. These capabilities include:

• Calculated output ﬁelds – Save time and eort by creating

new ﬁelds directly in your Custom Tables output, and using

them to perform calculations (e.g., sum, dierence,

percentage dierence) on output categories.

• Signiﬁcance test results in the output – The results of

signiﬁcance tests are shown directly in SPSS Custom Tables

output instead of in a separate table, removing the need to

combine ﬁndings manually.

• An interactive table builder – Preview your tables as you

create them.

• Category management – Exclude speciﬁc categories, display

missing value cells and add subtotals to your table

• Signiﬁcance tests – Chi-square test of independence,

comparison of column means (t test) or comparison of

column proportions (z test).

• Easy export of tables to Word, Excel or PowerPoint for use

in reports.

This product is available for installation as client-only

software but, for greater performance and scalability, it

can also be used in a client/server installation.

Preview tables as you build them

The SPSS Custom Tables intuitive graphical user interface

takes the guesswork out of building tables. Its drag-and drop

capabilities and preview pane enable you to see what your

tables will look like before you click “OK.”

You can interact with the variables on your screen, identify

variables as categorical or scale values and know immediately

how your data are structured.

To create a table, just drag your desired variables into the

table preview builder. You don’t have to write complicated

syntax or work with dialog boxes. And you can move variables

easily from row to column for precise positioning. The table

preview builder updates after every change you make, so you

can see the formatting eect immediately. You can also add,

swap and nest variables, or hide variable labels, directly from

within the table preview builder. And you can collapse large,

complex tables for a more concise view, and still see your

variables.

Customize your tables

Display information the way you want to with the category

management features in SPSS Custom Tables. Create totals

and subtotals without changing your data ﬁle. You can

combine several categories into a single category, for example,

for frequent top- and bottom-box analyses. You can also sort

categories within your table without aecting the subtotal

calculation.

Make your tables more precise, as you create them, by

changing variable types or excluding categories. You can

display or exclude categories with no counts for clearer and

more concise output. Or sort and rank categories based on

cell values for a neater, more informative table.

Business Analytics

IBM Software

Figure 1: SPSS Custom Tables has an intuitive graphical user interface

that takes the guesswork out of building tables. Drag your desired

variables to the table builder. As shown in this screen, you can preview

the category list (lower left corner) before dragging the desired

categories to the table.

IBM SPSS Custom Tables

Get in-depth analyses

You can use SPSS Custom Tables as an analytical tool to

understand your data better and create tables that present

your results most eectively. Give your readers reports

that enable them to delve into the information and make

well-informed decisions.

Highlight opportunities or problem areas in your results

when you include inferential statistics. Using inferential test

statistics enables you to compare means or proportions for

demographic groups, customer segments, time periods or

other categorical variables. You can also identify trends,

changes or major dierences in your data.

You can also select summary statistics, which include

everything from simple counts for categorical variables to

measures of dispersion. Summary statistics for categorical

variables and multiple response sets include counts and a wide

variety of percentage calculations, including row, column,

subtable, table and valid N percentages. Summary statistics

for scale variables and custom total summaries for categorical

variables include mean, median, percentiles, sum, standard

deviation, range and minimum and maximum values. To focus

on speciﬁc results, you can sort categories by any summary

statistic you used.

Control your table output

Many time-saving features in SPSS Custom Tables help you

create tables with just the look you want. You can:

• Add titles and captions.

• Use table expressions in titles.

• Specify minimum and maximum column widths for

individual tables during table creation.

And, when used with IBM SPSS Statistics Base, you can access

additional features such as TableLooks

™

and scripts, which

allow you to automate formatting and other repetitive tasks.

Business Analytics

IBM Software

Figure 3: Multiple response set: Multiple response sets use multiple

variables to record responses to questions for which the respondent can

give more than one answer. When asked the question, “Which of the

following sources do you rely on for news,” respondents could select

any combination of five possible choices. Notice that the percentages

total more than 100 percent because each respondent may choose more

than one answer. You can also perform significance tests on multiple

response variables.

Figure 2: Two-dimensional crosstabulation: This example shows the

relationship between two categorical variables, Age and Gender. Using

Age as the row variable and Gender as the column variable, you can

create a two-dimensional crosstab that shows the number of males and

females in each age category.

IBM SPSS Custom Tables

Business Analytics

IBM Software

Share results more easily with others

Once you have results, you need to put them in the hands of

those who need them. SPSS Custom Tables enables you to

create results as interactive pivot tables for export to Word

or Excel. This not only improves your workﬂow, it saves time

because you don’t have to reconﬁgure your tables. No editing

is required after you export your tables. You can, however,

insert descriptive content if you choose to.

Save time and effort by automating

frequent reports

Do you regularly create reports that have the same structure?

Do you spend a lot of time updating reports? Use syntax and

automation in SPSS Custom Tables to run frequently needed

reports in production mode.

When you create a table, SPSS Custom Tables records every

click you make and saves your actions as syntax. To run

an automated report, you simply paste the relevant syntax

into a syntax window, then just click and go. With syntax

and automation, your report is ready quickly and easily.

New, ﬂexible implementation options

Our suite of statistical software is now available in three

editions: IBM SPSS Statistics Standard, IBM SPSS Statistics

Professional and IBM SPSS Statistics Premium. By grouping

essential capabilities, these editions provide an ecient way

to ensure that your entire team or department has the features

and functionality they need to perform the analyses that

contribute to your organization’s success.

Gain greater value with collaboration

To share and re-use assets eciently, protect them in ways

that meet internal and external compliance requirements, and

publish results so that a greater number of business users can

view and interact with them, consider augmenting SPSS

Custom Tables with IBM SPSS Collaboration and

Deployment Services. More information about these valuable

capabilities can be found at www.ibm.com/spss/cds.

Figure 4: Show significance test results in the output: The results of

significance tests can now be shown directly in SPSS Custom Tables

output instead of in a separate table, removing the need to combine

findings manually. In line with APA guidelines, values in the same row

with different subscripts are not significantly different (p>0.5).

IBM SPSS Custom Tables

Business Analytics

IBM Software

Features

Graphical user interface

• Simple, drag-and-drop table builder interface enables you to

preview tables as you select variables and options

• Single, uniﬁed table builder, instead of multiple menu

choices and dialog boxes for dierent table types, makes

building tables easier

Control contents

• Create tables with up to three display dimensions: Rows

(stub), columns (banner), and layers

• Nest variables to any level in all dimensions

• Crosstabulate multiple independent variables in the same

table

• Display frequencies for multiple variables side by side with

tables of frequencies

• Display all categories when multiple variables are included in

a table, even if a variable has a category without responses

• Display multiple statistics in rows, columns or layers

• Place totals in any row, column or layer

• Create subtotals for subsets of categories of a categorical

variable

• Perform calculations (e.g., sum, dierence, percentage

dierence) on output categories, and display the results in

new ﬁelds created directly in SPSS Custom Tables output

– No limit on the number of calculated ﬁelds

• Show signiﬁcance test results directly in the output instead

of in a separate table

– No need to combine ﬁndings in a Word document

– Complies with APA guidelines

• Customize your control over category display order and

selectively show or hide categories

• Better control how you display your data using expanded

category options:

– Sort categories by any summary statistic in your table

– Hide the categories that comprise subtotals – you can

remove a category from the table without removing it

from the subtotal calculation

Test statistics

• Select from these signiﬁcance tests:

– Chi-square test of independence

– Comparison of column means (t test)

– Comparison of column proportions (z test)

• Select from these summary statistics: Count, count row %,

count column %, count table %, count subtable %, layer %,

count table row %, count table column %, valid N row %,

valid N column %, valid N table %, valid N subtable %,

valid N layer %, valid N table row %, valid N table column

%, total N row %, total N column %, total N table %, total

N subtable %, total N layer %, total N table row %, total N

table column %, maximum, mean, median, minimum,

missing, mode, percentile, percentile 05, percentile 25,

percentile 75, percentile 95, percentile 99, range, standard

error (SE) mean, standard deviation (SD), sum, total N,

valid N, variance, sum row %, sum column %, sum table %,

sum subtable %, sum layer %, sum table row % and sum

table column %

• Calculate statistics for each cell, subgroup or table

• Calculate percentages at any or all levels for nested variables

• Calculate counts and percentages for multiple response

variables based on the number of responses or the number

of cases

• Select percentage bases for missing values to include or

exclude missing responses

• Exclude subtotal categories from signiﬁcance tests

• Run signiﬁcance tests on multiple response variables

IBM SPSS Custom Tables

Business Analytics

IBM Software

Formatting controls

• Directly edit any table element, including formatting and

labels

• Sort tables by cell contents in ascending or descending order

• Automatically display labels instead of coded values

• Specify minimum and maximum width of table columns

(overrides TableLooks)

• Show a name, label or both for each table variable

• Display missing data as blank, zero, “.,” or any other

user-deﬁned term, such as “missing”

• Set titles for pages and tables to be multiple lines with left,

right or center justiﬁcation

• Add captions for pages or tables

• Specify corner labels

• Customize labels for statistics

• Display the entire label for variables, values and statistics

• Format numerical results: Commas, date/time, dollars, F

(standard numeric), negative parentheses, “N=,” parentheses

(around numbers of percentages), percentages and

customized formats

• Apply preformatted TableLooks to results

• Deﬁne the set of variables that is related to multiple response

data and save it with your data deﬁnition for subsequent

analysis

• Accepts both long- and short-string elementary variables

• Imposes no limit on the number of sets that can be deﬁned

or the number of variables that can exist in a set

• All results are produced as Statistics pivot tables so you can

explore your results more easily with the pivot feature

– Rearrange columns, rows, and layers by dragging icons

for easier ad hoc analysis

– Toggle between layers by clicking on an icon for easier

comparison between subgroups

– Reset a table to its original organization with a simple

menu choice

– Rotate even the outermost nests in the stub, banner and

layer to uncover information that can be easily hidden

in large reports

Syntax

• Syntax converter translates syntax created in versions earlier

than SPSS Tables 11.5 into CTABLES syntax

Printing formats

• Print more than one table per page

• Specify page layout: Top, bottom, left and right margins;

page length

• Use the global break command to produce a table for each

value of a variable when the variable is used in a series

of tables

Two-stage least squares (2SLS)

Helps control for correlations between predictor variables and

error terms

• Use structural equations and instrumental variables

• Set control for correlations between predictor variables and

error terms

• Display output in pivot tables

Probit

Evaluates the value of stimuli using a logit or probit

transformation of the proportion responding

• Transform predictors: Base 10, natural or user-speciﬁed base

(including none)

• Allow for natural response rate estimates or specify them

yourself

• Use algorithm control parameters: Convergence, iteration

limit and heterogeneity criterion probability

• Select from the following statistics: Frequencies, ﬁducial

conﬁdence intervals, relative median potency, test of

parallelism, plots of observed probits or logits

• Display output in pivot tables

System requirements

Requirements vary according to platform. For details, see

www.ibm.com/spss/requirements.

IBM SPSS Custom Tables

Business Analytics

IBM Software

About IBM Business Analytics

IBM Business Analytics software delivers actionable insights

decision-makers need to achieve better business performance.

IBM oers a comprehensive, uniﬁed portfolio of business

intelligence, predictive and advanced analytics, ﬁnancial

performance and strategy management, governance, risk and

compliance and analytic applications.

With IBM software, companies can spot trends, patterns and

anomalies, compare “what if” scenarios, predict potential threats

and opportunities, identify and manage key business risks and

plan, budget and forecast resources. With these deep analytic

capabilities our customers around the world can better

understand, anticipate and shape business outcomes.

For more information

For further information please visit ibm.com/business-analytics.

Request a call

To request a call or to ask a question, go to ibm.com/business-

analytics/contactus. An IBM representative will respond to your

inquiry within two business days.

IBM SPSS Custom Tables

YTD03009-USEN-05

Please Recycle

IBM Corporation

Software Group Route 100

Somers, NY 10589

Produced in the United States of America

April 2012

IBM, the IBM logo, ibm.com, and SPSS are trademarks of International Business

Machines Corp., registered in many jurisdictions worldwide. Other product and

service names might be trademarks of IBM or other companies. A current list of

IBM trademarks is available on the Web at “ Copyright and trademark

information” at www.ibm.com/legal/copytrade.shtml.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of

Microsoft Corporation in the United States, other countries, or both.

The content in this document is current as of the initial date of publication and

may be changed by IBM at any time. Not all oerings are available in every

country in which IBM operates.

THE INFORMATION IN THIS DOCUMENT IS PROVIDED “AS IS”

WITHOUT ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING

WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR

A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF

NON-INFRINGEMENT. IBM products are warranted according to the terms

and conditions of the agreements under which they are provided.