= SPSS Frequencies =

The '''`FREQUENCIES`''' command tabulates data.

<<TableOfContents>>

----



== 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.

----



== See also ==

[[https://www.gnu.org/software/pspp/manual/html_node/FREQUENCIES.html|PSPP manual for FREQUENCIES]]



----
CategoryRicottone