Regression Analysis of 5 UK Stocks-Barclays, HSBC, Astra, Reuters, Marks & Spencer
Based on a period of 7 years, Run the regression analysis in Excel for 5 UK stocks.
Use the FTSE-100 index to calculate the expected return on the market.
1) Use a 5% significant level, to test for the significance of the intercept and slope. Comment on the results.
2) Estimete the total risk explained by the market and the total risk not explained by the market. Comment on the results.
3) Estimate the variance of betas (the betas from the regression) and the variance of the regression. Comment on the results.
The solution does a Regression Analysis of 5 UK Stocks-Barclays, HSBC, Astra, Reuters, Marks & Spencer and:
1) tests for the significance of the intercept and slope
2) estimetes the total risk explained by the market and the total risk not explained by the market
3) estimate the variance of betas and the variance of the regression.
- Plain text response
- Attached file(s):
- 11755-Statistics solution.xls
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Multiple Regression- standard error of estimate - Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks. (Y). Two variables thought to in ...
- Statistics - Regression and hypothesis testing
- Regression - 1)Given the regression equation: Y = 1.3479 + 0.3978 X, what is the fitted value (orY ˆ ) if X = -3? 2) Calculate bo, b1 for the information provide below X Y -2 9 0 5 -0.5 7 1 100
- regression - When we carry out a regression, we assume a direct causal relationship. In a correlation analysis, we don't make such an assumption, but nevertheless determine whether 2 variables are related. Briefl ...
- Coefficients - b. As the value of the correlation coefficient increases from 0 to 1, or decreases from 0 to -1, how do the points of the scatter plot fit the regression line?
