Use Excel to compute the Beta Coefficient for the following security (J), using first, regression analysis to find the slope of the Characteristic Line for J, given the returns for J and the Market Portfolio Below.

Stock J	Market
0.14	0.13
0.07	0.1
0.05	0.12
0.01	0.01
0.11	0.15
0.12	1.6
0.11	0.14
0.15	0.11
0.2	0.06
0.02	0.01
0.01	0.11

Use the data from B. above and Excel to compute the Beta coefficient using the covariation equation.

Complete this assignment in Excel and attach it to the posting board. When completed, scroll down and click on the Post Reply button.