Run a Correlation analysis using EXCEL to explore the relationship between the two company/stock/ prices.(6 Marks)

1. Show the output from Excel
2. Interpret the correlation coefficient.
3. Do you think combining these two stocks will reduce risk of investment in your portfolio? Explain.

Date	stock 1 (b)	stock 2 (sq)
	weekly rate of return	deviation of standard rate of return	weekly rate of return	DEVIDATION OF STANDARD RATE OF RETURN
1/01/2021	0.585		239.48
8/01/2021	0.555	-5.128205128	232.79	-2.793552698
15/01/2021	0.565	1.801801802	219.62	-5.657459513
22/01/2021	0.745	31.85840708	219.91	0.132046262
29/01/2021	0.665	-10.73825503	237.72	8.098767678
5/02/2021	0.63	-5.263157895	265.93	11.86690224
12/02/2021	0.585	-7.142857143	270.85	1.850110931
19/02/2021	0.55	-5.982905983	227.11	-16.14916005
26/02/2021	0.53	-3.636363636	218.41	-3.830742812
5/03/2021	0.515	-2.830188679	241.72	10.67258825
12/03/2021	0.515	0	224.3	-7.206685421
19/03/2021	0.5	-2.912621359	208.47	-7.05751226
26/03/2021	0.47	-6	229.51	10.09257927
2/04/2021	0.52	10.63829787	258.37	12.57461549
9/04/2021	0.49	-5.769230769	263.08	1.822967063
16/04/2021	0.45	-8.163265306	245.11	-6.830621864
23/04/2021	0.44	-2.222222222	247.76	1.08114724
30/04/2021	0.39	-11.36363636	223.96	-9.606070391
7/05/2021	0.33	-15.38461538	197.13	-11.97981782
14/05/2021	0.34	3.03030303	204.91	3.946634201
21/05/2021	0.33	-2.941176471	220.9	7.803425894
28/05/2021	0.38	15.15151515	211.43	-4.287007696
4/06/2021	0.38	0	217.14	2.700657428
11/06/2021	0.375	-1.315789474	236.13	8.745509809
18/06/2021	0.48	28	244.15	3.396434168
25/06/2021	0.46	-4.166666667	241.85	-0.942043826
2/07/2021	0.51	10.86956522	235.9	-2.460202605
9/07/2021	0.5	-1.960784314	235.16	-0.313692242
16/07/2021	0.475	-5	260.59	10.81391393
23/07/2021	0.46	-3.157894737	255.28	-2.037683718
30/07/2021	0.415	-9.782608696	281.81	10.39251018
6/08/2021	0.41	-1.204819277	268.59	-4.691103935
13/08/2021	0.42	2.43902439	257.35	-4.184817007
20/08/2021	0.42	0	262.13	1.857392656
27/08/2021	0.42	0	265.94	1.453477282
3/09/2021	0.39	-7.142857143	251.54	-5.414755208
10/09/2021	0.385	-1.282051282	255.09	1.411306353
17/09/2021	0.35	-9.090909091	266.72	4.559175193
24/09/2021	0.355	1.428571429	239.84	-10.0779844
1/10/2021	0.37	4.225352113	249.16	3.885923949
8/10/2021	0.485	31.08108108	247.41	-0.702359929
15/10/2021	0.49	1.030927835	265.08	7.141991027
22/10/2021	0.52	6.12244898	261.33	-1.41466727
29/10/2021	0.57	9.615384615	247.46	-5.307465656
5/11/2021	0.585	2.631578947	226.51	-8.466014709
12/11/2021	0.555	-5.128205128	230.35	1.695289391
19/11/2021	0.525	-5.405405405	215.65	-6.381593228
26/11/2021	0.5	-4.761904762	192.15	-10.89728727
3/12/2021	0.475	-5	186.75	-2.81030445
10/12/2021	0.45	-5.263157895	165.88	-11.17536814
17/12/2021	0.455	1.111111111	167.71	1.103207138
24/12/2021	0.465	2.197802198	165.34	-1.413153658
31/12/2021	0.465	0	144.66	-12.50756018
7/01/2022	0.465	0	136.95	-5.329738698
14/01/2022	0.475	2.150537634	127.58	-6.841913107
21/01/2022	0.405	-14.73684211	105.64	-17.19705283
28/01/2022	0.45	11.11111111	101.5	-3.918970087
4/02/2022	0.46	2.222222222	108.94	7.330049261
11/02/2022	0.445	-3.260869565	104.02	-4.516247476
18/02/2022	0.42	-5.617977528	94.99	-8.68102288
25/02/2022	0.425	1.19047619	119.82	26.13959364