If you want to calculate any statistics split into the different categories of a variable, you can do this easily in SPSS. All you need to do is the following:
- Click on “Data” from the pull-down menus
- Click on “split file” found almost all the way at the bottom of the list of commands
- Toggle the circle at the top that says “Compare groups”
- You will now be allowed to move the variable you want to split your data by, from the box on the left into the “Groups Based on:” box on the right .