How to create a cross table
May 27th, 2006 mark
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
Entry Filed under: 0. SPSS, where to start, Questions and answers
4 Comments Add your own
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
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed