Calculate Beta using a regression analysis in excel and the data below. Discuss/interpret the meaning of the X variable (Beta) and the intercept. What is the relationship between the market and Zcorp?
Year |
Market |
Zcorp |
1 |
18.70% |
20.00% |
2 |
8.00% |
9.00% |
3 |
-11.00% |
-13.00% |
4 |
15.00% |
17.00% |
5 |
22.50% |
18.00% |
6 |
13.70% |
12.00% |
7 |
40.00% |
39.00% |
8 |
10.00% |
9.00% |
9 |
-9.00% |
-10.00% |
10 |
-4.00% |
-6.00% |
Get Answers For Free
Most questions answered within 1 hours.