Testing differences between dependent correlations
I wish to test whether the Pearson correlations for each of two variables with a third variable are different? I would like to print both one-tailed and two-tailed p-values for the test. How can I do this in SPSS?
Resolving the problem
You can compute results for testing the difference between any two dependent correlations as follows:
1. Copy the command syntax shown below and paste it into an SPSS Syntax Editor window.
2. Change the values in the line following BEGIN DATA to reflect your correlations and sample size. You can run several tests at once by entering one row of data for each pair of correlations to be tested.
3. Run the command syntax by going to Run->All in the Syntax Editor window.
This method is based on Meng, X.-L., Rosenthal, R., & Rubin, D. B. (1992). Comparing correlated correlation coefficients, Psychological Bulletin, 111(1), 172-175.
Output includes the difference in correlations, r13-r23 and 95% confidence bounds for this difference (you can change the coverage level by changing the .975 values in the probit functions). A Z test of the null hypothesis of equality of population correlations is also given, with one- and two-sided p values.
data list list / r12 r13 r23 n.
.5 .75 .4 100
formats z p_1 p_2 r_diff lower upper (f8.5).
list r_diff lower upper z p_1 p_2.