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