# Question: The beta of a stock is found by running a

The beta of a stock is found by running a regression with the monthly return on a market index as the explanatory variable and the monthly return on the stock as the dependent variable. The beta of the stock is then the slope of this regression line.

a. Explain why most stocks have a positive beta.

b. Explain why a stock with a beta with absolute value greater than one is more volatile than the market index and a stock with a beta less than one (in absolute value) is less volatile than the market index.

c. Use the data in the file P10_45.xlsx to estimate the beta for each of the four companies listed: Caterpillar, Goodyear, McDonalds, and Ford. Use the S&P 500 as the market index.

d. For each of these companies, what percentage of the variation in its returns is explained by the variation in the market index? What percentage is unexplained by variation in the market index?

e. Verify (using Excel’s COVAR and VARP functions) that the beta for each company is given by

Covariance between Company and Market / Variance of Market

Also, verify that the correlation between each company’s returns and the market’s returns is the square root of R2.

a. Explain why most stocks have a positive beta.

b. Explain why a stock with a beta with absolute value greater than one is more volatile than the market index and a stock with a beta less than one (in absolute value) is less volatile than the market index.

c. Use the data in the file P10_45.xlsx to estimate the beta for each of the four companies listed: Caterpillar, Goodyear, McDonalds, and Ford. Use the S&P 500 as the market index.

d. For each of these companies, what percentage of the variation in its returns is explained by the variation in the market index? What percentage is unexplained by variation in the market index?

e. Verify (using Excel’s COVAR and VARP functions) that the beta for each company is given by

Covariance between Company and Market / Variance of Market

Also, verify that the correlation between each company’s returns and the market’s returns is the square root of R2.

## Answer to relevant Questions

Continuing the previous problem, explore whether the beta for these companies changes through time. For example, are the betas based on 1990s data different from those based on 2000s data? Or are data based on only five ...The file P03_55.xlsx lists the average salary for each Major League Baseball (MLB) team from 2004 to 2009, along with the number of team wins in each of these years.a. Rearrange the data so that there are four long columns: ...The file P02_35.xlsx contains data from a survey of 500 randomly selected households. For this problem, use Monthly Payment as the dependent variable in several regressions, as explained below. a. Beginning with Family Size, ...The file P10_66.xlsx contains monthly cost accounting data on overhead costs, machine hours, and direct material costs. This problem will help you explore the meaning of R2 and the relationship between R2 and correlations.a. ...Explore the relationship between the selling prices (Y) and the appraised values (X) of the 148 homes in the file P02_11.xlsx by estimating a simple linear regression equation. Find a 95% confidence interval for the ...Post your question