Use the Linear trendline in this problem. Beta is the measure of an asset's risk in relation to the market (for example, the S&P500) or to an alternative benchmark or factors. Roughly speaking, a security with a beta of 1.5, will have move, on average, 1.5 times the market return. According to asset pricing theory, beta represents the type of risk, systematic risk, that cannot be diversified away The file linear.xlsx contains the monthly returns on S&P index as well as the monthly return on Cinergy, Dell, Intel, Microsoft, Nortel and Pfizer. Estimate the beta of each stock by finding the slope with reference to S&P Index. R2 Beta Cinergy Dell Intel Microsoft Nortel Pfizer Which stock has the highest risk? Which stock has the highest forecast credibility?
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”