Can you relate? Correlation and simple linear regression - Improving the User Experience through Practical Data Analytics - page 213

and the Column 1 variable (noted as 0.895144) is the same as the correlation
between the Column 1 variable and the Column 2 variable. Also note that we
have a value of 1.0 as the correlation between each variable and itself!! This is
always the case and, of course, it makes perfect sense that a variable is perfectly
correlated with itself.
Now we present inding r using SPSS.
FIGURE 9.2
Data analysis with correlation highlighted; Excel with illustrative data.
FIGURE 9.3
Correlation dialog box; Excel with illustrative data.