Table of Contents
A frequency table in SPSS is a table that displays the number of times each value or category occurs in a variable. To create a frequency table in SPSS, first open the data set containing the variable of interest. Then, go to the “Analyze” tab and select “Descriptive Statistics.” From there, choose “Frequencies” and select the variable you want to create a frequency table for. Click “OK” and the frequency table will be generated in the output window. For example, if you have a variable called “favorite color” and the values are red, blue, and green, the frequency table will show how many times each color was chosen by participants in the study.
A frequency table is a type of table that displays the frequencies of each unique value for a given variable in a dataset.
The easiest way to create a frequency table in SPSS is to use Analyze > Descriptive Statistics > Frequencies.
The following example shows how to do so in practice.
Example: How to Create a Frequency Table in SPSSS
Suppose we have the following dataset in SPSS that contains information about various basketball players:
Suppose that we would like to create a frequency table to summarize how often each team name appears in the Team column.
To create this frequency table, click the Analyze tab, then click Descriptive Statistics, then click Frequencies:
In the new window that appears, drag Team into the Variables panel.
Note #1: If you’d like, you can also click the Statistics button in the top right corner to produce various descriptive statistics for the Team variable as well.
Note #2: You can also drag more than one variable into the Variables panel if you’d like to create a frequency table for multiple variables at once.
Next, click OK:
The following output will be generated:
The first table shows that there were 11 Valid values in the Team column and 0 Missing values.
For example, we can see:
- The team name Mavs occurs 4 times, which represents 4/11 = 36.4% of all values in the Team column.
- The team name Rockets occurs 3 times, which represents 3/11 = 27.3% of all values in the Team column.
- The team name Spurs occurs 2 times, which represents 3/11 = 18.2% of all values in the Team column.
- The team name Warriors occurs 2 times, which represents 3/11 = 18.2% of all values in the Team column.
Note that the values in the Percent column add up to 100%.
Additional Resources
The following tutorials explain how to perform other common operations in SPSS: