close solutoin list

A portion of a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 follows. The complete data set is available in the file named MutualFunds. The data set includes the following five variables: Fund Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income). Net Asset Value ($): The closing price per share on December 31, 2007. 5-Year Average Return (%): The average annual return for the fund over the past five 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. 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 .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 .49 4-Star American Century Ultra DE 24.94 10.88 .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 . . . . . . . . . . . . . . . . . . a. Develop an estimated regression equation that can be used to predict the 5-year average return given the type of fund. At the .05 level of significance, test for a significant relationship. b. Did the estimated regression equation developed in part (a) provide a good fit to the data? Explain. c. Develop the estimated regression equation that can be used to predict the 5-year average return given the type of fund, the net asset value, and the expense ratio. At the .05 level of significance, test for a significant relationship. Do you think any variables should be deleted from the estimated regression equation? Explain. d. Morningstar Rank is a categorical variable. Because the data set contains only funds with four ranks (2-Star through 5-Star), use the following dummy variables: 3Star-Rank = 1 for a 3-Star fund, 0 otherwise; 4StarRank = 1 for a 4-Star fund, 0 otherwise; and 5StarRank = 1 for a 5-Star fund, 0 otherwise. Develop an estimated regression equation that can be used to predict the 5-year average return given the type of fund, the expense ratio, and the Morningstar Rank. Using a = .05, remove any independent variables that are not significant. e. Use the estimated regression equation developed in part (d) to predict the 5-year average return for a domestic equity fund with an expense ratio of 1.05% and a 3-Star Morningstar Rank.

BuyFind

Statistics for Business & Economic...

12th Edition
David R. Anderson + 4 others
Publisher: South-Western College Pub
ISBN: 9781285846323
BuyFind

Statistics for Business & Economic...

12th Edition
David R. Anderson + 4 others
Publisher: South-Western College Pub
ISBN: 9781285846323

Solutions

Chapter
Section
Chapter 15, Problem 56SE
Textbook Problem

A portion of a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 follows. The complete data set is available in the file named MutualFunds. The data set includes the following five variables:

Fund Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income).

Net Asset Value ($): The closing price per share on December 31, 2007.

5-Year Average Return (%): The average annual return for the fund over the past five 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.

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 .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 .49 4-Star
American Century Ultra DE 24.94 10.88 .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
. . . . . .
. . . . . .
. . . . . .
  1. a. Develop an estimated regression equation that can be used to predict the 5-year average return given the type of fund. At the .05 level of significance, test for a significant relationship.
  2. b. Did the estimated regression equation developed in part (a) provide a good fit to the data? Explain.
  3. c. Develop the estimated regression equation that can be used to predict the 5-year average return given the type of fund, the net asset value, and the expense ratio. At the .05 level of significance, test for a significant relationship. Do you think any variables should be deleted from the estimated regression equation? Explain.
  4. d. Morningstar Rank is a categorical variable. Because the data set contains only funds with four ranks (2-Star through 5-Star), use the following dummy variables: 3Star-Rank = 1 for a 3-Star fund, 0 otherwise; 4StarRank = 1 for a 4-Star fund, 0 otherwise; and 5StarRank = 1 for a 5-Star fund, 0 otherwise. Develop an estimated regression equation that can be used to predict the 5-year average return given the type of fund, the expense ratio, and the Morningstar Rank. Using a = .05, remove any independent variables that are not significant.
  5. e. Use the estimated regression equation developed in part (d) to predict the 5-year average return for a domestic equity fund with an expense ratio of 1.05% and a 3-Star Morningstar Rank.

Expert Solution

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Solution

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 15 Solutions

