Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357191484
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
thumb_up100%
Chapter 5.4, Problem 29E
J.P. Morgan Asset Management publishes information about financial investments. Over the past 10 years, the expected return for the S&P 500 was 5.04% with a standard deviation of 19.45% and the expected return over that same period for a core bonds fund was 5.78% with a standard deviation of 2.13% (J.P. Morgan Asset Management, Guide to the Markets, 1st Quarter, 2012). The publication also reported that the
- a. Using the information provided, determine the
covariance between the S&P 500 and core bonds. - b. Construct a portfolio that is 50% invested in an S&P 500 index fund and 50% in a core bonds fund. In percentage terms, what are the expected return and standard deviation for such a portfolio?
- c. Construct a portfolio that is 20% invested in an S&P 500 index fund and 80% invested in a core bonds fund. In percentage terms, what are the expected return and standard deviation for such a portfolio?
- d. Construct a portfolio that is 80% invested in an S&P 500 index fund and 20% invested in a core bonds fund. In percentage terms, what are the expected return and standard deviation for such a portfolio?
- e. which of the portfolios in parts (b), (c), and (d) has the largest expected return? which has the smallest standard deviation? which of these portfolios is the best investment alternative?
- f. Discuss the advantages and disadvantages of investing in the three portfolios in parts (b), (c), and (d). would you prefer investing all your money in the S&P 500 index, the core bonds fund, or one of the three portfolios? why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
J. P. Morgan Asset Management publishes information about financial investments. Over the past 10 years, the expected return for the S&P 500 was 5.04 with a standard deviation of 19.45% and the expected return over that same period for a Core Bonds fund was 5.78% with a standard deviation of 2.13% (J. P. Morgan Asset Management, Guide to the Markets, 1st Quarter, 2012). The publication also reported that the correlation between the S&P 500 and Core Bonds is -0.32. You are considering portfolio investments that are composed of an S&P 500 index fund and a Core Bonds fund.
A. Using the information provided, determine the covariance between the S&P 500 and Core Bonds. Round your answer to two decimal places. If required enter negative values as negative numbers.
B. Construct a portfolio that is 50% invested in an S&P 500 index fund and 50% in a Core Bond fund. Round your answers to one decimal place.
r=______x+__________y
In percentage terms, what is the expected…
Example)
What B corresponds to a "typical" low investment-grade PD of 0.01
And a default correlation of 0.05?
Define the term relationship as a perfect positive cross-correlation?
Chapter 5 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Ch. 5.1 - 1. Consider the experiment of tossing a coin...Ch. 5.1 - 2. Consider the experiment of a worker assembling...Ch. 5.1 - 3. Three students scheduled interviews for summer...Ch. 5.1 - Prob. 4ECh. 5.1 - 5. To perform a certain type of blood analysis,...Ch. 5.1 - 6. Listed is a series of experiments and...Ch. 5.2 - 7. The probability distribution for the random...Ch. 5.2 - 8. The following data were collected by counting...Ch. 5.2 - 9. For unemployed persons in the United States,...Ch. 5.2 - 10. The percent frequency distributions of job...
Ch. 5.2 - 11. A technician services mailing machines at...Ch. 5.2 - 12. Time Warner Cable provides television and...Ch. 5.2 - 13. A psychologist determined that the number of...Ch. 5.2 - Prob. 14ECh. 5.3 - 15. The following table provides a probability...Ch. 5.3 - 16. The following table provides a probability...Ch. 5.3 - 17. During the summer of 2014, Coldstream Country...Ch. 5.3 - 18. The American Housing Survey reported the...Ch. 5.3 - 19. West Virginia has one of the highest divorce...Ch. 5.3 - 20. The probability distribution for damage claims...Ch. 5.3 - 21. The following probability distributions of job...Ch. 5.3 - 22. The demand for a product of Carolina...Ch. 5.3 - 23. In Gallup’s Annual Consumption Habits Poll,...Ch. 5.3 - Prob. 24ECh. 5.4 - 25. Given below is a bivariate distribution for...Ch. 5.4 - 26. A person is interested in constructing a...Ch. 5.4 - 27. The Chamber of Commerce in a Canadian city has...Ch. 5.4 - 28. PortaCom has developed a design for a...Ch. 5.4 - 29. J.P. Morgan Asset Management publishes...Ch. 5.4 - 30. In addition to the information in exercise 29...Ch. 5.5 - 31. Consider a binomial experiment with two trials...Ch. 5.5 - Prob. 32ECh. 5.5 - 33. Consider a binomial experiment with n = 20 and...Ch. 5.5 - 34. For its Music 360 survey, Nielsen Co. asked...Ch. 5.5 - 35. The Center for Medicare and Medical Services...Ch. 5.5 - 36. When a new machine is functioning properly,...Ch. 5.5 - 37. According to a 2013 study by the Pew Research...Ch. 5.5 - 38. Military radar and missile detection systems...Ch. 5.5 - 39. Market-share-analysis company Net Applications...Ch. 5.5 - 42. A Gallup Poll showed that 30% of Americans are...Ch. 5.5 - Tracked Emails. According to a 2017 Wired magazine...Ch. 5.6 - 44. Consider a Poisson distribution with μ =...Ch. 5.6 - 45. Consider a Poisson distribution with a mean of...Ch. 5.6 - 46. Phone calls arrive at the rate of 48 per hour...Ch. 5.6 - 47. During the period of time that a local...Ch. 5.6 - Prob. 48ECh. 5.6 - 49. Airline passengers arrive randomly and...Ch. 5.6 - 50. According to the National Oceanic and...Ch. 5.6 - 51. Over 500 million tweets are sent per day...Ch. 5.7 - 52. Suppose N = 10 and r = 3. Compute the...Ch. 5.7 - Prob. 53ECh. 5.7 - 54. A recent survey showed that a majority of...Ch. 5.7 - 55. Blackjack, or twenty-one as it is frequently...Ch. 5.7 - 56. Axline Computers manufactures personal...Ch. 5.7 - 57. The Zagat Restaurant Survey provides food,...Ch. 5.7 -
Suppose that a shipment of 100 boxes of apples...Ch. 5 - 59. The U.S. Coast Guard (USCG) provides a wide...Ch. 5 - 60. The Car Repair Ratings website provides...Ch. 5 - 61. The budgeting process for a midwestern college...Ch. 5 - 62. A bookstore at the Hartsfield-Jackson Airport...Ch. 5 - 63. The Knowles/Armitage (KA) group at Merrill...Ch. 5 - 64. The Pew Research Center surveyed adults who...Ch. 5 - 65. The following table shows the percentage of...Ch. 5 - Prob. 66SECh. 5 - 67. PBS News Hour reported that 39.4% of Americans...Ch. 5 - Prob. 68SECh. 5 - Arrivals to a Car Wash. Cars arrive at a car wash...Ch. 5 - Prob. 70SECh. 5 - Prob. 71SECh. 5 - Prob. 72SECh. 5 - Great Grasslands Grains, Inc. (GGG) manufactures...Ch. 5 - Harriet McNeil, proprietor of McNeil’s Auto Mall,...Ch. 5 -
Grievance Committee at Tuglar Corporation
Several...Ch. 5 -
Sagittarius Casino
The Sagittarius Casino’s...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardCould you help me with those tasks? I have no clue what to doarrow_forwardIf the value of the Pearson correlation is r=+1.00 or -1.00, then all data points in a scatter plot fit perfectly on a straight line.arrow_forward
- Where does the spurious correlation exist?arrow_forwardWhy should researchers taught to be cautious when interpreting a correlation?arrow_forwardAsset W has expected return of 11.6% and a beta of 1.23. If the risk free rate is 3.15%, complete the following table for portfolios of asset W, and a risk free asset. Illustrate the relationship between portfolio, expected return and portfolio beta by plotting the expected returns against the betas in a graph. What is the slope of the line that results? Results are in the table I just need the excel graph!!!! Percentage of portfolio asset in W. Portfolio expected return. Portfolio beta. 0% = (0 x 0.116) + (1 x 0.0315) = 3.15% 0 25% = (0.25 x 0.116) + (0.75 x 0.0315) = 5.26% = 1.23 x 0.25 = 0.3075 50% = (0.50 x 0.116) + (0.50 x 0.0315) = 7.37% = 1.23 x 0.50 = 0.615 75% = (0.75 x 0.116) + (0.25 x 0.0315) = 9.48% = 1.23 x 0.75 = 0.9225 100% = (1 x 0.116) + (0 x 0.0315) = 11.6% = 1.23 x 1 = 1.23 125% = (1.25 x 0.116) + (-0.25 x 0.0315) = 13.71% = 1.23 x 1.25 = 1.5375 150% = (1.50 x 0.116) + (-0.50 x 0.0315) = 15.82% = 1.23 x…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY