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.

Additional Resources

The following tutorials explain how to perform other common tasks in SPSS:

How to Perform a One Sample t-test in SPSS
How to Perform a Two Sample t-test in SPSS
How to Create a Frequency Table in SPSS

One Reply to “How to Create a Crosstab in SPSS (With Example)”

Leave a Reply

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