SPSS FREQUENCIES command can be used for much more than frequency tables; it's also the easiest way to obtain basic charts such as histograms and bar charts. On top of that, it provides us with percentiles and some other statistics. Plenty of reasons for taking a closer look at this ubiquitous SPSS command. We'll use employees.sav throughout this tutorial.

## SPSS FREQUENCIES - Basic Table

The most basic way to use FREQUENCIES is simply generating a frequency table. For example, the frequency table for job_type is obtained by running the following line of syntax frequencies job_type.

By default, the rows of this table are sorted ascendingly by value. Note that this may not be obvious when only value labels are displayed. We'll next take a look at different options for sorting the table rows.

## SPSS FREQUENCIES - Sort Order

SPSS default sort order of ascendingly be value can be changed by adding a FORMAT subcommand. Possible values are AVALUE and DVALUE (ascending and descending values) or AFREQ and DFREQ (ascending and descending frequencies). For example, the syntax below sorts the rows from the value with highest frequency (yes, that's the mode) through the value with the lowest frequency.

***Frequency table sorted descendingly by frequency.**

frequencies job_type

/format dfreq.

## SPSS FREQUENCIES - Bar Chart

SPSS FREQUENCIES command is the easiest way to create one or more bar charts for categorical variables. Just add the BARCHART subcommand. Note that you can combine it with a sort order, resulting in the barchart bars being ordered from highest through lowest frequency as shown below.

***Create frequency table and bar chart, both ordered by descending frequencies.**

frequencies job_type

/format dfreq

/barchart.

## SPSS FREQUENCIES - Pie Chart

An alternative visualization for categorical variables is a pie chart. In order to generate it, simply add a PIECHART subcommand to FREQUENCIES. The syntax below creates a pie chart for education_type.

***Create pie chart for education_type.**

frequencies education_type

/piechart.

## SPSS FREQUENCIES - Histogram

Frequency tables, bar charts and pie charts can all be used for both metric as well as categorical variables, including string variables. However, they are not useful for metric variables with many distinct values; in this case, tables get too many rows and graphs too many elements.

The ideal way to visualize such variables is a histogram, obtained by the HISTOGRAM subcommand. Apart from that, we can suppress frequency tables by specifying NOTABLE on the FORMAT subcommand. Like so, the syntax below generates a histogram for monthly_income.

***Generate histogram (without table) for monthly_income.**

frequencies monthly_income

/format notable

/histogram.

## SPSS FREQUENCIES - Percentiles

SPSS FREQUENCIES provides a nice way to obtain percentiles: just add a PERCENTILES subcommand followed by the desired percentiles in parentheses. The syntax below gives an example. Keep in mind that percentiles are not meaningful for nominal variables.

***Calcute 25th., 50th., and 75th. percentiles for monthly_income.**

frequencies monthly_income

/format notable

/percentiles (25 50,75).

## SPSS FREQUENCIES - Ntiles

Ntiles are easily obtained with SPSS FREQUENCIES: simply add the NTILES subcommand with the number of ntiles behind it in parentheses. If you want to assign cases to ntile groups, use RANK; it creates a new variable holding the ntile for each case on a given variable. Both options are shown in the syntax below.

***1. Inspect ntiles for monthly_income.**

frequencies monthly_income

/format notable

/ntiles (5).

***2. Create monthly_income ntile group variable in data.**

rank monthly_income/ntiles(5).

## SPSS FREQUENCIES - Statistics

SPSS FREQUENCIES can compute all statistics obtained from DESCRIPTIVES plus the median and mode. Note that the statistics table from FREQUENCIES has a different layout with variables in columns and statistics in rows. For obtaining them, add a STATISTICS subcommand. Just as with DESCRIPTIVES, specifying the ALL keyword returns all available statistics.

***Obtain all available statistics from monthly_income.**

frequencies monthly_income

/format notable

/statistics all.

## SPSS FREQUENCIES - Multiple Variables

Obviously, FREQUENCIES can be run for multiple variables, possibly using TO or ALL. If multiple types of output (frequency table, chart and so on) are generated, you can have them sorted by variable or output type by specifying VARIABLE or ANALYSIS on an ORDER subcommand.

***1. Sort output by variable.**

frequencies education_type to job_type

/format dfreq

/barchart

/order variable.

***2. Sort output by output type (first tables for all variables, then charts for all variables).**

frequencies education_type to job_type

/format dfreq

/barchart

/order analysis.

## This tutorial has 15 comments

## By William Peck on June 10th, 2019

Whoa - bingo! thanks!!!

## By Ruben Geert van den Berg on June 4th, 2019

Hi William!

You could create such a table from a string variable holding the value labels:

STRING blah (a1000).

COMPUTE blah = VALUELABEL(bloh).

VARIABLE LABELS blah "Description for variable goes here".

FREQUENCIES blah

/FORMAT AVALUE.

Hope that helps!

SPSS tutorials

## By William Peck on June 3rd, 2019

so there's no way to sort by Value Label? That seems odd - - - my values are kind of jumbled up, so I want to sort by value label …

## By WILLIAM C PECK on November 17th, 2018

Quick preview of " Creating APA Style Frequency Tables in SPSS", looks really good. I will review in depth next week, definitely looks like I can apply it. Thanks!

## By Ruben Geert van den Berg on November 16th, 2018

Hi William!

FREQUENCIES is ideal for quick data checks. Especially running many bar charts or histograms with a single line of syntax is super efficient.

However, I feel the basic frequency tables are a poor option for reporting. So I very recently wrote Creating APA Style Frequency Tables in SPSS. I suggest you take a quick look at that as well.

Hope you like it!