Concept explainers
Table 2.12 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:
F und Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income)
Net Asset Value ($): The closing price per share
5-Year Average Return (%): The average annual return for the fund over the past 5 years
Expense Ratio (%): The percentage of assets deducted each fiscal year for fund expenses
Morningstar Rank: The risk adjusted star rating for each fund; Morningstar ranks go from a low of 1-Star to a high of 5-Stars
- a. Prepare a crosstabulation of the data on Fund Type (rows) and the average annual return over the past 5 years (columns). Use classes of 0–9.99, 10–19.99, 20–29.99, 30–39.99, 40–49.99, and 50–59.99 for the 5-Year Average Return (%).
- b. Prepare a frequency distribution for the data on Fund Type.
- c. Prepare a frequency distribution for the data on 5-Year Average Return (%).
- d. How has the crosstabulation helped in preparing the frequency distributions in parts (b) and (c)?
- e. What conclusions can you draw about the fund type and the average return over the past 5 years?
Table 2.12 Financial Data For A Sample Of 45 Mutual Funds
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics 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:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman