EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 9780100460461
Author: Anderson
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2.3, Problem 34E
Refer to the data in Table 2.12.
- a. Prepare a crosstabulation with 5-Year Average Return as the columns and Net Asset Value as the rows. Use classes starting with 0 in increments of 5 for 5-Year Average Return and classes starting at 0 with increments of 10 for Net Asset Value.
- b. Comment on the relationship, if any, between the variables.
TABLE 2.12 FINANCIAL DATA FOR A SAMPLE OF 45 MUTUAL FUNDS
| Fund Name | Fund Type | Net Asset Value ($) | 5-Year Average Return (%) | Expense Ratio (%) | Morningstar Rank |
| Amer Cent Inc & Growth Inv | DE | 28.88 | 12.39 | 0.67 | 2-Star |
| American Century Intl. Disc | IE | 14.37 | 30.53 | 1.41 | 3-Star |
| American Century Tax-Free Bond | FI | 10.73 | 3.34 | 0.49 | 4-Star |
| American Century Ultra | DE | 24.94 | 10.88 | 0.99 | 3-Star |
| Ariel | DE | 46.39 | 11.32 | 1.03 | 2-Star |
| Artisan Intl Val | IE | 25.52 | 24.95 | 1.23 | 3-Star |
| Artisan Small Cap | DE | 16.92 | 15.67 | 1.18 | 3-Star |
| Baron Asset | DE | 50.67 | 16.77 | 1.31 | 5-Star |
| Brandywine | DE | 36.58 | 18.14 | 1.08 | 4-Star |
| Brown Cap Small | DE | 35.73 | 15.85 | 1.20 | 4-Star |
| Buffalo Mid Cap | DE | 15.29 | 17.25 | 1.02 | 3-Star |
| Delafield | DE | 24.32 | 17.77 | 1.32 | 4-Star |
| DFA U.S. Micro Cap | DE | 13.47 | 17.23 | 0.53 | 3-Star |
| Dodge & Cox Income | FI | 12.51 | 4.31 | 0.44 | 4-Star |
| Fairholme | DE | 31.86 | 18.23 | 1.00 | 5-Star |
| Fidelity Contrafund | DE | 73.11 | 17.99 | 0.89 | 5-Star |
| Fidelity Municipal Income | FI | 12.58 | 4.41 | 0.45 | 5-Star |
| Fidelity Overseas | IE | 48.39 | 23.46 | 0.90 | 4-Star |
| Fidelity Sel Electronics | DE | 45.60 | 13.50 | 0.89 | 3-Star |
| Fidelity Sh-Term Bond | FI | 8.60 | 2.76 | 0.45 | 3-Star |
| Fidelity | DE | 39.85 | 14.40 | 0.56 | 4-Star |
| FPA New Income | FI | 10.95 | 4.63 | 0.62 | 3-Star |
| Gabelli Asset AAA | DE | 49.81 | 16.70 | 1.36 | 4-Star |
| Greenspring | DE | 23.59 | 12.46 | 1.07 | 3-Star |
| Janus | DE | 32.26 | 12.81 | 0.90 | 3-Star |
| Janus Worldwide | IE | 54.83 | 12.31 | 0.86 | 2-Star |
| Kalmar Gr Val Sm Cp | DE | 15.30 | 15.31 | 1.32 | 3-Star |
| Managers Freemont Bond | FI | 10.56 | 5.14 | 0.60 | 5-Star |
| Marsico 21st Century | DE | 17.44 | 15.16 | 1.31 | 5-Star |
| Mathews Pacific Tiger | IE | 27.86 | 32.70 | 1.16 | 3-Star |
| Meridan Value | DE | 31.92 | 15.33 | 1.08 | 4-Star |
| Oakmark I | DE | 40.37 | 9.51 | 1.05 | 2-Star |
| PIMCO Emerg Mkts Bd D | FI | 10.68 | 13.57 | 1.25 | 3-Star |
| RS Value A | DE | 26.27 | 23.68 | 1.36 | 4-Star |
| T. Rowe Price Latin Am. | IE | 53.89 | 51.10 | 1.24 | 4-Star |
| T. Rowe Price Mid Val | DE | 22.46 | 16.91 | 0.80 | 4-Star |
| Templeton Growth A | IE | 24.07 | 15.91 | 1.01 | 3-Star |
| Thornburg Value A | DE | 37.53 | 15.46 | 1.27 | 4-Star |
| USAA Income | FI | 12.10 | 4.31 | 0.62 | 3-Star |
| Vanguard Equity-Inc | DE | 24.42 | 13.41 | 0.29 | 4-Star |
| Vanguard Global Equity | IE | 23.71 | 21.77 | 0.64 | 5-Star |
| Vanguard GNMA | FI | 10.37 | 4.25 | 0.21 | 5-Star |
| Vanguard Sht-Tm TE | FI | 15.68 | 2.37 | 0.16 | 3-Star |
| Vanguard Sm Cp Idx | DE | 32.58 | 17.01 | 0.23 | 3-Star |
| Wasatch Sm Cp Growth | DE | 35.41 | 13.98 | 1.19 | 4-Star |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
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
In 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 ($)
Chapter 2 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 2.1 - Methods 1. The response to a question has three...Ch. 2.1 - A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 - for the 20102011 viewing season, the top five...Ch. 2.1 - In alphabetical order, the six most common last...Ch. 2.1 - Nielsen Media Research provided the list of the 25...Ch. 2.1 - The Canmark Research Center Airport Customer...Ch. 2.1 - Data for a sample of 55 members of the Baseball...Ch. 2.1 - The Pew Research Centers Social Demographic...Ch. 2.1 - The Financial Times/Harris Poll is a monthly...
Ch. 2.2 - Consider the following data. a. Develop a...Ch. 2.2 - Consider the following frequency distribution....Ch. 2.2 - Construct a histogram for the data in exercise 12.Ch. 2.2 - Consider the following data. a. Construct a dot...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications A doctors office staff studied the...Ch. 2.2 - A shortage of candidates has required school...Ch. 2.2 - The London School of Economics and the Harvard...Ch. 2.2 - Fortune provides a list of Americas largest...Ch. 2.2 - entrepreneur magazine ranks franchises using...Ch. 2.2 - The Nielsen Home Technology Report provided...Ch. 2.2 - Prob. 24ECh. 2.2 - A psychologist developed a new test of adult...Ch. 2.2 - The 2011 Cincinnati Flying Pig Half-Marathon (13.1...Ch. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - The following crosstabulation shows household...Ch. 2.3 - Refer again to the crosstabulation of household...Ch. 2.3 - Recently, management at Oak Tree Golf Course...Ch. 2.3 - Table 2.12 shows a data set containing information...Ch. 2.3 - Refer to the data in Table 2.12. a. Prepare a...Ch. 2.3 - Refer to the data in Table 2.12. a. Prepare a...Ch. 2.3 - The U.S. Department of Energys Fuel Economy Guide...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Consider the following data on two categorical...Ch. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - A study on driving speed (miles per hour) and fuel...Ch. 2.4 - The Current Results website lists the average...Ch. 2.4 - People often wait until middle age to worry about...Ch. 2.4 - Smartphones are advanced mobile phones with...Ch. 2.4 - The Northwest regional manager of an outdoor...Ch. 2 - Approximately 1.5 million high school students...Ch. 2 - The Pittsburgh Steelers defeated the Arizona...Ch. 2 - Data showing the population by state in millions...Ch. 2 - A startup companys ability to gain funding is a...Ch. 2 - Consumer complaints are frequently reported to the...Ch. 2 - Dividend yield is the annual dividend paid by a...Ch. 2 - One of the questions in a Financial Times/Harris...Ch. 2 - western University has only one womens softball...Ch. 2 - A survey of commercial buildings served by the...Ch. 2 - Table 2.18 shows a portion of the data for a...Ch. 2 - Refer to the data set in Table 2.18. a. Construct...Ch. 2 - Refer to the data set in Table 2.18. a. Construct...Ch. 2 - Refer to the data set in Table 2.18. a. Prepare a...Ch. 2 - Google has changed its strategy with regard to how...Ch. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores Pelican Stores, a division of...Ch. 2 - Motion Picture Industry The motion picture...
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
- IV.arrow_forward6. Estimate the value of sales for the year 1985 by using the method of least square for trend analysis. Year: 1979 1980 1981 1982 1983 Sales: 100 120 140 160 180 (*000 quintals)arrow_forwardvt 14. Calculate trend values by the method of Least Square from the data given below and estimate the sales for 2007. Year 2000 2001 2002 2003 2004 Sales of GA. (Rs. lakhs) 70 74 80 86 90 上arrow_forward
- Import Illinois.xls as a table. Using logical indexing to select the years with more than 2800 cases of Diabetes. Then plot all of the data on the same axis. F1 fx Homicide B C E Year Accidents Cancer Diabetes Heart Disease Homicide| Suicide 1999 4125 25024 3004 33387 1023 1020 3 2000 4041 25365 2995 31844 991 1003 4. 2001 4077 24778 3092 30990 1087 1139 2002 4222 24737 3011 30821 1016 1145 2003 3942 24464 3044 29816 966 1011 7. 2004 4133 24289 3069 28284 871 1028 8. 2005 4182 24250 3034 28226 866 1086 9. 2006 4451 24084 2795 27007 865 1010 10 2007 4367 24115 2851 25813 863 1108 11 2008 4218 24300 2846 26078 872 1198 12 2009 3961 24185 2741 24931 881 1177 13 2010 3997 24070 2507 24959 783 1178 14 2011 4166 24007 2693 24987 812 1226 15 2012 4488 24562 2706 24667 832 1292 16 2013 4511 24491 2798 17 24839 792 1321 2014 4644 24501 2712 18 25024 792 1398 2015 4850 24713 2817 25652 19 863 1363 20 21arrow_forward. Primary Data Source and Secondary Data Source ?arrow_forwardThere are two underlying assets in an asset pool. Each has a 2.8 percentchanges of failing. You own an asset that will pay $1 unless both assets fail. Graph theprobability of your asset not paying as the correlation between the two input assets runsfrom 0.5 to 0.98. For what levels of correlation is the output asset investment gradearrow_forward
- 3. Suppose that 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 John & John. Aflac Bank of America 0.81 0.05 1.46 0.92 Loews Cp Nokia 0.21 0.97 Cablevision 0.41 Diageo Flour Cp 1.32 2.37 SmpraEngy Sunoco | Tyson Food 0.52 Goodrich 0.4 0.22 Provide 95% confidence interval estimates of the population variance and the population standard deviationarrow_forward%24 %24 T %24 3. 3. 2. 5 2. 2. 2. R %24 3. 23 316 Business & PIC Spreadsheet Assignment 2012 Value 2013 Value 2014 Value 1=North Country Region 2011 Value and South Canada 1. $16,290.00 $15,395.00 $16,863.00 $17,064.00 America $ 2,611.00 $ 2,606.00 $ 2,202.00 $ 2,875.00 2-Asia & $ 741.00 2$ $10,790.00 $ 1,108.00 $ 1,053.00 $ 833.00 zea Hong Kong East $ 8,109.00 $ 8,897.00 $ 9,310.00 3=Europe Israel $ 5,133.00 $ 4,469.00 $ 5,226.00 $ 6,367.00 $ 4,286.00 $ 2,482.00 $ 4,291.00 $ 2,520.00 China $ 4,459.00 $ 5,033.00 2. India $ 2,748.00 $ 2,026.00 2. United Arab Emirates $ 1,517.00 $ 1,636.00 $ 2,013.00 $ 1,921.00 Japan $ 2,519.00 $2,254.00 $ 2,089.00 $1,902.00 2. Netherlands $ 2,187.00 $ 1,505.00 $1,491.00 $ 1,279.00 2. Taiwan $ 1,248.00 763.00 844.00 744.00 905.00 24 761.00 846.00 Turkey 739.00 Thailand 24 502.00 467.00 517.00 Saudi Arabia 597.00 572.00 24 Australia 987.00 $ 1,017.00 2$ $ 6,498.00 932.00 Switzerland $ 5,007.00 $10,042.00 $ 8,744.00 3. United Kingdom $ 6,514.00 $ 6,549.00…arrow_forwardIn this table, x represents the number of years that have passed since 1975. For example, an x-value of 10 represents the year 1985. The letter y represents the profit (or loss), in dollars, for a certain company in that year. Enter the data into a spreadsheet, create a scatterplot and add a trendline. y 4 21.36 5. 23.25 22.74 23.63 8 25.52 9. 25.41 10 27.4 11 26.99 12 28.58 13 32.67 14 30.06 34.25 Use the equation of the trendline to estimate the profit in the year 1995. Round your answer to 1 place after the decimal. Question Help: Message instructor Submit Question MacBookarrow_forward
- 6. Present the following data by a suitable diagram showing. The sales and net profits of a private company. Year Sales Net Profits 1998-1999 14% 49% 1999-2000 10% -25% 2000-2001 13% -1% es ehsinar wer loarrow_forward18. FILE DOW. The accompanying table shows a portion of the 30 companies that comprise the Dow Jones Industrial Average (DJIA). For each company, the data set lists the year that it joined the DJIA, its industry, and its stock price (in $) as of February 15, 2019. Company 3M (MMM) American Express (AXP) : Year 1976 1982 ⠀ 2018 Industry Health Care Finance ⠀ Health Care Price 208.9 107.4 ⠀ 73.43 Walgreen (WBA) a. What is the measurement scale of the Industry variable? b. What is the measurement scale of the Year variable? What are the strengths of this type of measurement scale? What are its weaknesses? c. What is the measurement scale of the Price variable? What are the strengths of this type of measurement scale?arrow_forwardSometimes, data must be modified before a stem-and-leaf plot may be constructed. For example, the data in the accompanying table represent the five-year rate of return of 20 mutual funds and are reported to the hundredth decimal place. So, if we used the integer portion of the data as th and the decimals as the leaves, then the stems would be 8, 9, 10, ..., 19; but the leaves would be two digits (such as 94, 53, and so on). This is m acceptable since each leaf must be a single digit. To resolve this problem, we round the data to the nearest tenth. Complete parts (a) through (c) Click the icon to view the table of five-year rates of return. (a) Round the data to the nearest tenth. 10.11 9.89 11.18 8.27 9.04~ 10.36 8.93 9.28 8.25 10.04≈ 8.87 10.63 (b) Draw a stem-and-leaf plot of the modified data. 9.58 8.75 9.45~ 11.49 9.48≈ 11.24~ 8.77~ 8.57 ≈ Legend: 810 represents 8.0 (c) Describe the shape of the distribution. Choose the correct answer below. |||| A. The distribution is skewed right…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 Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY