By Ruben Geert van den Berg on January 20, 2015 under Correlation Tutorials - Other.

SPSS CORRELATIONS Command

Summary

SPSS CORRELATIONS generates tables with Pearson correlations and their underlying N’s and p-values.For other correlation coefficients such as Spearman’s, try the NONPAR CORR command. This tutorial quickly walks through its main options, using freelancers.sav for demonstrational purposes.

SPSS CORRELATIONS Data View Test Data

User Missing Values

Before running any correlations, we'll first specify all values of one million dollars or more as user missing values for income_2010 through income_2014.Inspecting their histograms (also see FREQUENCIES) shows that this is necessary indeed; some extreme values are present in these variables and failing to detect them will have a huge impact on our correlations. We'll do so by running the following line of syntax: missing values income_2010 to income_2014 (1e6 thru hi). Note that “1e6” is a shorthand for a 1 with 6 zeroes, hence one million.

SPSS CORRELATIONS - Basic Use

The syntax below shows the simplest way to run a standard correlation matrix. Note that due to the table structure, all correlations between different variables are shown twice.
By default, SPSS uses pairwise deletion of missing values here; each correlation (between two variables) uses all cases having valid values these two variables. This is why N varies from 38 through 40 in the screenshot below.

*Standard correlation matrix with correlations, N's and p-values.

correlations income_2010 to income_2014.
SPSS CORRELATIONS Output

Keep in mind here that p-values are always shown, regardless of whether their underlying statistical assumptions are met or not. Oddly, SPSS CORRELATIONS doesn't offer any way to suppress them. However, SPSS Correlations without Significance offers a super easy tool for doing so anyway.

SPSS CORRELATIONS - WITH Keyword

By default, SPSS CORRELATIONS produces full correlation matrices. A little known trick to avoid this is using a WITH clause as demonstrated below. The resulting table is shown in the following screenshot.

*Custom correlation matrix.

correlations income_2010 with income_2011 to income_2014.
SPSS CORRELATIONS Output

SPSS CORRELATIONS - MISSING Subcommand

Instead of the aforementioned pairwise deletion of missing values, listwise deletion is accomplished by specifying it in a MISSING subcommand.An alternative here is identifying cases with missing values by using NMISS. Next, use FILTER to exclude them from the analysis. Listwise deletion doesn't actually delete anything but excludes from analysis all cases having one or more missing values on any of the variables involved.
Keep in mind that listwise deletion may seriously reduce your sample size if many variables and missing values are involved. Note in the next screenshot that the table structure is slightly altered when listwise deletion is used.

*Correlation matrix with listwise deletion of missing values.

correlations income_2010 to income_2014
/missing listwise.
SPSS CORRELATIONS Output

SPSS CORRELATIONS - PRINT Subcommand

By default, SPSS CORRELATIONS shows two-sided p-values. Although frowned upon by many statisticians, one-sided p-values are obtained by specifying ONETAIL on a PRINT subcommand as shown below.
Statistically significant correlations are flagged by specifying NOSIG (no, not SIG) on a PRINT subcommand.

*Show one-sided p-values and flag statistically significant correlations.

correlations income_2010 with income_2011 to income_2014
/print nosig onetail.
SPSS CORRELATIONS Output

SPSS CORRELATIONS - Notes

More options for SPSS CORRELATIONS are described in the CSR. This tutorial deliberately skipped some of them such as inclusion of user missing values and capturing correlation matrices with the MATRIX subcommand. We did so due to doubts regarding their usefulness.

Related Tutorials

Correlation Coefficient – What Is It?

Correlation coefficients explained in normal language with illustrations and examples. Read more

SPSS Correlation Test – Simple Tutorial

Summary SPSS CORRELATIONS generates tables with Pearson correlations and their underlying N’s and p-values.For other correlation coefficients such as Spearman’s, try the NONPAR CORR command. This tutorial quickly walks through its main options, using freelancers.sav for demonstrational purposes. User Missing Values Before running any correlations, we'll first specify all values of one million dollars or ... (Read More) Read more

Comment on this Tutorial

*Required field. Your comment will show up after approval from a moderator.

This Tutorial has 5 Comments