SPSS Statistics For Dummies, 4th Edition

Chapter 25

Editing Tables

IN THIS CHAPTER

Changing the appearance of tables with TableLooks

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

Transforming 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, you discover how to edit pivot tables. Many more options than we can cover in this one short chapter are available, but we get you off to a good start. The menus that we describe have many additional options, which we suggest you explore.

SPSS pivot tables are comprised of objects and elements that can be rearranged and edited using Pivot Table Editor. You can pivot the table (change rows to columns and columns to rows, or move individual elements, such as a variable or a set of statistics); change cell properties such as fonts, colors, and data alignment in individual ...