Archive for May 21st, 2006

How to create a frequency table

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

5 comments May 21st, 2006


Calendar

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

Posts by Month

Posts by Category