Use the following information of these various stocks to find 5 points to draw the efficient frontier using these portfolios and then compute the efficient frontier using Betas instead of covariances using SPY as the market portfolio. Compute the optimal risky portfolio using Betas. Show steps and chart on Excel.

Date	AMZN	QQQ	SPY	VZ	MSFT	WMT	IBM
2006-01-01	47.869999	37.85711	96.75684	13.95086	19.76223	33.29514	58.33
2006-01-08	44.400002	38.12322	96.93763	14.52704	19.96785	32.94681	57.10774
2006-01-15	43.919998	36.58872	94.89615	13.96727	19.39503	32.65651	55.86493
2006-01-22	45.220001	37.35152	96.83216	14.50899	20.40849	33.26611	55.63147
2006-01-29	38.330002	36.29599	95.12214	14.26973	20.22489	33.01212	54.91051
2006-02-05	38.52	36.33148	95.40085	14.97847	19.60067	33.20081	55.84432
2006-02-12	39.189999	36.55323	97.03555	15.70077	19.60801	33.45477	55.55777
2006-02-19	38.349998	36.59757	97.48753	15.26287	19.62288	32.98308	55.13787
2006-02-26	37.209999	36.76611	96.9979	15.15904	19.84393	32.896	55.0415
2006-03-05	36.220001	35.97667	96.86981	15.43442	20.02078	32.896	56.14975
2006-03-12	35.990002	36.76611	98.39907	15.53373	20.26395	33.88295	57.34063
2006-03-19	35.470001	36.65877	98.48029	15.78654	19.90288	35.10099	57.38193
2006-03-26	36.529999	37.21796	98.19287	15.37574	20.05026	34.40904	56.7693
2006-04-02	37.09	37.56414	97.97354	15.25385	20.07973	33.52039	56.77618
2006-04-09	36.619999	37.36886	97.3458	15.00768	19.94709	33.3383	56.43198
2006-04-16	36.029999	37.28009	99.19119	14.87504	20.00604	33.37471	56.21172
2006-04-23	35.209999	37.14695	99.43324	15.10831	17.79543	32.79929	56.67981
2006-04-30	35.040001	37.42211	100.2274	15.10374	17.53753	34.4163	57.32687
2006-05-07	32.73	35.6735	97.74667	14.54113	17.0733	33.89916	56.71423
2006-05-14	33.939999	34.92789	96.1281	14.13403	16.62381	34.46729	55.46159
2006-05-21	36.07	35.05216	97.09625	14.4039	17.54673	36.29128	55.78628