Chapter 19

Editing Tables

In This Chapter

arrowChanging the appearance of tables with TableLooks

arrowUsing the Style Output feature to highlight certain cells in your output

arrowTransforming tables using pivoting trays

SPSS pivot tables are pretty cool. In fact, in 1997, two years after they came out, SPSS pivot tables were added to the Smithsonian Institutes Permanent Research Collection of Information Technology. Virtually all SPSS tabular output comes in the form of a pivot table. It isn’t the product of a special menu. FREQUENCIES tables, DESCRIPTIVES tables, and just about every other command make them.

In this chapter, we explain how to edit them. There are many more options than we can cover in this one short chapter, but we get you off to a good start. The menus that we explore have many additional options, so explore the available options that you find there.

Working with TableLooks

In this section, we create a similar table three times. The goal is to focus on the editing, not on the table creation, but the table itself is pretty standard.

  1. Open the cars.sav file.

    The file is not in the SPSS installation directory. You have to download it from this book’s companion website.

  2. Choose ...

Get SPSS Statistics for Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.