Homework Answers
1. Correlation can be measued using statistical method whose
formula is given
Covarinace of the stock with market /Variance of Market It is used
to asses the degree of linear relationship with the market or
between two stocks.
2. Choosing stocks with lower correlation help in diversifying the
portfolio. Lower the correlation lower the variance and higher the
correlation higher the variance..
3. Excel formula to calculate correlation
| A | B | C | ||
| 1 | Year | Market return | Stock A return | |
| 2 | 2010 | -0.06 | -0.01 | |
| 3 | 2011 | 0.01 | 0.04 | |
| 4 | 2012 | 0.05 | 0.05 | |
| 5 | 2013 | -0.03 | 0.027 | |
| 6 | 2014 | 0 | 0.075 | |
| 7 | 2015 | 0.1 | 0.08 | |
| Correlation coefficient | 0.81 | (CORREL(B2:B7,C2:C7) | ||
This means that since the correlation is positive They are
positively and closely related to each other .
Add Answer to:
ww, answer e ToOWng quesUOns 1. How is correlation measured? 2 What is the importance of...
1. How is correlation measured? 2. What is the importance of correlation in investment theory? 3....
1. How is correlation measured? 2. What is the importance of correlation in investment theory? 3. In Excel use a function = CORREL (highlight the first array of data: Market Return, second array of data: Stock A return). Year Market Return Stock A return 2010 -0.06 -0.01 2011 0.01 0.04 2012 0.05 0.05 2013 -0.03 0.027 2014 0.00 0.075 2015 0.10 0.08 Find the correlation coefficient. Explain what that number means regarding stock A and market rate of return.
identify the leading and lagging measures, find the correlation matrix, and purpose a cause and effect...
identify the leading and lagging measures, find the correlation matrix, and purpose a cause and effect model using the strongest correlations Myatt Steak House 2010 2011 2012 2013 2014 Order Accuracy X1 86.0% 86.0% 89.0% 90.0% 95.0% Timeliness of Delivery X2 84.0% 82.0% 86.0% 93.0% 95.0% Table Cleanliness X3 4.8 4.8 5.1 5.6 5.8 Customer Satisfication X4 93.4% 93.2% 94.2% 95.3% 96.7% Total # Complaints X5 492 467 431 326 310 Customer Referrals X6 6 12 24 48 96 Gross...
Note the return series below and answer the following questions 1. What is the average nominal...
Note the return series below and answer the following
questions
1. What is the average nominal return earned on large company
stocks? (Enter percentages as decimals and round to 4 decimal
places)
2. What is the average real return earned on large company stocks?
(Enter percentages as decimals and round to 4 decimal places)
3. What is the average risk premium earned on large company
stocks? (Enter percentages as decimals and round to 4 decimal
places)
4. What is the...
Radnor Healthcare System, an 800-bed institution, is located in a highly competitive, urban market area. Using...
Radnor Healthcare System, an 800-bed institution, is located in a highly competitive, urban market area. Using the financial ratios from Exhibit 4.22 for the current and previous years, evaluate Radnor's financial condition, focusing on revenue, expense, and profitability; liquidity, activity, and capital structure ratios, and compare them to national industry benchmarks for Radnor's bed size, using the data from Exhibit 4.16a. EXHIBIT 4.22 SELECTED FINANCIAL RATIOS FOR RADNOR HEALTHCARE SYSTEM Ratio 20X1 20x0 1.85 1.50 0.43 70 155 60 2.10...
What is the correlation between Female and ln(MarketValue),PXU is ________ (Round your response to three decimal...
What is the correlation between Female and
ln(MarketValue),PXU is ________ (Round your response to
three decimal places)
Exercise 8.7 -Question Help This problem is inspired by a study of the "gender gap* in earnings in top corporate jobs [Bertrand and Hallock (2001) The study compares total compensation among top executives in a large set of U.S. public corporations in the 1990s (Each year these publicly traded corporations must report total compensation levels for their top five executives.) Let Fermale be...
Determine the Capacitance in uF (micro-Farads) of the system below using the data, graph and tolerance...
Determine the Capacitance in uF (micro-Farads) of the system
below using the data, graph and tolerance graph below.
R -ww G(s) 1/(RCs+1) ei R =1000 ohms 1 Slope T c(t) c() = 1 - e-(1/T B 0.632 Tolerance graph (Ts(2%) = 4*T): A A 4T 2T 3T 5T 63.2% 86.5% 95% 98.2% Of output 99.3% 0.75 0.5 Output curve: 0.25 0 0 0.025 0.05 0.075 0.1 0.125 Data: x(time) y(amplitude) 0.001 0.09516258196 0.002 0.1812692469 0.2591817793 0.003 0.329679954 0.004 0.3934693403 0.005...
1. You buy 100 shares of Tidepool Co. for $36each and 205 shares of Madfish, Inc.,...
1. You buy 100 shares of Tidepool Co. for $36each and 205 shares
of Madfish, Inc., for $18 each. What are the weights in your
portfolio? The weight of Tidepool Co. stock in the portfolio is __
%. (Round to one decimal place.)
2. Fremont Enterprises has an expected return of 14% and
Laurelhurst News has an expected return of 21%. If you put 50% of
your portfolio in Laurelhurst and 50% in Fremont, what is the
expected return of...
answer these 2 questions ! 1. 2. 6.2.83 Complete the following table. 20.05 20.025 20.01 20.10...
answer these 2 questions !
1.
2.
6.2.83 Complete the following table. 20.05 20.025 20.01 20.10 1.28 20.005 Click here to view page 1 of the standard normal table. Click here to view page 2 of the standard normal table. 20.10 20.05 0.025 20.01 20.005 1.28 (Type integers or decimals rounded to two decimal places as needed.) tents ccess Library ptions in Is Enter your answer in the edit fields and then click Check Answer. All parts showing Clear All...
As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future
As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future macroeconomic conditions as wells as the course of future short-term interest rates, your presentation will consist of thefollowing:-Plot the yield curve for each year between 2006 – 2020 and display these data on one graph.-For each year indicate...
As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future
As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future macroeconomic conditions as wells as the course of future short-term interest rates, your presentation will consist of the following:-Plot the yield curve for each year between 2006 – 2020 and display these data on one graph.-For each year...
Note the return series below and answer the following
questions
1. What is the average nominal return earned on large company
stocks? (Enter percentages as decimals and round to 4 decimal
places)
2. What is the average real return earned on large company stocks?
(Enter percentages as decimals and round to 4 decimal places)
3. What is the average risk premium earned on large company
stocks? (Enter percentages as decimals and round to 4 decimal
places)
4. What is the...
Radnor Healthcare System, an 800-bed institution, is located in a highly competitive, urban market area. Using the financial ratios from Exhibit 4.22 for the current and previous years, evaluate Radnor's financial condition, focusing on revenue, expense, and profitability; liquidity, activity, and capital structure ratios, and compare them to national industry benchmarks for Radnor's bed size, using the data from Exhibit 4.16a. EXHIBIT 4.22 SELECTED FINANCIAL RATIOS FOR RADNOR HEALTHCARE SYSTEM Ratio 20X1 20x0 1.85 1.50 0.43 70 155 60 2.10...
What is the correlation between Female and
ln(MarketValue),PXU is ________ (Round your response to
three decimal places)
Exercise 8.7 -Question Help This problem is inspired by a study of the "gender gap* in earnings in top corporate jobs [Bertrand and Hallock (2001) The study compares total compensation among top executives in a large set of U.S. public corporations in the 1990s (Each year these publicly traded corporations must report total compensation levels for their top five executives.) Let Fermale be...
Determine the Capacitance in uF (micro-Farads) of the system
below using the data, graph and tolerance graph below.
R -ww G(s) 1/(RCs+1) ei R =1000 ohms 1 Slope T c(t) c() = 1 - e-(1/T B 0.632 Tolerance graph (Ts(2%) = 4*T): A A 4T 2T 3T 5T 63.2% 86.5% 95% 98.2% Of output 99.3% 0.75 0.5 Output curve: 0.25 0 0 0.025 0.05 0.075 0.1 0.125 Data: x(time) y(amplitude) 0.001 0.09516258196 0.002 0.1812692469 0.2591817793 0.003 0.329679954 0.004 0.3934693403 0.005...
1. You buy 100 shares of Tidepool Co. for $36each and 205 shares
of Madfish, Inc., for $18 each. What are the weights in your
portfolio? The weight of Tidepool Co. stock in the portfolio is __
%. (Round to one decimal place.)
2. Fremont Enterprises has an expected return of 14% and
Laurelhurst News has an expected return of 21%. If you put 50% of
your portfolio in Laurelhurst and 50% in Fremont, what is the
expected return of...
answer these 2 questions !
1.
2.
6.2.83 Complete the following table. 20.05 20.025 20.01 20.10 1.28 20.005 Click here to view page 1 of the standard normal table. Click here to view page 2 of the standard normal table. 20.10 20.05 0.025 20.01 20.005 1.28 (Type integers or decimals rounded to two decimal places as needed.) tents ccess Library ptions in Is Enter your answer in the edit fields and then click Check Answer. All parts showing Clear All...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago