EBK BUSINESS STATISTICS
7th Edition
ISBN: 8220102743984
Author: STEPHAN
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.69AC
(a)
To determine
To construct: A table that tallies type, market cap and risk.
(b)
To determine
To find: the number offunds and the conclusions about the funds
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the accompanying data table regarding retirement funds. Complete parts (a) through (d) below.
a. Construct a growth and value table that tabulates type, market cap, risk,and rating.
4. Compare the high and the low common stock prices since 2007 in a graph of your choice for
"XXX" Corporation. Write a brief interpretation of the main features of the data portrayed in
the graph. The high and the low common stock prices for the "XXX" Corporation since
1983 are:
Year High Low
2007 40.85 30.90
2008 40.85 30.00
2009 40.85 29.25
2010 48.00 34.00
2011 64.75 32.00
Year High Low
2013 72.00 45.75
2014 81.65 63.25
2015 80.15 63.50
2016 75.35 60.25
2017 98.35 67.75
2018 99.00 70.00
2012 51.75 39.65
The following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables:
Use Excel to answer the following question:
a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10).
B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong?
Group of answer choices
Out of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%).
Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%).
Out of the 45 mutual funds, there are 28 DE type of funds.
Out of the 45 mutual funds, there are 10…
Chapter 2 Solutions
EBK BUSINESS STATISTICS
Ch. 2 - Prob. 2.1LBCh. 2 - The following data represent the responses to two...Ch. 2 - Prob. 2.3ACCh. 2 - Prob. 2.4ACCh. 2 - Prob. 2.5ACCh. 2 - Prob. 2.6ACCh. 2 - Prob. 2.7ACCh. 2 - A survey of 1,085 adults asked Do you enjoy...Ch. 2 - Prob. 2.9ACCh. 2 - Prob. 2.10AC
Ch. 2 - Prob. 2.11LBCh. 2 - Prob. 2.12LBCh. 2 - Prob. 2.13LBCh. 2 - Prob. 2.14LBCh. 2 - The file NBACost2013 contains the total cost ($)...Ch. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.17ACCh. 2 - One operation of a mill to cut pieces of steel...Ch. 2 - A manufacturing company produces steel housings...Ch. 2 - Prob. 2.21ACCh. 2 - Prob. 2.22ACCh. 2 - Prob. 2.23ACCh. 2 - An online survey of CFA Institute members was...Ch. 2 - Prob. 2.25ACCh. 2 - Prob. 2.26ACCh. 2 - Prob. 2.27ACCh. 2 - The following table indicates the percentage of...Ch. 2 - Prob. 2.29ACCh. 2 - Prob. 2.30ACCh. 2 - A study of Kickstarter projects showed that 54.2%...Ch. 2 - Prob. 2.32ACCh. 2 - Prob. 2.33LBCh. 2 - Prob. 2.34LBCh. 2 - Prob. 2.35ACCh. 2 - Prob. 2.37ACCh. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.39ACCh. 2 - Prob. 2.40ACCh. 2 - Prob. 2.41ACCh. 2 - Prob. 2.42ACCh. 2 - Prob. 2.43ACCh. 2 - Prob. 2.45ACCh. 2 - Prob. 2.46ACCh. 2 - The data stored in DRINK represents the amount of...Ch. 2 - Prob. 2.48LBCh. 2 - Prob. 2.49LBCh. 2 - Prob. 2.50ACCh. 2 - Data were collected on the typical cost of dining...Ch. 2 - College football is big business, with coaches pay...Ch. 2 - Prob. 2.54ACCh. 2 - Prob. 2.56ACCh. 2 - Prob. 2.57ACCh. 2 - Prob. 2.58ACCh. 2 - Prob. 2.59ACCh. 2 - Prob. 2.60ACCh. 2 - Prob. 2.61ACCh. 2 - Prob. 2.66ACCh. 2 - Prob. 2.67ACCh. 2 - Prob. 2.68ACCh. 2 - Prob. 2.69ACCh. 2 - Prob. 2.71ACCh. 2 - (Student Project) The Data and Story Library...Ch. 2 - Prob. 2.73ACCh. 2 - Prob. 2.75ACCh. 2 - Figure 2.1 shows a bar chart and a pie chart for...Ch. 2 - Prob. 2.78ACCh. 2 - Prob. 2.79CYUCh. 2 - Prob. 2.80CYUCh. 2 - Prob. 2.81CYUCh. 2 - Compare and contrast the bar chart for categorical...Ch. 2 - Prob. 2.83CYUCh. 2 - Prob. 2.84CYUCh. 2 - What are the three different ways to break down...Ch. 2 - How can a multidimensional table differ from a...Ch. 2 - Prob. 2.87CYUCh. 2 - Prob. 2.88CRPCh. 2 - The owner of a restaurant that serves...Ch. 2 - Suppose that the owner of the restaurant in...Ch. 2 - Prob. 2.94CRPCh. 2 - One of the major measures of the quality of...Ch. 2 - Prob. 2.98CRPCh. 2 - The file CEO-Compensation includes the total...Ch. 2 - Prob. 2.100CRPCh. 2 - What was the average price of a room at two-star,...Ch. 2 - Prob. 2.102CRPCh. 2 - Prob. 2.103CRPCh. 2 - The following data (stored in Drink) represent...Ch. 2 - Prob. 2.106CRPCh. 2 - Prob. 2.109RWE
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
- Use this data for the exercises that follow: In 2013, there were roughly 317 million citizens in the United States, and about 40 million were elderly (aged 65 and over).[34] 60. It is predicted that by 2030, one in five U.S. citizens will be elderly. How much greater will the chances of meeting an elderly person be at that time? What policy changes do you foresee if these statistics hold true?arrow_forwardThe selling prices of mutual funds change daily. In order to study these changes, a sample of mutual funds was examined and the daily changes in price are listed below. (Round answers to 3 decimal places) 0.32, -0.17, 0.26, -0.03, -0.01, 0.18, 0.33, 0.28, 0.02, -0.29, -0.08, 0.12, 0.07, 0.03, 0.28 a) Using a calculator find Q1, Q3, median and IQR b) Determine the lower and upper fences. (Show work) c) Identify the outliers (if any) in this setarrow_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 v 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. d. Construct a 95% confidence interval for the population standard deviation (to 2 decimals). Use Table 11.1.arrow_forward
- To 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_forwardA sample of 20 financial analysts was asked to provide forecasts of earnings per share of a corporation for next year. The results are summarized in the following table:Forecast ($ per share) Number of Analysts$9.95 to under $10.45 2$10.45 to under $10.95 8$10.95 to under $11.45 6$11.45 to under $11.95 3$11.95 to under $12.45 1a. Estimate the sample mean forecast.b. Estimate the sample standard deviation.arrow_forwardYou decide to invest in stock in a particular type of company and set the guideline thatyou will only buy stock in companies that are ranked in the 80th percentile or above interms of dividends paid in the previous year. You are looking at a company that ranked7 out of 450 companies that paid dividends in 2019. a. Will this company qualify for your portfolio? b. If you had the data on the total dividends paid by each of the 450 companies,what would the mean and the median each tell you and how would you computeeach measure?arrow_forward
- Suppose the Dow Jones Industrial Average went up 149.82 points. The following table shows the stock price changes for a sample of 12 companies on that day. PRICE CHANGE PRICE CHANGE COMPANY $ COMPANY $ AFLAC 0.81 JOHN&JOHN 1.46 BANK AMERICA 0.05 LOEWS CP 0.92 CABELVISION 0.41 NOKIA 0.21 DIAGEO 1.32 SMPRAENGY 0.97 FLOUR CP 2.37 SUNOCO 0.52 GOODRICH 0.4 TYSON FOOD 0.22 Provide 95% confidence interval estimates of the populatioin vairance and the population standard deviation.arrow_forwardYou decide to invest in stock in a particular type of company and set the guideline that you will only buy stock in companies that are ranked in the 80th percentile or above in terms of dividends paid in the previous year. You are looking at a company that ranked 7 out of 450 companies that paid dividends in 2019. a.Will this company qualifies for your portfolio? b.If you had the data on the total dividends paid by each of the 450 companies, which measure of average would be the most meaningful – mean, median, midrange, or mode? Explainarrow_forwardThe "Dogs of the Dow" are the stocks listed on the Dow with the highest dividend yield. The following table shows the top ten stocks of the "Dogs of the Dow" list for 2015, based on their performance the preceding year. HINT [See Example 2.] Symbol Company Price ($) Yield Source: www.dogsofthedow.com. AT&T 33.59 5.48% VZ Verizon 46.78 4.70% CVX Chevron 112.18 3.82% MCD McDonald's 93.70 3.63% PFE Pfizer 31.15 3.60% GE General Electric 25.27 3.48% MRK Merck 56.79 3.17% CAT Caterpillar 91.53 3.06% Хом ExxonMobil 92.45 2.99% KO Соса-Cola 42.22 2.89% If you selected two of these stocks at random, what is the probability that both the stocks in your selection had yields of 3.5% or more?arrow_forward
- You may need to use the appropriate technology to answer this question. The Wall Street Journal's Shareholder Scoreboard tracks the performance of 1,000 major U.S. companies. The performance of each company is rated based on the annual total return, including stock price changes and the re investment of dividends. Ratings are assigned by dividing all 1,000 companies into five groups from A (top 20%), B (next 20%), to E (bottom 20%). Shown here are the one- year ratings for a sample of 60 of the largest companies. A C 6 8 14 20 12 Do the largest companies differ in performance from the performance of the 1,000 companies in the Shareholder Scoreboard? Use a = 0.05. State the null and alternative hypotheses. Ho: The proportions of the largest companies compared to the 1,000 companies are the same for at least one of the five groups. H: The proportions of the largest companies compared to the 1,000 companies are different for all five groups. Ho: The proportions of the largest companies…arrow_forwardThe following table shows the total return and the number of funds for four categories of mutual funds. Excel File: data03-17.xlsx Type of Fund Domestic Equity International Equity Specialty Stock Hybrid a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. (to 2 decimals) % Number of Funds 9,191 2,621 1,419 2,900 Total Return (%) 4.65 18.15 11.36 6.75 b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? (i) Using "number of funds" as weights will only be a good approximation if the amount invested in various funds is approximately equal. The amount invested in each fund could be used for weights. (ii) Using "number of funds" as weights results in a good approximation regardless of the amount invested in various funds. There is no need to use a different weight. (iii) Using "number of funds" as…arrow_forwardIn 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data. Enter negative values as negative numbers. a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillLinear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License