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, whi

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

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 FI type of funds. 

C.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
Fund Name
Amer Cent Inc & Growth Inv
American Century Intl Disc
American Century Tax-Free Bond
American Century Ultra
Ariel
Artisan Intl Val
Artisan Small Cap
Baron Asset
Brandywine
Brown Cap Small
Buffalo Mid Cap
Delafield
DFA U.S. Micro Cap
Dodge & Cox Income
Fairholme
Fidelity Contrafund
Fidelity Municipal Income
Fidelity Overseas
Fidelity Sel Electronics
Fidelity Sh-Term Bond
Fidelity
FPA New Income
Gabelli Asset AAA
Greenspring
Janus
Janus Worldwide
Kalmar Gr Val Sm Cp
Managers Freemont Bond
Marsico 21st Century
Mathews Pacific Tiger
Meridan Value
Oakmark I
PIMCO Emerg Mkts Bd D
RS Value A
T. Rowe Price Latin Am
T. Rowe Price Mid Val
Templeton Growth A
Thornburg Value A
USAA Income
Vanguard Equity-Inc
Vanguard Global Equity
Vanguard GNMA
Vanguard Sht-Tm TE
Vanguard Sm Cp Idx
Wasatch Sm Cp Growth
7
W
Fund
Type
DE
IE
FI"
DE
DE
IE
DE
DE
DE
DE
DE
DE
DE
FI
DE
DE
Al
IE
DE
M
DE
FI
DE
DE
DE
IE
DE
FI
DE
IE
DE
DE
FI
DE
IE
DE
IE
DE
FI
DE
IE
FI
FI
DE
DE
Net Asset
Value ($)
28.88
14.37
10.73
24.94
46.39
25.52
16.92
50,67
36.58
35.73
15.29
24.32
13.47
12.51
31.86
73.11
12.58
48.39
45.60
8.60
39.85
10.95
49.81
23.59
32.26
54.83
15.30
10.56
17.44
27,86
31.92
40.37
10.68
26.27
53.89
22.46
24.07
37.53
12.10
24.42
23.71
10.37
15.68
32.58
35.41
5-Year
Average
Return (%)
12.39
30.53
3.34
10.88
11.32
24.95
15.67
16.77
18.14
15.85
47.25
17.77
17.23
4.31
18.23
17.99
4.41
23.46
13.50
2.76
14.40
4,63
16.70
12.46
12.81
12.31
15.31
5.14
15.16
32.70
15.33
9.51
13.57
23.68
51.10
16.91
15.91
15.46
4.31
13.41
21.77
4.25
2.37
17.01
13.98
Expense
Ratio (%)
0.67
1.41
0,49
0.99
1.03
1.23
1.18
1.31
1.08
1.20
1.02
1.32
0.53
0.44
1.00
0.89
0.45
0.90
0.89
0.45
0.56
0.62
1.36
1.07
0.90
0.86
1.32
0.60
1.31
1.16
1.08
1.05
1.25
1.36
1.24
0.80
1.01
1.27
0.62
0.29
0.64
0.21
0.16
0.23
1.19
Morningstar
Rank
2-Star
3-Star
4-Star
3-Star
2-Star
3-Star
3-Star
5-Star
4-Star
4-Star
3-Star
4-Star
3-Star
4-Star
5-Star
5-Star
5-Star
4-Star
3-Star
3-Star
4-Star
3-Star
4-Star
3-Star
3-Star
2-Star
3-Star
5-Star
5-Star
3-Star
4-Star
2-Star
3-Star
4-Star
4-Star
4-Star
3-Star
4-Star
3-Star
4-Star
5-Star
5-Star
3-Star
3-Star
4-Star
bersa
9,8
Transcribed Image Text:TABLE 2.12 FINANCIAL DATA FOR A SAMPLE OF 45 MUTUAL FUNDS Fund Name Amer Cent Inc & Growth Inv American Century Intl Disc American Century Tax-Free Bond American Century Ultra Ariel Artisan Intl Val Artisan Small Cap Baron Asset Brandywine Brown Cap Small Buffalo Mid Cap Delafield DFA U.S. Micro Cap Dodge & Cox Income Fairholme Fidelity Contrafund Fidelity Municipal Income Fidelity Overseas Fidelity Sel Electronics Fidelity Sh-Term Bond Fidelity FPA New Income Gabelli Asset AAA Greenspring Janus Janus Worldwide Kalmar Gr Val Sm Cp Managers Freemont Bond Marsico 21st Century Mathews Pacific Tiger Meridan Value Oakmark I PIMCO Emerg Mkts Bd D RS Value A T. Rowe Price Latin Am T. Rowe Price Mid Val Templeton Growth A Thornburg Value A USAA Income Vanguard Equity-Inc Vanguard Global Equity Vanguard GNMA Vanguard Sht-Tm TE Vanguard Sm Cp Idx Wasatch Sm Cp Growth 7 W Fund Type DE IE FI" DE DE IE DE DE DE DE DE DE DE FI DE DE Al IE DE M DE FI DE DE DE IE DE FI DE IE DE DE FI DE IE DE IE DE FI DE IE FI FI DE DE Net Asset Value ($) 28.88 14.37 10.73 24.94 46.39 25.52 16.92 50,67 36.58 35.73 15.29 24.32 13.47 12.51 31.86 73.11 12.58 48.39 45.60 8.60 39.85 10.95 49.81 23.59 32.26 54.83 15.30 10.56 17.44 27,86 31.92 40.37 10.68 26.27 53.89 22.46 24.07 37.53 12.10 24.42 23.71 10.37 15.68 32.58 35.41 5-Year Average Return (%) 12.39 30.53 3.34 10.88 11.32 24.95 15.67 16.77 18.14 15.85 47.25 17.77 17.23 4.31 18.23 17.99 4.41 23.46 13.50 2.76 14.40 4,63 16.70 12.46 12.81 12.31 15.31 5.14 15.16 32.70 15.33 9.51 13.57 23.68 51.10 16.91 15.91 15.46 4.31 13.41 21.77 4.25 2.37 17.01 13.98 Expense Ratio (%) 0.67 1.41 0,49 0.99 1.03 1.23 1.18 1.31 1.08 1.20 1.02 1.32 0.53 0.44 1.00 0.89 0.45 0.90 0.89 0.45 0.56 0.62 1.36 1.07 0.90 0.86 1.32 0.60 1.31 1.16 1.08 1.05 1.25 1.36 1.24 0.80 1.01 1.27 0.62 0.29 0.64 0.21 0.16 0.23 1.19 Morningstar Rank 2-Star 3-Star 4-Star 3-Star 2-Star 3-Star 3-Star 5-Star 4-Star 4-Star 3-Star 4-Star 3-Star 4-Star 5-Star 5-Star 5-Star 4-Star 3-Star 3-Star 4-Star 3-Star 4-Star 3-Star 3-Star 2-Star 3-Star 5-Star 5-Star 3-Star 4-Star 2-Star 3-Star 4-Star 4-Star 4-Star 3-Star 4-Star 3-Star 4-Star 5-Star 5-Star 3-Star 3-Star 4-Star bersa 9,8
Expert Solution
Step 1

Given information:

Fund Type 5-Year Average Return(%)
DE 12.39
IE 30.53
FI 3.34
DE 10.88
DE 11.32
IE 24.95
DE 15.67
DE 16.77
DE 18.14
DE 15.85
DE 17.25
DE 17.77
DE 17.23
FI 4.31
DE 18.23
DE 17.99
FI 4.41
IE 23.46
DE 13.5
FI 2.76
DE 14.4
FI 4.63
DE 16.7
DE 12.46
DE 12.81
IE 12.31
DE 15.31
FI 5.14
DE 15.16
IE 32.7
DE 15.33
DE 9.51
FI 13.57
DE 23.68
IE 51.1
DE 16.91
IE 15.91
DE 15.46
FI 4.31
DE 13.41
IE 21.77
FI 4.25
FI 2.37
DE 17.01
DE 13.98

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman