To determine: The first-pass regression as worked out by Chen, Roll and Ross is to be performed and the relevant summary statistics is to be tabulated along with the estimation of the 12 stocks on the two factors.
Introduction: First pass regression is a time series regression to calculate the betas of retreats portfolios.This is generally tested implication of the
1. Establishing sample data,
2. Estimating the SCL (security characteristic line), and
3. Estimating the SML (security market line).
Answer to Problem 8PS
The table given below depicts the first pass regressions.
A | B | C | D | E | F | G | H | I | |
R-Square | |||||||||
Observations | |||||||||
Intercept | |||||||||
Beta M | 0.41 | ||||||||
Beta F | |||||||||
t- intercept | |||||||||
t- Beta M | |||||||||
t- intercept | |||||||||
t- Beta M | |||||||||
t- Beta F |
Explanation of Solution
Given Information: Information provided in the question that are used to perform first-pass regression as din Chen,Roll and Ross by estimating the betas of the
The calculated first-pass regression through the table given below and tabulated the relevant summary statistics are:
A | B | C | D | E | F | G | H | I | |
R-Square | |||||||||
Observations | |||||||||
Intercept | |||||||||
Beta M | 0.41 | ||||||||
Beta F | |||||||||
t- intercept | |||||||||
t- Beta M | |||||||||
t- intercept | |||||||||
t- Beta M | |||||||||
t- Beta F |
Want to see more full solutions like this?
- Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks.arrow_forwardAssume that you run a regression on the raw returns of the stock of Company J against the raw returns of the market and find an intercept of 1.324 percent and a beta of 2.36. If the risk-free rate is 2.64 percent, and using the concept of Jensen's Alpha, then determine by how much this stock beat the market. Answer in decimal format. For example, if you answer is 3.33%, enter "0.0333"arrow_forwardWhen we test CAPM using historical data, a classic test is to regress excess returns of stocks onto the stock betas, using the following regression specification across stocks: - Rp Rf =α+By+ε where Rup - Rf is the average excess return of a security or portfolio, ẞ is the estimated beta of the security or portfolio, & is the regression residual, and a (Alpha) and y (Gamma) are regression coefficients. Based on the regression, which of the following statements are true if CAPM is true? Select all two correct statements. The Alpha is zero The Alpha is positive The Gamma is positive The Gamma is zeroarrow_forward
- Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the forecast for t = 6?arrow_forwardUsing the stock price data for any two companies provided below carry out the following tasks: 1.Compute, for each asset: i.Total Returns ii.Expected returns iii.standard deviation iv.Correlation Coefficient 2.Construct the variance-covariance matrix 3.Construct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 4.Reconstruct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 5.Use Solver to determine optimal risky portfolio. 6.Create hypothetical portfolios (commencing from Weight A=0 and weight B=100) 7.Calculate Expected return and Standard Deviation for all the above combinations 8.Graph the efficient frontier 9.Graph the optimal portfolio 10.Assuming that the investors prefers lower level of risk than what a portfolio of risky assets offer, introduce a risk free asset in the portfolio with a return of 3% 11.Using hypothetical weights (A= Portfolio of Risky Assets, B= 1 Risk Free…arrow_forwardUsing the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 20% 2013 - 1% - 13% Stock A Stock B 20% 12% - 9% Print 2012 8% 9% C Done 2014 4% - 9% 2015 11% 27% - Xarrow_forward
- The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %arrow_forwardConsider the following data for a dependent variable y and two independent variables, x1 and 12. 30 12 94 47 10 109 25 18 112 51 16 178 40 94 51 19 175 75 171 36 12 118 59 13 143 77 17 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating Y to ¤1. Predict y if æ1 = 35. b. Develop an estimated regression equation relating y to x2. ŷ = + Predict y if x2 = 25. ŷ = c. Develop an estimated regression equation relating y to ¤1 and 2. Predict y if x1 = 35 and x2 = 25. ŷ =arrow_forwardWhat is portfolio A's CAPM beta based on your analysis? Round off your answer to three digits after the decimal points. State your answer as a percentage point as 1.234. Compute the Treynor measure for portfolio B. Round off your answer to three digits after the decimal point. State your answer as 1.234arrow_forward
- Can you explain, when calculating the mean why the probability is included in the calculation? eg when you're using excel: (0.2*7) + (0.1*7) + (0.3*7) + (0.3*7) + (0.1*7) = 7%arrow_forwardFill the parts in the above table that are shaded in yellow. You will notice that there are nineline items. Using the data generated in the previous question (Question 1);a) Plot the Security Market Line (SML) b) Superimpose the CAPM’s required return on the SML c) Indicate which investments will plot on, above and below the SML?d) If an investment’s expected return (mean return) does not plot on the SML, what doesit show? Identify undervalued/overvalued investments from the graph Please answer A, B, C & Darrow_forwardStocks A and B have the following returns: (Click on the folowing icon a in order to copy its contents into a spreadsheet.) Stock A Stock B 0.08 0.06 0.15 0.05 0.04 0.05 0.01 -0.01 0.09 -0.03 a. What are the expected roturns of the two stocks? b. What are the standard deviations of the returns of the two stocks? c. If their correlation is 048, what is the expected return and standard deviation of a portfolio of 75% stock A and 25% stock B? a. What are the expected returns of the two stocks? The expected return for stock A is (Round to three decimal places.)arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning