IBM Support

EXAMINE and FREQUENCIES give different results

Technote (FAQ)


I'm creating descriptive statistics using the EXAMINE procedure (Analyze>Descriptive Statistics>Explore in the menus) in SPSS Statistics and in comparing them to those produced by the FREQUENCIES procedure (Analyze>Desciptive Statistics>Frequencies). In some cases the values don't match. Why might this be happening?


The FREQUENCIES procedure always produces statistics based on all available data for each individual variable, while by default the EXAMINE procedure uses LISTWISE deletion of cases with missing data when multiple variables are involved. This can lead to different results for the same variables if there are missing data and multiple variables are used with the default settings in EXAMINE. You can specify PAIRWISE treatment of missing values in EXAMINE in the Options dialog or by specifing /MISSING=PAIRWISE in command syntax to eliminate the differences.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics

Software version: Not Applicable

Operating system(s): Platform Independent

Reference #: 1665683

Modified date: 07 September 2016