Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
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
bartleby

Concept explainers

bartleby

Videos

Textbook Question
100%
Book Icon
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 correlation between the S&P 500 and core bonds is −.32. You are considering portfolio investments that are composed of an S&P 500 index fund and a core bonds fund.

  1. a. Using the information provided, determine the covariance between the S&P 500 and core bonds.
  2. 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?
  3. 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?
  4. 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?
  5. 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?
  6. 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?
Blurred answer

Chapter 5 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

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
Background pattern image
Statistics
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
Text book image
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