Question

How do I create a table showing pairwise correlations of three variables in excel?

Sample Data

99.81	109.3949	104.6233
103.73	102.6855	104.2667
101.95	103.4166	105.72
116.36	102.39	101.83
104.19	112.169	107.3467
109.37	106.5837	107.5
110.23	108.5341	109.9733
122.73	109.7212	107.93

Answer 1

Sol :

sample 1	sample 2	sample 3
99.81	109.3949	104.6233
103.73	102.6855	104.2667
101.95	103.4166	105.72
116.36	102.39	101.83
104.19	112.169	107.3467
109.37	106.5837	107.5
110.23	108.5341	109.9733
122.73	109.7212	107.93

steps :

1) data

2) data analysis

3) Correlation

correlation matrix :

	sample 1	sample 2	sample 3
sample 1	1
sample 2	0.028743	1
sample 3	0.136315	0.641061	1

Which says,

• sample 1 and sample 2 are positively correlated and correlation coefficient is 0.0287.
• sample 2 and sample 3 are positively correlated and correlation coefficient is 0.1363
• sample 1 and sample 3 are positively correlated and correlation coefficient is 0.6411

We have successfully created correlation matrix in excel