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
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?
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fea6fd95d-337a-4518-b73c-8b6207b7f379%2F53e2bbda-0048-4533-ac9b-142e894d2ddc%2Fefx9xqn_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
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
This is a popular solution!
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)