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.

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