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
Videos
Textbook Question
Chapter 5, Problem 63SE
The Knowles/Armitage (KA) group at Merrill Lynch advises clients on how to create a diversified investment portfolio. One of the investment alternatives they make available to clients is the All World Fund composed of global stocks with good dividend yields. One of their clients is interested in a portfolio consisting of investment in the All World Fund and a treasury bond fund. The expected percent return of an investment in the All World Fund is 7.80% with a standard deviation of 18.90%. The expected percent return of an investment in a treasury bond fund is 5.50% and the standard deviation is 4.60%. The
- a. Which of the funds would be considered the more risky? Why?
- b. If KA recommends that the client invest 75% in the All World Fund and 25% in the treasury bond fund, what is the expected percent return and standard deviation for such a portfolio? What would be the expected return and standard deviation, in dollars, for a client investing $10,000 in such a portfolio?
- c. If KA recommends that the client invest 25% in the All World Fund and 75% in the treasury bond fund, what is the expected return and standard deviation for such a portfolio? What would be the expected return and standard deviation, in dollars, for a client investing $10,000 in such a portfolio?
Which of the portfolios in parts (b) and (c) would you recommend for an aggressive investor? Which would you recommend for a conservative investor? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A FiveThirtyEight.com article reports that “Horror movies get nowhere near as much draw at the box office as the big-time summer blockbusters or action/adventure movies ... but there’s a huge incentive for studios to continue pushing them out. The return-on-investment potential for horror movies is absurd.” To investigate how the return-on-investment compares between genres and how this relationship has changed over time, an introductory statistics student fit a model predicting the ratio of gross revenue of movies from genre and release year for 1,070 movies released between 2000 and 2018. Using
the plots given below, determine if this regression model is appropriate for these data
Discuss two extensions to the original GARCH (p,q) model and explain additional characteristics of financial data they might be able to capture.
A stock has monthly returns of 9%, 22%, 15%, and 28%. What is the stock's geometric average
return?
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
- Cite two descriptive statistics (Select all that apply.) -Of those investment managers surveyed, 21% selected health care as the sector most likely to lead the market in the next 12 months. -Of those investment managers surveyed, 43% were bullish or very bullish on health care stocks over the next 2.9 years. -Of those investment managers surveyed, 11.4% expect it would take 12 months for equities to resume sustainable growth. -Of those investment managers surveyed, 43% were bullish or very bullish on the stock market. -Of those investment managers surveyed, 43% selected technology and telecom stocks to be the sector most likely to lead the market in the next 12 months.arrow_forwardA research analyst is trying to determine whether a firm’s price-earnings (P/E) and price-sales (P/S) ratios can explain the firm’s stock performance over the past year. A P/E ratio is calculated as a firm’s share price compared to the income or profit earned by the firm per share. Generally, a high P/E ratio suggests that investors are expecting higher earnings growth in the future compared to companies with a lower P/E ratio. The P/S ratio is calculated by dividing a firm’s share price by the firm’s revenue per share for the trailing 12 months. In short, investors can use the P/S ratio to determine how much they are paying for a dollar of the firm’s sales rather than a dollar of its earnings (P/E ratio). In general, the lower the P/S ratio, the more attractive the investment. The accompanying table shows the year-to-date (YTD) returns and the P/E and P/S ratios for a portion of the 30 firms included in the Dow Jones Industrial Average.…arrow_forwardYou may need to use the appropriate technology to answer this question. One particular professional association of investors conducts a weekly survey of its members to measure the percent who are bullish, bearish, and neutral on the stock market for the next six months. The survey results showed 38.2% bullish, 23.4% neutral, and 38.4% bearish. Assume these results are based on a sample of 300 members. (a) Over the long term, the proportion of bullish members is 0.39. Conduct a hypothesis test at the 5% level of significance to see if the current sample results show that bullish sentiment differs from its long term average of 0.39. What are your findings? Formulate the hypotheses that can be used to determine whether the bullish sentiment differs from its long term average of 0.39. Hop 20.39 Hip 0.39 HoP-0.39 HP 0.39 Ho: P 0.39 HDS 0.39 Find the value of the test statistic. (Round your answer to two decimal places.) 38 x Find the p-value. (Round your answer to four decimal places.)…arrow_forward
- Morning House is a mail-order firm which carries a wide range of rather expensive art objects for homes and offices. It operate problems would be greatly reduced. Since it takes approximately six weeks to receive 90% of the response to a given campaign, an accurate prediction of total sales made as late as the end of the first week of receiving orders would be useful. The first week’s sales and total sales of the last 12 campaigns of the firm are shown below. Can the first week’s sales be used to predict total sales? First week’s Total Campaign Sales Sales 1 32 167 2 20 91 3 114 560 4 66 335 5 18 70 6 125 650 7 83 401 8 65 320 9 94 470 10 5 15 11 39 210 12 50 265 --------------------------------------------arrow_forwardTo analyze the risk, or volatility, associated with investing in General Electric common stock, consider a sample of the eight quarterly percent total returns. The percent total return includes the stock price change plus the dividend payment for the quarter. Excel File: data11-06.xlsx 20.0 -20.5 12.2 12.6 10.5 -5.8 -18.7 15.3 a. What is the value of the sample mean (to 1 decimal)? What is its interpretation? This is the estimate of the-Select your answer-mean percent total return per quarter for General Electric. b. Compute the sample variance and sample standard deviation as measures of volatility for the quarterly return for General Electric (to 2 decimals). Variance: Standard deviation: c. Construct a 95% confidence interval for the population variance (to 2 decimals). Use Table 11.1. sots d. Construct a 95% confidence interval for the population standard deviation (to 2 decimals). Use Table 11.1. sos ReadSpeakerarrow_forwardThe Majoring in Money study by Sallie Mae from December 2015 showed that most college students manage their credit cards in a reasonable way. It showed that almost two-thirds of students pay their credit card balance in full every month and 25% of students who own credit cards make partial payments that exceed the minimum amount due. You are curious to find out if credit card payment behavior of students has changed since 2015 and collect data from a random sample of 370 students. You find that 71 students are making partial payments on their credit cards that exceed the minimum amount due. Using α=0.01, complete parts a and b below.arrow_forward
- The ABC Company is involved in the production and selling of consumer goods, particularly beauty products such as bath soap and shampoo and had registered a positive profit growth for the last 10 years. However, the current year seems to be different from those years as the company is expecting a decline in profit; which is estimated to be about 70% below the target. The manager now is in a dilemma … asking himself/herself “What happened, why this decline in profit?” The Manager then asked the company Accountant to give him/her the data on sales and advertising cost for the last 10 years – he/she wants these data to determine whether the company can live without advertising, as advertising cost happens to be substantial. Justify your answer by doing as step-by-step procedure in Correlation Analysis using a 0.05 level of significance. The data are as follows –arrow_forwardMany investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2006, 9 of the 30 stocks making up the DJIA increased in price (The Wall Street Journal, February 1, 2006). On the basis of this fact, a financial analyst claims we can assume that 30% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day.A sample of 50 stocks traded on the NYSE that day showed that 12 went up.You are conducting a study to see if the proportion of stocks that went up is significantly less than 0.3. You use a significance level of α=0.01.What is the test statistic for this sample? (Report answer accurate to three decimal places.)test statistic = What is the p-value for this sample? (Report answer accurate to four decimal places.)p-value = The p-value is... less than (or equal to) αα greater than αα This test statistic leads to a decision to... reject the null accept the null fail to…arrow_forwardMany investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2006, 9 of the 30 stocks making up the DJIA increased in price (The Wall Street Journal, February 1, 2006). On the basis of this fact, a financial analyst claims we can assume that 30% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day. A sample of 50 stocks traded on the NYSE that day showed that 18 went up. You are conducting a study to see if the proportion of stocks that went up is significantly more than 0.3. You use a significance level of a = 0.002. What is the test statistic for this sample? (Report answer accurate to three decimal places.) test statistic = What is the p-value for this sample? (Report answer accurate to four decimal places.) p-value = The p-value is... O less than (or equal to) a greater than a This test statistic leads to a decision to... O reject the null O accept the null O fail…arrow_forward
- Many investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2006, 9 of the 30 stocks makıng up the DJIA increased in price (The Wall Street Journal, February 1, 2006). On the basis of this fact, a financial analyst claims we can assume that 30% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day A sample of 78 stocks traded on the NYSE that day showed that 21 went up. You are conducting a study to see if the proportion of stocks that went up is is significantly less than 0.3. You use a significance level of a 0.001. What is the test statistic for this sample? (Report answer accurate to three decimal places. test statistic What is the p-value for this sample? (Report answer accurate to four decimal places.) 19 p-value = The p-value is.. less than (or equal to) o greater than a This test statistic leads to a decision to... reject the nul1 aarrow_forwardMany investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2006, 9 of the 30 stocks making up the DJIA increased in price (The Wall Street Journal, February 1, 2006). On the basis of this fact, a financial analyst claims we can assume that 30% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day.A sample of 60 stocks traded on the NYSE that day showed that 24 went up.You are conducting a study to see if the proportion of stocks that went up is significantly more than 0.3. You use a significance level of α=0.001α=0.001.What is the test statistic for this sample? (Report answer accurate to three decimal places.)test statistic = What is the p-value for this sample? (Report answer accurate to four decimal places.)p-value =arrow_forwardMany investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2006, 9 of the 30 stocks making up the DJIA increased in price (The Wall Street Journal, February 1, 2006). On the basis of this fact, a financial analyst claims we can assume that 30% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day.A sample of 60 stocks traded on the NYSE that day showed that 9 went up.You are conducting a study to see if the proportion of stocks that went up is significantly less than 0.3. You use a significance level of α=0.002.What is the test statistic for this sample? (Report answer accurate to three decimal places.)test statistic = What is the p-value for this sample? (Report answer accurate to four decimal places.)p-value = The p-value is... less than (or equal to) α greater than α This test statistic leads to a decision to... reject the null accept the null fail to reject…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Continuous Probability Distributions - Basic Introduction; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=QxqxdQ_g2uw;License: Standard YouTube License, CC-BY
Probability Density Function (p.d.f.) Finding k (Part 1) | ExamSolutions; Author: ExamSolutions;https://www.youtube.com/watch?v=RsuS2ehsTDM;License: Standard YouTube License, CC-BY
Find the value of k so that the Function is a Probability Density Function; Author: The Math Sorcerer;https://www.youtube.com/watch?v=QqoCZWrVnbA;License: Standard Youtube License