How to create a cross table

May 27th, 2006

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: example data sheet SPSS file example questionnaire

Entry Filed under: 0. SPSS, where to start,Questions and answers


  • 1. Leang  |  November 24th, 2006 at 8:08 pm

    I want to read

  • 2. mohana  |  May 10th, 2007 at 8:17 am

    It is very useful. I want to learn spss more. How can I learn spss online?

  • 3. Ana Rita Regala  |  October 25th, 2007 at 9:49 am


    I’m portuguese. My english is not very good. Sory.
    I have SPSS 13.0 and I have some doubts. Maby you could help me.
    I created de variables. But I want that one of this variables have more than one possible response. And I don’t know how to do that.
    Other problem is that I have one variable that is consequence of other. For example, “there is things?” If the response was yes, the next variable have response to, but if the response was no, that variable don’t have response.
    Could you help me?
    This steps are before doing the statistics.

    thank you
    Ana Rita

  • 4. andris  |  October 26th, 2007 at 1:56 am

    @Ana Rita
    Please ask your question at

  • 5. Jane  |  September 11th, 2008 at 10:06 am

    I have done a crosstabulation for multiple response questions, do I read the crosstabulation in the same way? Say I want to test gender against several statements where a person can state more than one statement, do I still find the value I need in the row stated %gender?

    And in logistic regression I have tested several variables, it comes up that gender is signiicant but that B is negative. How do I interpret this? because in gender none of the variables are negative.

    I really hope somebody can help, you would really save my life!!



May 2006
« Apr   Aug »

Most Recent Posts