Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
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 solutionChapter 5 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
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.Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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