Statistics How To

Crosstabs in SPSS: Step by Step + Video

Probability and Statistics Index > SPSS Statistics > How to Use Crosstabs in SPSS

Crosstabs in SPSS is just another name for contingency tables, which summarize the relationship between different variables of categorical data. Crosstabs can help you show the proportion of cases in subgroups. The basic crosstabs in SPSS command gives you counts by default (in other words, you’ll get a frequency distribution table with counts). In order for crosstabs to be useful and produce the information you normally see in a contingency table, you’ll need to specify row-percents or column-percents.

You may also be interested in this article, which uses crosstabs for a hypothesis test: How to Perform a Chi-Square Test in SPSS.

How to Use Crosstabs in SPSS: Steps

Watch the video or read the steps below:

Sample question: Make an SPSS Crosstab for age (2,3,4,6,8,44,34,33,45,56,57,57) vs. healthcare type (1,1,2,3,4,5,6,1,2,4,5,5). Show percentages of healthcare type in the contingency table.

Step 1: Type your data into an SPSS worksheet. Contingency tables require at least two variables (columns) of data. For this sample question, type ages (2,3,4,6,8,44,34,33,45,56,57,57) into the first column and then type Healthcare type (1,1,2,3,4,5,6,1,2,4,5,5) into the second column. Change the variable names (the column headers) by clicking the “Variable” button at the bottom of the sheet and typing over the variable name.

Step 2: Click “Analyze,” then hover over “Descriptive Statistics” and then click “Crosstabs.” The Crosstabs dialog window will open.

Step 3: Select one variable in the left window and then click the top arrow to populate the “Row(s)” box. Select a variable to populate the “Column(s)” box and then click the center arrow. For this sample problem, “Age” was selected for “Row(s)” and “Healthcare Type” was selected for “Column(s).” Once you have made your selection, click “Cells.”
Crosstabs in SPSS 2

Step 4: Check which percentages you want to see (rows or columns). What you select will depend upon what variables you put in rows and what you put in columns. For this sample problem, “Healthcare Type” was placed in the columns, so check “Column” under percentages.

Step 5: Click “Continue” and then click “OK.” The Crosstabs window will appear.
spss crosstabs 3

Tip: Typically in a contingency table, the independent variable is placed in rows and the dependent variable is placed in columns. This is just a tradition and has no mathematical basis, so don’t over analyze which variable to place in columns and which to place in rows when you are creating crosstabs in SPSS.


Need help with a homework or test question? With Chegg Study, you can get step-by-step solutions to your questions from an expert in the field. If you rather get 1:1 study help, Chegg Tutors offers 30 minutes of free tutoring to new users, so you can try them out before committing to a subscription.

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments? Need to post a correction? Please post a comment on our Facebook page.

Check out our updated Privacy policy and Cookie Policy

Crosstabs in SPSS: Step by Step + Video was last modified: June 24th, 2018 by Stephanie

Comments are closed.