Question

In: Finance

Run the regression of Ford returns (Y variable) on GM returns (X variable), and report the...

Run the regression of Ford returns (Y variable) on GM returns (X variable), and report the regrssion statistics
Date Ford GM
1-Dec-99 5.52% -1.50%
3-Jan-00 -5.70% 10.83%
1-Feb-00 -16.32% -4.99%
1-Mar-00 10.32% 8.89%
3-Apr-00 20.27% 13.05%
1-May-00 -11.30% -24.12%
1-Jun-00 -7.81% -17.79%
3-Jul-00 9.47% -1.94%
1-Aug-00 -9.18% 23.95%
1-Sep-00 5.42% -7.14%
2-Oct-00 3.63% -4.43%
1-Nov-00 -12.89% -19.61%
1-Dec-00 3.02% 2.89%
2-Jan-01 21.56% 5.43%
1-Feb-01 -3.29% 4.56%
Intercept
Slope
R-squared value

Solutions

Expert Solution

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.405741
R Square 0.164626
Adjusted R Square 0.100366
Standard Error 0.110263
Observations 15
ANOVA
df SS MS F Significance F
Regression 1 0.031147 0.031147 2.561886 0.133478
Residual 13 0.158054 0.012158
Total 14 0.189201
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.011359 0.028527 0.398176 0.696963 -0.05027 0.072987 -0.05027 0.072987
GM 0.36224 0.226317 1.600589 0.133478 -0.12669 0.851168 -0.12669 0.851168

Intercept = 0.011359

Slope = 0.36224

R squared = 0.164626

Incase of any doubt, please comment. I will get back to you. Thank you!! Have a nice day


Related Solutions

You run a regression of X’ Company stock's returns against the market returns over a five-year...
You run a regression of X’ Company stock's returns against the market returns over a five-year time period (using monthly data) and come up with the following output: Intercept = .20%, Slope = 1.20 Your stock had an annualized standard deviation of returns of 40% whereas the market standard deviation was only 20%. The annualized risk-free rate, on average, over the last five years has been 6% and it is currently at 7%. The risk premium = 8.5%. The annualized...
You run a regression of X’ Company stock's returns against the market returns over a five-year...
You run a regression of X’ Company stock's returns against the market returns over a five-year time period (using monthly data) and come up with the following output: Intercept = .20%, Slope = 1.20 Your stock had an annualized standard deviation of returns of 40% whereas the market standard deviation was only 20%. The annualized risk-free rate, on average, over the last five years has been 6% and it is currently at 7%. The risk premium = 8.5%. The annualized...
1- The regression of X on Y is not the same as the regression of Y...
1- The regression of X on Y is not the same as the regression of Y on X. Why is this? Select one: a. Because the regression minimises the residuals of y, not the residuals of x. b. Because unlike correlation, regression assumes X causes Y. c. Because one goes through (mean x, mean y) whereas the other goes through (mean y, mean x). d. Because the F test divides MSy by MSx, not the other way round. 2- Using...
Using a regression to estimate beta, we run a regression with returns on the stock in...
Using a regression to estimate beta, we run a regression with returns on the stock in question plotted on the Y axis and returns on the market portfolio plotted on the X axis. The intercept of the regression line, which measures relative volatility, is defined as the stock’s beta coefficient, or b. True. FALSE A 10-year corporate bond has an annual coupon payment of 2.8%. The bond is currently selling at par ($1,000). Which of the following statement is NOT...
Using a regression to estimate beta, we run a regression with returns on the stock in...
Using a regression to estimate beta, we run a regression with returns on the stock in question plotted on the Y axis and returns on the market portfolio plotted on the X axis. The intercept of the regression line, which measures relative volatility, is defined as the stock’s beta coefficient, or b. True. FALSE A 10-year corporate bond has an annual coupon payment of 2.8%. The bond is currently selling at par ($1,000). Which of the following statement is NOT...
A GM and a Ford bond both have 4 years to maturity. GM has a annual...
A GM and a Ford bond both have 4 years to maturity. GM has a annual coupon rate of 0.066, while Ford has a annual coupon rate of 0.054. Both bonds are semiannual and have a face value of $1000. The GM bond trades at 969.39. What is the yield to maturity (YTM)? What is the price of the Ford bond?
A GM and a Ford bond both have 4 years to maturity. GM has a annual...
A GM and a Ford bond both have 4 years to maturity. GM has a annual coupon rate of 0.061, while Ford has a annual coupon rate of 0.06. Both bonds are semiannual and have a face value of $1000. a.The GM bond trades at 962.35. What is the yield to maturity (YTM)? b.What is the price of the Ford bond?
You have run a regression of monthly returns on a stock against monthly returns on the...
You have run a regression of monthly returns on a stock against monthly returns on the S&P 500 index, and come up with the following output: Rstock = 0.25% + 1.25 RMarket R2 = 0.60 The current one-year treasury bill rate is 4.8%, the current ten-year bond rate is 7.25% and the current thirty-year bond rate is 8%. The firm has 10 million shares outstanding, selling for $10 per share. i. What is the expected return on this stock over...
You have run a regression of monthly returns on a stock against monthly returns on the...
You have run a regression of monthly returns on a stock against monthly returns on the S&P 500 index, and come up with the following output: Rstock = 0.25% + 1.25 RMarket R2 = 0.60 The current one-year treasury bill rate is 4.8%, the current ten-year bond rate is 7.25% and the current thirty-year bond rate is 8%. The firm has 10 million shares outstanding, selling for $10 per share. The mean market return is 8.5% and the ERP is...
Here is the monthly stock price data for Ford Corp. and GM corp: Prices for Ford...
Here is the monthly stock price data for Ford Corp. and GM corp: Prices for Ford and GM stock Date   Ford GM 8-Nov-99 24.44 66.08 1-Dec-99 25.79 65.09 3-Jan-00 24.32 72.14 1-Feb-00 20.35 68.54 1-Mar-00 22.45 74.63 3-Apr-00 27.00 84.37 1-May-00 23.95 64.02 1-Jun-00 22.08 52.63 3-Jul-00 24.17 51.61 1-Aug-00 21.95 63.97 1-Sep-00 23.14 59.40 2-Oct-00 23.98 56.77 1-Nov-00 20.89 45.64 1-Dec-00 21.52 46.96 2-Jan-01 26.16 49.51 1-Feb-01 25.30 51.77 1) What are the monthly returns for Ford and GM...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT