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.

Free tutorialFree practiceAbout 5 minutes4 practice questions

Quick answer: How do you run Frequencies in SPSS?

  1. Click Analyze › Descriptive Statistics › Frequencies.
  2. Move your categorical variable into the Variable(s) box.
  3. Optionally add a bar chart under Charts…, then click OK.
  4. Report the Valid Percent, which excludes missing answers.

Report it in APA style: 57.9% of participants who answered were female (n = 55).

Last updated November 2026 · Not sure this is the right test? Try the Which statistical test? tool.

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

Finding Frequencies

Frequencies counts how many people gave each answer. It's usually the first thing you run on a new data set, to check for typos and see your sample.

survey.sav [DataSet1] – SPSS Statistics Data Editor
FileEditViewDataTransformAnalyze1GraphsUtilitiesExtensionsWindowHelp
idgenderagescorevarvar
1112172
2223465
3321988
4412754
5522279
6614561
7723070
  • Reports›
  • Descriptive Statistics2›
  • Bayesian Statistics›
  • Tables›
  • Compare Means›
  • General Linear Model›
  • Correlate›
  • Regression›
  • Nonparametric Tests›
  • Frequencies…3
  • Descriptives…
  • Explore…
  • Crosstabs…
  • Ratio…
  • P-P Plots…
  • Q-Q Plots…
Data ViewVariable View
  1. 1
    AnalyzeClick Analyze in the menu bar. Almost every statistical test lives here.
  2. 2
    Descriptive StatisticsHover over it to open the submenu.
  3. 3
    Frequencies…Click it. The three dots mean a dialog box will open.

The Frequencies dialog

Most SPSS dialogs work the same way: pick variables on the left, move them right, choose extras with the buttons, then press OK.

Frequencies
Variables1
Participant ID [id]
Age in years [age]
Exam score (%) [score]
▶2
Variable(s):3
Gender [gender]
Statistics…4Charts…5Format…Style…Bootstrap…
✓Display frequency tables
OKPaste6ResetCancelHelp
  1. 1
    Variable listEvery variable in your file, shown by its label with the name in brackets. Click one to select it.
  2. 2
    Arrow buttonMoves the selected variable into the box on the right. You can also drag it or double-click it.
  3. 3
    Variable(s) boxEach variable here gets its own frequency table.
  4. 4
    Statistics…Adds the mean, median, mode, quartiles, skewness and more.
  5. 5
    Charts…Adds a bar chart (for categories) or a histogram (for Scale data).
  6. 6
    OK and PasteOK runs the analysis. Paste writes the matching syntax into a Syntax Editor instead, so you can save it and rerun it later.

Reading the output

Results open in a separate window called the Output Viewer. Each procedure adds its tables to the end.

Output1 [Document1] – SPSS Statistics Viewer
FileEditViewDataTransformAnalyzeGraphsUtilitiesExtensionsWindowHelp
Output1
Log
Frequencies
Title
Notes
Statistics
gender
gender
Frequency2Percent3Valid Percent4Cumulative Percent5
ValidMale4040.042.142.1
Female5555.057.9100.0
Total9595.0100.0
Missing6System55.0
Total100100.0
  1. 1
    OutlineClick any item to jump to that table. Right-click to delete tables you don't need.
  2. 2
    FrequencyHow many people are in each category.
  3. 3
    PercentOut of everyone in the file, including people who skipped the question.
  4. 4
    Valid PercentOut of the people who answered. This is usually the one to report.
  5. 5
    Cumulative PercentA running total of Valid Percent. Useful for ordinal data, for example "68% rated 3 or lower".
  6. 6
    MissingCases with no value. Here 5 people didn't answer, which is why Percent and Valid Percent differ.

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.

More in Find your way around