Unit 1 · Find your way around
How to run Frequencies in SPSS
Run a frequency table in SPSS step by step and learn to read Frequency, Percent, Valid Percent and Cumulative Percent.
Quick answer: How do you run Frequencies in SPSS?
- Click Analyze › Descriptive Statistics › Frequencies.
- Move your categorical variable into the Variable(s) box.
- Optionally add a bar chart under Charts…, then click OK.
- Report the Valid Percent, which excludes missing answers.
Report it in APA style: 57.9% of participants who answered were female (n = 55).
What is a frequency table?
A frequency table counts how many cases fall into each category of a variable and turns those counts into percentages. It’s the simplest summary of categorical data and usually the first analysis you run, because it describes your sample and exposes typing errors and missing data.
When to use it
- Describing categorical variables such as gender, course or condition.
- Reporting the make-up of your sample in the Method section.
- Checking for impossible values, such as a 7 on a 1–5 scale.
How it works
SPSS counts each value. Percent divides by every case in the file. Valid Percent divides only by the cases with an answer, so it’s usually the figure to report. Cumulative Percent adds the valid percentages as it goes down the table, which is useful for ordered categories.
Worked example
Of 100 students, 95 answered the gender question: 40 male and 55 female. Female is 55% of everyone (Percent) but 57.9% of those who answered (Valid Percent).
Key terms
- Frequency
- The count of cases in a category.
- Valid Percent
- Percentage of cases with a non-missing value.
- Cumulative Percent
- Running total of Valid Percent.
- Mode
- The most frequent category.
Common mistakes
- Reporting Percent when there are missing values, so percentages don’t add up to 100% of respondents.
- Running Frequencies on a Scale variable with hundreds of different values: use Descriptives or a histogram instead.
How to do it in SPSS
The SPSS syntax
Prefer typing to clicking? Open File › New › Syntax, paste this in, select it and choose Run › Selection. Every dialog's Paste button writes the same kind of code.
FREQUENCIES VARIABLES=gender course
/BARCHART FREQ
/ORDER=ANALYSIS.Practice data
Download the file used in this lesson and run it yourself in SPSS: you should get the same results as the screens above.
- students.savStudent survey: gender, age, course, exam score and attention check (N = 100)
Now practise it interactively →
Reading is only half of it. Tap through the real SPSS menus, read the output and pick the right write-up in 4 quick questions, with instant feedback on every answer.
This lesson’s practice is free. No sign-up needed to start.