hello, I need help with my assignment please. Thank you.

Question

Shakeel · Accepted Answer

1,2,3,4
		Monthly closing price							1	Monthly return
	Date	Apple	Microsoft	Amazon	Visa	PG		S&P 500		Apple	Microsoft	Amazon	Visa	PG		S&P 500		Correlation Matrix
	10/1/15	29.88	52.64	625.90	77.58	76.38		2043.939941											Apple	Microsoft	Amazon	Visa	PG
	11/1/15	29.58	54.35	664.80	79.01	74.84		1940.23999		-1.00%	3.25%	6.22%	1.84%	-2.02%		-5.07%		Apple	1.0000	0.6457	0.5022	0.5887	0.3264
	12/1/15	26.32	55.48	675.89	77.55	79.41		1932.22998		-11.02%	2.08%	1.67%	-1.85%	6.11%		-0.41%		Microsoft	0.6457	1.0000	0.6514	0.7210	0.2038
	1/1/16	24.33	55.09	587.00	74.49	81.69		2059.73999		-7.52%	-0.70%	-13.15%	-3.95%	2.87%		6.60%		Amazon	0.5022	0.6514	1.0000	0.5971	0.1187
	2/1/16	24.17	50.88	552.52	72.39	80.29		2065.300049		-0.67%	-7.64%	-5.87%	-2.82%	-1.71%		0.27%		Visa	0.5887	0.7210	0.5971	1.0000	0.2048
	3/1/16	27.25	55.23	593.64	76.48	82.31		2096.949951		12.72%	8.55%	7.44%	5.65%	2.52%		1.53%		PG	0.3264	0.2038	0.1187	0.2048	1.0000
	4/1/16	23.43	49.87	659.59	77.24	80.12		2098.860107		-13.99%	-9.70%	11.11%	0.99%	-2.66%		0.09%
	5/1/16	24.97	53.00	722.79	78.94	81.04		2173.600098		6.53%	6.28%	9.58%	2.20%	1.15%		3.56%
	6/1/16	23.90	51.17	715.62	74.17	84.67		2170.949951		-4.27%	-3.45%	-0.99%	-6.04%	4.48%		-0.12%
	7/1/16	26.05	56.68	758.81	78.05	85.59		2168.27002		9.01%	10.77%	6.04%	5.23%	1.09%		-0.12%
	8/1/16	26.53	57.46	769.16	80.90	87.31		2126.149902		1.81%	1.38%	1.36%	3.65%	2.01%		-1.94%
	9/1/16	28.26	57.60	837.31	82.70	89.75		2198.810059		6.55%	0.24%	8.86%	2.22%	2.79%		3.42%
	10/1/16	28.39	59.92	789.82	82.51	86.80		2238.830078		0.43%	4.03%	-5.67%	-0.23%	-3.29%		1.82%
	11/1/16	27.63	60.26	750.57	77.32	82.46		2278.870117		-2.66%	0.57%	-4.97%	-6.29%	-5.00%		1.79%
	12/1/16	28.96	62.14	768.66	78.02	84.08		2363.639893		4.80%	3.12%	2.41%	0.91%	1.96%		3.72%
	1/1/17	30.34	64.65	823.48	82.71	87.60		2362.719971		4.77%	4.04%	7.13%	6.01%	4.19%		-0.04%
	2/1/17	34.25	63.98	845.04	87.94	91.07		2384.199951		12.89%	-1.04%	2.62%	6.32%	3.96%		0.91%
	3/1/17	35.92	65.86	886.54	88.87	89.85		2411.800049		4.87%	2.94%	4.91%	1.06%	-1.34%		1.16%
	4/1/17	35.91	68.46	924.99	91.22	87.33		2423.409912		-0.01%	3.95%	4.34%	2.64%	-2.80%		0.48%
	5/1/17	38.19	69.84	994.62	95.23	88.09		2470.300049		6.34%	2.02%	7.53%	4.40%	0.87%		1.93%
	6/1/17	36.01	68.93	968.00	93.78	87.15		2471.649902		-5.72%	-1.30%	-2.68%	-1.52%	-1.07%		0.05%
	7/1/17	37.18	72.70	987.78	99.56	90.82		2519.360107		3.27%	5.47%	2.04%	6.16%	4.21%		1.93%
	8/1/17	41.00	74.77	980.60	103.52	92.27		2575.26001		10.27%	2.85%	-0.73%	3.98%	1.60%		2.22%
	9/1/17	38.53	74.49	961.35	105.24	90.98		2584.840088		-6.02%	-0.37%	-1.96%	1.66%	-1.40%		0.37%
	10/1/17	42.26	83.18	1105.28	109.98	86.34		2673.610107		9.68%	11.67%	14.97%	4.50%	-5.10%		3.

hello, I need help with my assignment please. Thank you.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment