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:
Now we drag the question “what is your sex?” into the variables. By clicking ok you will get the following tables:
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: example data sheet SPSS file example questionnaire

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


  • 1. F3TRIO3D2X  |  December 11th, 2007 at 1:53 pm


  • 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?


May 2006
« Apr   Aug »

Most Recent Posts