| | | | Your name |
| | | | Company name / ticker | KO |
| | | Beta | | Adjusted beta |
| | | | | standard error or the beta estimate |
| | | | | 95% confidence interval for Beta |
| | | | | lower bound |
| | | | | upper bound |
| | For percentage of risk that is systematic, use the r-squared of the regression |
| | | Systematic Risk | | Unsystematic Risk | | Total risk* |
| | percentage | | + | | = | 100% |
| | | compute the variance of returns on your stock using VAR.S(returns) |
| There should be 3 tabs in your completed workbook: |
| | 1. A sheet that contains the weekly returns for stock and index |
| | 2. A sheet with the regression output |
| | 3. This sheet will all cells completed |
ABK
Summarypageforbetaassignmentsummer2018.xlsx
