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.
crosstables1.jpg
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.
crosstables2.jpg
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:
crosstables3.jpg
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

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

5 Comments

  • 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

    Hello

    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 http://www.spssforum.com

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

    Hi
    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!!

    Thanks
    Jane


Calendar

May 2006
M T W T F S S
« Apr   Aug »
1234567
891011121314
15161718192021
22232425262728
293031  

Most Recent Posts