Statistics for Business & Economics, Revised (MindTap Course List)
Show all chapter solutions
Ch. 15.3 - In exercise 1, the following estimated regression...Ch. 15.3 - In exercise 2, 10 observations were provided for a...Ch. 15.3 - In exercise 3, the following estimated regression...Ch. 15.3 - In exercise 4, the following estimated regression...Ch. 15.3 - In exercise 5, the owner of Showtime Movie...Ch. 15.3 - In exercise 6, data were given on the average...Ch. 15.3 - In exercise 9, an estimated regression equation...Ch. 15.3 - Refer to exercise 10, where Major League Baseball...Ch. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Refer to the data presented in exercise 2. The...Ch. 15.5 - The following estimated regression equation was...Ch. 15.5 - In exercise 4, the following estimated regression...Ch. 15.5 - Refer to exercise 5. a. Use = .01 to test the...Ch. 15.5 - The Wall Street Journal conducted a study of...Ch. 15.5 - The Cond Nast Traveler Gold List for 2012 provided...Ch. 15.5 - In exercise 10, data showing the values of several...Ch. 15.6 - In exercise 1, the following estimated regression...Ch. 15.6 - Refer to the data in exercise 2. The estimated...Ch. 15.6 - In exercise 5, the owner of Showtime Movie...Ch. 15.6 - In exercise 9 an estimated regression equation was...Ch. 15.6 - The American Association of Individual Investors...Ch. 15.7 - Consider a regression study involving a dependent...Ch. 15.7 - Consider a regression study involving a dependent...Ch. 15.7 - Management proposed the following regression model...Ch. 15.7 - Refer to the Johnson Filtration problem introduced...Ch. 15.7 - This problem is an extension of the situation...Ch. 15.7 - The Consumer Reports Restaurant Customer...Ch. 15.7 - A 10-year study conducted by the American Heart...Ch. 15.8 - Data for two variables, x and y, follow. xi 1 2 3...Ch. 15.8 - Data for two variables, x and y, follow. xi 22 24...Ch. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following data show the curb weight,...Ch. 15.8 - The Ladies Professional Golfers Association (LPGA)...Ch. 15.9 - Refer to the Simmons Stores example introduced in...Ch. 15.9 - In Table 15.12 we provided estimates of the...Ch. 15.9 - Community Bank would like to increase the number...Ch. 15.9 - Over the past few years the percentage of students...Ch. 15.9 - The Tire Rack maintains an independent consumer...Ch. 15 - The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - A partial computer output from a regression...Ch. 15 - Recall that in exercise 49, the admissions officer...Ch. 15 - Recall that in exercise 50 the personnel director...Ch. 15 - The Tire Rack, Americas leading online distributor...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - A portion of a data set containing information for...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - Finding the Best Car Value When trying to decide...

Additional Math Textbook Solutions

Find more solutions based on key concepts
Show solutions
Should an economic model describe reality exactly?

Principles of Microeconomics (MindTap Course List)

Give an example of each form.

Foundations of Business (MindTap Course List)

For a stock to be in equilibrium, what two conditions must hold?

Fundamentals of Financial Management (MindTap Course List)

All budgets depend on the sales budget. Is this true? Explain.

Managerial Accounting: The Cornerstone of Business Decision-Making

BOND VALUATION An investor has two bonds in her portfolio. Bond C and Bond Z. Each bond matures in 4 years, has...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

16. If

Mathematical Applications for the Management, Life, and Social Sciences

Convert the expressions in Exercises 31-36 to positive exponent form. 34x2/3

Finite Mathematics and Applied Calculus (MindTap Course List)

For f(x)=xx+1,f(x)=. a) 1 b) x2(x+1)2 c) 1(x+1)2 d) 1(x+1)2

Study Guide for Stewart's Single Variable Calculus: Early Transcendentals, 8th

Drinking and Driving Among High School Students The percentage of high school students who drink and drive stoo...

Applied Calculus for the Managerial, Life, and Social Sciences: A Brief Approach

Calculate y'. 13. y=e1/xx2

Calculus: Early Transcendentals

Water Flea F. E. Smith has studied population growth for the water flea. Let N denote the population size. In o...

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)

Used Car Prices. According to the National Automobile Dealers Association, the mean price for used cars is $10,...

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

In Problems 110 use the improved Eulers method to obtain a four-decimal approximation of the indicated value. F...

A First Course in Differential Equations with Modeling Applications (MindTap Course List)