Question

Compute the correlation coefficient for each set of bivariate data to see which one is the most linear. In other words, for which of these three pairs of variables is |r| closest to 1?

Work on this gathered data as if it is bivariate.

Variable 1	Variable 2	Variable 3
19.8208	76.652	1.653
9.5292	80.5804878	1.44
43.7244	73.51219512	1.57
5.6706	79.43	1.424
5.0092	79.1	1.87
18.7038	75.42926829	1.72
8.1462	79.87073171	1.87
51.2912	72.649	1.918
20.0066	74.20731707	1.25
11.336	81.89756098	2.2
30.4734	68.29536585	2.6
16.1048	73.26829268	1.5
17.8444	81.39756098	1.36
7.1886	80.99756098	1.95
14.9762	76.24634146	1.41
37.4372	73.45853659	1.59
22.0306	75.11219512	1.43
10.286	81.62682927	1.37
34.1514	74.154	2.155
28.9362	70.26536585	1.443

Variable 1 & Variable 2 - _______ (coefficient)

Variable 2 & Variable 3 - _______ (coefficient)

Variable 1 & Variable 3 - _______ (coefficient)

Answer 1

Using excel to calculate the correlation coefficients, we get:

	Variable 1	Variable 2	Variable 3
	19.8208	76.652	1.653
	9.5292	80.5804878	1.44
	43.7244	73.51219512	1.57
	5.6706	79.43	1.424
	5.0092	79.1	1.87
	18.7038	75.42926829	1.72
	8.1462	79.87073171	1.87
	51.2912	72.649	1.918
	20.0066	74.20731707	1.25
	11.336	81.89756098	2.2
	30.4734	68.29536585	2.6
	16.1048	73.26829268	1.5
	17.8444	81.39756098	1.36
	7.1886	80.99756098	1.95
	14.9762	76.24634146	1.41
	37.4372	73.45853659	1.59
	22.0306	75.11219512	1.43
	10.286	81.62682927	1.37
	34.1514	74.154	2.155
	28.9362	70.26536585	1.443
Corr 1 AND 2	-0.730903
Corr 2 AND 3	-0.199138
Corr 1 AND 3	0.1811026

Please let me know in comments in case anything is unclear. Will reply ASAP. Do upvote if satisfied!