How to Create a Frequency Table in SPSS (With Example)


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:

frequency table in SPSS

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.

The Frequency column in the frequency table shows the number of occurrences of each unique value in the Team column and the Percent column shows the percentage that each team name represents as a percentage of total values in the Team column.

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:

How to Calculate a Five Number Summary in SPSS
How to Create a Correlation Matrix in SPSS
How to Identify Outliers in SPSS

Leave a Reply

Your email address will not be published. Required fields are marked *