1) What is the statistical interpretation of Beta?
2) What is the financial theory interpretation of Beta?
3) What is the statistical interpretation of R2
4) What is the financial theory interpretation of R2
5) Does the R2 seem reasonable? Why?
6) What is the Yahoo Beta for P&G? Expalin any difference.
1) What is the statistical interpretation of Beta?
2) What is the financial theory interpretation of Beta?
3) What is the statistical interpretation of R2
4) What is the financial theory interpretation of R2
5) Does the R2 seem reasonable? Why?
6) What is the Yahoo Beta for P&G? Expalin any difference.
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
Use the Excel Template and the table of prices and dividendsbelow to answer the next seven questions:
Kellogg Ticker = K | S&P 500 | ||
Month | Dividend | Price | Price |
Jan-17 | 72.71 | 2278.87 | |
Feb-17 | 74.07 | 2363.64 | |
Mar-17 | 0.52 | 72.61 | 2362.72 |
Apr-17 | 71 | 2384.2 | |
May-17 | 0.52 | 71.6 | 2411.8 |
Jun-17 | 69.46 | 2423.41 | |
Jul-17 | 68 | 2470.3 | |
Aug-17 | 0.54 | 65.46 | 2471.65 |
Sep-17 | 62.37 | 2519.36 | |
Oct-17 | 62.53 | 2575.26 | |
Nov-17 | 0.54 | 66.16 | 2584.84 |
Dec-17 | 67.98 | 2673.61 | |
Jan-18 | 68.11 | 2823.81 | |
Feb-18 | 66.2 | 2713.83 | |
Mar-18 | 0.54 | 65.01 | 2640.87 |
Apr-18 | 58.9 | 2648.05 | |
May-18 | 0.54 | 64.39 | 2705.27 |
Jun-18 | 69.87 | 2718.37 | |
Jul-18 | 71.03 | 2816.29 | |
Aug-18 | 0.56 | 71.79 | 2901.52 |
Sep-18 | 70.02 | 2913.98 | |
Oct-18 | 65.48 | 2711.74 | |
Nov-18 | 0.56 | 63.65 | 2760.17 |
Dec-18 | 59.23 | 2545.94 |
1. (EXCEL TEMPLATE)Calculate monthly returns for Kellogg (K) and the S&P 500. Besure to include the dividends for Kellogg in the return.
2. (EXCEL TEMPLATE)Calculate the average, standard deviation, and variance of returnsfor Kellogg (K) and the S&P 500.
3. (EXCEL TEMPLATE)Use the covariance equation to find the covariancebetween Kellogg (K) and the S&P 500.
4. (EXCEL TEMPLATE)Use the correlation coefficient equation to findthe correlation coefficient between Kellogg (K and the S&P500.
5. (EXCEL TEMPLATE) Use the betaequation to find the beta of Kellogg (KY).
6. (EXCEL TEMPLATE)Use Regression Analysis to find the beta for Kellogg (you shouldget the same answer as in question 5).
7. (EXCELTEMPLATE)
a. Whatis the probability that the true beta for Kellogg is equal tozero?
b. If the market risk premium is 6%and the risk-free rate is 3%, what return would you expect to earnon Kellogg given YOUR beta calculation?
c. Go to the website for Yahoo Financeand to the Profile tab. List two products the company makes.
d. Go to the website for Yahoo Financeand to the Summary tab. What beta is listed?
e. Give a possible reason for why yourcalculated beta is different than the Yahoo beta.