Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3.1, Problem 20E

Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed better?

Chapter 3.1, Problem 20E, Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in

Expert Solution & Answer
Check Mark
To determine

Identify the mutual fund that performed better.

Answer to Problem 20E

The Trippi mutual fund performed better than Stivers.

Explanation of Solution

Calculation:

In the Stivers mutual fund, $10,000 is invested at the beginning of Year 1 and in Trippi mutual fund, $5,000 is invested at the beginning of Year 1. The given table represents the value of each investment at the end of each subsequent year.

The geometric mean is often used for finding the mean growth rate.

The mean growth factor over these eight periods is:

x¯g=(x1)(x2)(x3)(x4)(x5)(x6)(x7)(x8)8

Where, xi’s are the growth rate for the ith year.

The growing factor of each year can be obtained by dividing the value of end of year by the previous year value.

The growth factor of Stivers for the year 1 can be obtained as follows:

Growth rate of x1=11,00010,000=1.100

The growth factor of Trippi for the year 1 can be obtained as follows:

Growth rate of x1=5,6005,000=1.12

Similarly the growth actor for remaining years can be obtained as shown in the table given below:

YearStiversTrippi
End of Year ValueGrowth FactorEnd of Year ValueGrowth Factor
1$11,0001.100$5,6001.120
2$12,0001.091$6,3001.125
3$13,0001.083$6,9001.095
4$14,0001.077$7,6001.101
5$15,0001.071$8,5001.118
6$16,0001.067$9,2001.082
7$17,0001.063$9,9001.076
8$18,0001.059$10,6001.071

For the Stivers mutual fund:

The balance at the end of the year 8 is the initial investment times the product of all 8 growth factors.

18,000=10,000[(x1)(x2)...(x8)]

That is,

[(x1)(x2)...(x8)]=18,00010,000=1.8

Substitute [(x1)(x2)...(x8)]=1.8 in the formula of geometric mean.

x¯g=1.88=1.07624

Thus, the mean annual return for the Stivers mutual fund is (1.076241)100%=7.624%_

For the Trippi mutual fund:

The balance at the end of the year 8 is the initial investment times the product of all 8 growth factors.

10,600=5,000[(x1)(x2)...(x8)]

That is,

[(x1)(x2)...(x8)]=10,6005,000=2.12

Substitute [(x1)(x2)...(x8)]=2.12 in the formula of geometric mean.

x¯g=2.128=1.09848

Thus, the mean annual return for the Trippi mutual fund is (1.098481)100%=9.848%_

The annual return earned by the Trippi mutual fund is 9.8% and by the Stivers mutual fund is 7.6%. Hence, the annual return earned by the Tripp mutual fund is more than that of Stivers mutual fund.

Thus, it can be concluded that the Trippi mutual fund performed better than Stivers.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 3 Solutions

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

Ch. 3.1 - Prob. 11ECh. 3.1 - The Big Bang Theory, a situation comedy...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 - The data contained in the DATAfile named...Ch. 3.1 - 15. Martinez Auto Supplies has retail stores...Ch. 3.1 - 16. The grade point average for college students...Ch. 3.1 - 17. The following table shows the total return and...Ch. 3.1 - 18. Based on a survey of master’s programs in...Ch. 3.1 - Annual revenue for Corning Supplies grew by 5.5%...Ch. 3.1 - Suppose that at the beginning of Year 1 you...Ch. 3.1 - Prob. 21ECh. 3.1 - Prob. 22ECh. 3.2 - 23. Consider a sample with data values of 10, 20,...Ch. 3.2 - Prob. 24ECh. 3.2 - Consider a sample with data values of 27, 25, 20,...Ch. 3.2 - Price of Unleaded Gasoline. Data collected by the...Ch. 3.2 - Round-Trip Flight Prices. The following table...Ch. 3.2 - The Australian Open is the first of the four...Ch. 3.2 - Air Quality Index. The Los Angeles Times regularly...Ch. 3.2 - Prob. 30ECh. 3.2 - The results of Accounting Principals’ latest...Ch. 3.2 - Advertising Spend by Companies. Advertising Age...Ch. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - Consistency of Running Times. The following times...Ch. 3.3 - 35. Consider a sample with data values of 10, 20,...Ch. 3.3 - 36. Consider a sample with a mean of 500 and a...Ch. 3.3 - 37. Consider a sample with a mean of 30 and a...Ch. 3.3 - 38. Suppose the data have a bell-shaped...Ch. 3.3 - 39. The results of a national survey showed that...Ch. 3.3 - 40. The energy information Administration reported...Ch. 3.3 - 41. The Graduate Management Admission Test (GMAT)...Ch. 3.3 - 42. Many families in California are using backyard...Ch. 3.3 - According to a Los Angeles Times study of more...Ch. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Pharmaceutical Company Sales. Annual sales, in...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazine’s list of...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables...Ch. 3.5 - Prob. 56ECh. 3.5 - The DATAfile TwoStocks contains adjusted monthly...Ch. 3.5 - Driving Speed and Fuel Efficiency. A department of...Ch. 3.5 - Smoke Detector Use and Death Rates. Over the past...Ch. 3.5 - Stock Market Indexes Comparison. The Russell 1000...Ch. 3.5 - Best Private Colleges. A random sample of 30...Ch. 3 - Americans Dining Out. Americans tend to dine out...Ch. 3 - NCAA Football Coaches Salaries. A 2017 USA Today...Ch. 3 - Physician Office Waiting Times. The average...Ch. 3 - Worker Productivity and Insomnia. U.S. companies...Ch. 3 - A study of smartphone users shows that 68% of...Ch. 3 - Work Commuting Methods. Public transportation and...Ch. 3 - Household Incomes. The following data represent a...Ch. 3 - Restaurant Chains’ Sales per Store. The data...Ch. 3 - Prob. 70SECh. 3 - NFL Teams Worth. In 2014, the 32 teams in the...Ch. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - 73. The days to maturity for a sample of five...Ch. 3 - 74. Automobiles traveling on a road with a posted...Ch. 3 - Annual Returns for Panama Railroad Company Stock....Ch. 3 - Pelican Stores, a division of National Clothing,...Ch. 3 - The motion picture industry is a competitive...Ch. 3 - The pursuit of a higher education degree in...Ch. 3 - Although millions of elephants once roamed across...
Knowledge Booster
Background pattern image
Statistics
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.
Recommended textbooks for you
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Intermediate Algebra
Algebra
ISBN:9780998625720
Author:Lynn Marecek
Publisher:OpenStax College
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
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