How to create a frequency table

May 21st, 2006

The most easy way to present data is to create a table. There are different ways in SPSS to create a table. We will describe the most common way of creating table.
The most common way of creating a table is with the descriptive statistics function. To do this first go to analyze>descriptive statistics>frequencies. This opens the following screen:
tables1.jpg
Now we drag the question “what is your sex?” into the variables. By clicking ok you will get the following tables:
tables2.jpg
The first table shows how many valid cases there are and how many there are missing.
The second table shows:
- The 1st column: This shows the value names and the total.
- The 2nd column: This show the frequency of the values.
- The 3rd column: This shows the percentage of the values including the missing cases.
- The 4th column: This shows the percentage of the values excluding the missing cases.
- The 5th column: This shows the cumulative percentage; this can be important information.

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. F3TRIO3D2X  |  December 11th, 2007 at 1:53 pm

    Thanks.

  • 2. Desmond Tutu  |  December 11th, 2007 at 2:34 pm

    Easily understandable tutorial. I present my commendations.

  • 3. suntech loans student  |  January 7th, 2009 at 5:01 am

    suntech loans student suntech student loans

  • 4. madison taylor  |  February 5th, 2009 at 3:58 pm

    hey u really did not help me and i really want to help u because you need more color and iam not trying to hurt ur feelings or anything but u need to spice it up . OK because u probaly dont get alot of viewers and thats probaly why. remember my email and i am going to help u OK. e-mail me back thanks by your own madison taylor.

  • 5. Z  |  July 24th, 2011 at 6:39 pm

    after I run the frequency table and i find that there are certain data mis entries, is it possible to figure out which cell has the incorrect data from the frequency table in order to correct it?


Calendar

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

Most Recent Posts