In: Finance
Characteristic Line and Security Market Line
You are given the following set of data:
| HISTORICAL RATES OF RETURN | ||||
| Year | NYSE | Stock X | ||
| 1 | - 26.5% | - 17.0% | ||
| 2 | 37.2 | 16.0 | ||
| 3 | 23.8 | 14.0 | ||
| 4 | - 7.2 | 5.0 | ||
| 5 | 6.6 | 9.9 | ||
| 6 | 20.5 | 19.4 | ||
| 7 | 30.6 | 17.9 | ||
| Stock X | NYSE | |||
| Average return, | % | % | ||
| Standard deviation, σ | % | % |
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -
