How to create a cross table
The most easy way to present data in a cross table is to use the table function in SPSS. To do this first go to analyze>tables>basic tables. This opens the following screen.
Now we drag the question “what is your sex?†into down and “SPSS lessons†into across. By clicking statistics we will get the following screen.
To get the amount and the row percentage into the crosstable, we drag “row%†and “count†into the right box. Now we click continue.
By clicking ok you will get the following cross table:
Tip: If you want a total percentage or amount in your table, just click on “total” at the basic tables screen, and choose the option “totals over each group variables”.
Files used for this example:
SPSSlog.com example data sheet
SPSSlog.com SPSS file
SPSSLog.com example questionnaire
5 comments May 27th, 2006