# How to Create a Crosstab in SPSS (With Example)

A crosstab is a table that summarizes the relationship between two categorical variables.

To create a crosstab in SPSS, you can use Analyze > Descriptive Statistics > Crosstabs.

The following example shows how to do so in practice.

## Example: How to Create a Crosstab in SPSS

Suppose we have the following dataset in SPSS that contains information about various basketball players:

Suppose that we would like to create a crosstab to summarize the frequency of each occurrence of Team and Position.

To do so, click the Analyze tab, then click Descriptive Statistics, then click Crosstabs:

In the new window that appears, drag the Team variable into the Rows panel, then drag the Position variable into the Columns panel:

Once you click OK, the following output will be generated:

The first table shows the total number of valid observations and missing observations in the dataset.

We can see that there are 12 total valid observations and 0 missing observations (or “cases”).

The next table displays the crosstab of Team * Position.

Here is how to interpret the values in the crosstab:

Row Totals:

• A total of 6 players are on team A
• A total of 6 players are on team B

Column Totals:

• A total of 3 players have a position of Center
• A total of 4 players have a position of Forward
• A total of 5 players have a position of Guard

Individual Cells:

• 1 player has a position of Center on team A
• 3 players have a position of Forward on team A
• 2 players have a position of Guard on team A
• 2 players have a position of Center on team B
• 1 player has a position of Forward on team B
• 3 players have a position of Guard on team B

By creating this one table, we can understand how frequently each combination of Team and Position occurs in the dataset.