SPSS Frequencies
The FREQUENCIES command tabulates data.
Contents
Usage
frequencies /variables=foo bar baz.
Format
The default /FORMAT subcommand is /FORMAT=TABLE AVALUE. This causes SPSS to create tables (the alternative being NOTABLE) and sort values in ascending order.
Available alternatives to creating a table per variable are:
NOTABLE (create no tables)
LIMIT (create a table per variable only if there are N or fewer distinct values)
frequencies /variables=foo /format limit(50).
Available alternatives to sorting in ascending order by counts are:
DVALUE (descending order by counts)
AFREQ (ascending order by frequency)
DFREQ (descending order by frequency)
Statistics, Percentiles, and Ntiles
The /STATISTICS subcommand causes statistics to be computed for the tabulated variables.
Name |
Effect |
DEFAULT |
Default behavior |
MEAN |
mean |
SEMEAN |
standard error of the mean |
MEDIAN |
median |
MODE |
mode (or if multiple modes, the least of them) |
STDDEV |
standard deviation |
VARIANCE |
variance |
KURTOSIS |
kurtosis and standard error of the kurtosis |
SKEWNESS |
skewness and standard error of the skewness |
RANGE |
range |
MINIMUM |
minimum |
MAXIMUM |
maximum |
SUM |
sum |
SESKEWNESS |
standard error of the kurtosis |
SEKURTOSIS |
standard error of the skewness |
ALL |
all of the above |
NONE |
no statistics |
By default, SPSS selects the MEAN, STDDEV, MINIMUM, and MAXIMUM options automatically.
The /PERCENTILES subcommand causes the specified percentiles to be computed.
frequencies /variables=foo /percentiles=10 20 80 90.
The /NTILES subcommand causes percentiles to be computed for each N-tile of the values. For example, /NTILES=4 causes each quartile to be computed.
Missing
By default, SPSS will exclude observations with a user missing value for a tabulated variable. Add the /MISSING=EXCLUDE subcommand to explicitly allow this behavior, or add /MISSING=INCLUDE subcommand to disable it.
Data Model
The FREQUENCIES command causes all pending transformations to execute, and reads the active dataset.