Question

Perform one correlation between two independent variables, such as Age and Relationship with Coworkers. Perform the second correlation on an independent variable (such as Relationship with Direct Supervisor) and the dependent variable (such as Workplace Happiness Rating.

Gender	Age	Supervisor	Telecommute	Coworkers	Happiness	Engagement	Overall Rating
1	29	1	1	2	7	8	15
2	32	4	1	3	9	10	19
1	39	1	1	1	4	5	8
1	25	2	1	2	5	8	13
1	27	1	1	1	5	4	9
2	33	3	1	2	7	8	15
2	36	3	1	2	8	7	15
1	28	3	1	3	9	8	17
1	34	3	2	3	8	8	16
2	32	2	1	2	6	8	14

Answer 1

Correlation between Age and Relationship with Coworkers

The provided data are shown in the table below

X	Y
29	2
32	3
39	1
25	2
27	1
33	2
36	2
28	3
34	3
32	2

Also, the following calculations are needed to compute the correlation coefficient:

	X	Y	X*Y	X2	Y2
	29	2	58	841	4
	32	3	96	1024	9
	39	1	39	1521	1
	25	2	50	625	4
	27	1	27	729	1
	33	2	66	1089	4
	36	2	72	1296	4
	28	3	84	784	9
	34	3	102	1156	9
	32	2	64	1024	4
Sum =	315	21	658	10089	49

The correlation coefficient r is computed using the following expression:

Therefore, based on this information, the sample correlation coefficient is computed as follows

Correlation between  Relationship with Direct Supervisor and Workplace Happiness Rating.

The provided data are shown in the table below

X	Y
1	7
4	9
1	4
2	5
1	5
3	7
3	8
3	9
3	8
2	6

Also, the following calculations are needed to compute the correlation coefficient:

	X	Y	X*Y	X2	Y2
	1	7	7	1	49
	4	9	36	16	81
	1	4	4	1	16
	2	5	10	4	25
	1	5	5	1	25
	3	7	21	9	49
	3	8	24	9	64
	3	9	27	9	81
	3	8	24	9	64
	2	6	12	4	36
Sum =	23	68	170	63	490

The correlation coefficient r is computed using the following expression:

Therefore, based on this information, the sample correlation coefficient is computed as follows

.

Please do upvote if you are satisfied! Let me know in the comments if anything is not clear. I will reply ASAP!