3. Compute the beta for each stock. What does beta measure? (Use SPY as the measurement of the Market). How does this relate to your previous answers? What is the portfolio beta (for the equally weighed)? What does it indicate?

See Data Provided Below; please provide answer and formula in excel

Date	SPY	SBUX	GM	VZ	XPO	RF
Year 1	0.92%	0.48%	0.28%	0.02%	4.30%	0.03%
Year 2	0.01%	3.31%	0.08%	0.39%	-2.21%	0.05%
Year 3	0.81%	-0.56%	0.42%	1.73%	4.94%	0.32%
Year 4	1.49%	0.38%	1.45%	0.45%	6.82%	0.93%
Year 5	0.44%	1.56%	-0.28%	1.31%	-1.57%	1.94%