You are given the following set of data: Construct a scatter diagram showing the relationship between returns

Question:

You are given the following set of data:

Construct a scatter diagram showing the relationship between returns on Stock Y and the market. Use a spreadsheet or a calculator with a linear regression function to estimate beta.

b. Give a verbal interpretation of what the regression line and the beta coefficient show about Stock Y's volatility and relative riskiness as compared with those of other stocks.

c. Suppose the scatter of points had been more spread out, but the regression line was exactly where your present graph shows it. How would this affect (1) the firm's risk if the stock is held in a one-asset portfolio and (2) the actual risk premium on the stock if the CAPM holds exactly?

d. Suppose the regression line had been downward sloping and the beta coefficient had been negative. What would this imply about (1) Stock Y's relative riskiness, (2) its correlation with the market, and (3) its probable risk premium?

HISTORICAL RATES OF RETURN Year NYSE Stock Y 4.0% 3.0% 1 18.2 14.3 19.0 9.1 (14.7) (6.0) (15.3) (26.5) 37.2 33.1 6. 23.8

Beta Coefficient
Beta coefficient is a measure of sensitivity of a company's stock price to movement in the broad market index. It is an indicator of a stock's systematic risk which is the undiversifiable risk inherent in the whole financial system. Beta coefficient... Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...