Estimate the beta coefficient for each stock using two different approaches. What can you conclude about the efficient frontier's your portfolio analysis has concluded?

Lant BIU- a A Merge & Center Conditional Formatting $ % 8-9 Paste Format Painter Clipboard Number Tont Alignment M16 x L E K B F H D G M 1 Stock and Portfolio Analysis 2 3 Stock A 12 8 15 Stock C -3 14 Stock B 7 3 9 4 2 Market 6 7 11 7 6 3 10 4 UNNA 6 18 -5 15 -2 4 -5 16 6 7 9 4 5 Year 1 6 Year 2 7 Year B Year 4 9 Year 5 10 Year 6 11 Year 7 12 Year 8 13 Year 9 14 Year 10 15 16 17 18 19 20 21 22 23 8 3 11 7 6 8 11 10 24 25 26 Sheet1 Sheet2 Sheet 8 Formatter Merge & Center - 0904 6 % - 5 net Det Format Conditional Format Formatting table Styles Cipboard M! M16 0 M CUTE CA 100 HC Cane wie A turn 500 500 Graphite MEL L M 500 000 200 SP IP 02 000 00 300 300 De The Purwa ANC 900 CD 000 22 000 - > 000 000 00 000 0 000 000 000 0 000 Barat DO Fawn 300 100 000 D 00 000 0 000 000 000 000 000 0.00 HE EN D Sheet1 Sheet E M N 40 A 0100 0.00 0.00 6.70 40 49 0.00 0.00 51 Portfolio A&C 3 0.10 Return Risk COD DOU 0.00 0.00 000 000 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 000 0.00 0.00 58 59 60 B1 62 Portfolio BAC 020 ES 0:00 0.10 Return Risk 0.00 000 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 000 0.00 000 0.00 0.00 0.00 000 0.00 0.00 1 0.00 610 00:16 840 05 0.00 5. Questions: What can you conclude about the efficient frontier's your portfolio analysis hanyielded? Estimate the Beta Coefficient for each stock using two different approaches Lant BIU- a A Merge & Center Conditional Formatting $ % 8-9 Paste Format Painter Clipboard Number Tont Alignment M16 x L E K B F H D G M 1 Stock and Portfolio Analysis 2 3 Stock A 12 8 15 Stock C -3 14 Stock B 7 3 9 4 2 Market 6 7 11 7 6 3 10 4 UNNA 6 18 -5 15 -2 4 -5 16 6 7 9 4 5 Year 1 6 Year 2 7 Year B Year 4 9 Year 5 10 Year 6 11 Year 7 12 Year 8 13 Year 9 14 Year 10 15 16 17 18 19 20 21 22 23 8 3 11 7 6 8 11 10 24 25 26 Sheet1 Sheet2 Sheet 8 Formatter Merge & Center - 0904 6 % - 5 net Det Format Conditional Format Formatting table Styles Cipboard M! M16 0 M CUTE CA 100 HC Cane wie A turn 500 500 Graphite MEL L M 500 000 200 SP IP 02 000 00 300 300 De The Purwa ANC 900 CD 000 22 000 - > 000 000 00 000 0 000 000 000 0 000 Barat DO Fawn 300 100 000 D 00 000 0 000 000 000 000 000 0.00 HE EN D Sheet1 Sheet E M N 40 A 0100 0.00 0.00 6.70 40 49 0.00 0.00 51 Portfolio A&C 3 0.10 Return Risk COD DOU 0.00 0.00 000 000 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 000 0.00 0.00 58 59 60 B1 62 Portfolio BAC 020 ES 0:00 0.10 Return Risk 0.00 000 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 000 0.00 000 0.00 0.00 0.00 000 0.00 0.00 1 0.00 610 00:16 840 05 0.00 5. Questions: What can you conclude about the efficient frontier's your portfolio analysis hanyielded? Estimate the Beta Coefficient for each stock using two different approaches