Correlation in Data Analysis

[Guzzlr]

So I placed evenly spread numbers in Axis X label, and random numbers in Axis Y label.
Correlation shows a strong relation for Axis x, (the number 1) which is understandable as the numbers in that column are all even numbers from 2 to 40
Correlation shows a weak relation for Axis Y, (the number 0.53) which is understandable as the numbers are very random from a -10 to 40
my question, is what is the loan number of "1" by itself (next column over from 0.53)?

Thanks for the help

XL2bb below:

X Axis	Y Axis
2	1
4	5
6	4
8	10
10	33
12	16
14	2
16	22
18	5
20	28
22	12
24	34
26	5
28	40
30	-10
32	46
34	2
36	52
38	31
40	58
	X Axis	Y Axis
X Axis	1
Y Axis	0.529066	1

 

[AhoyNC]

It is showing that the correlation of X to Y is 0.53. The correlation of X to X is 1 and the correlation of Y to Y is 1. Anything correlated to it self is going to be 1.

 

[Guzzlr]

It is showing that the correlation of X to Y is 0.53. The correlation of X to X is 1 and the correlation of Y to Y is 1. Anything correlated to it self is going to be 1.

Oh...I see it now by the column to row designation, thanks

 

[AhoyNC]

You're welcome. Thanks for the feedback.