Emerg Issues of Tech Analytics

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
• Five-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.

1. Prepare a PivotTable that gives the frequency count of the data by Fund Type (rows) and the five-year average annual return (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 Five-Year Average Return (%). 50 points
2. What conclusions can you draw about the fund type and the average return over the past five years? 50 points

Note that Excel may display the column headings as 0–10, 10–20, 20–30, etc., but they should be interpreted as 0–9.99, 10–19.99, 20–29.99, etc.

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
Fund
Type
DE
IE
FI
DE
DE
IE
DE
DE
DE
DE
DE
DE
DE
FI
DE
DE
FI
IE
DE
FI
DE
FI
DE
DE
DE
IE
DE
FI
DE
IE
DE
DE
FI
DE
IE
DE
IE
DE
FI
DE
IE
5 Year
Average Expense
Net Asset Return
Ratio Morningstar
Value ($)
(%)
(%)
Rank (Stars)
28.88
12.39
0.67
2
14.37
30.53
1.41
3
10.73
3.34
0.49
4
24.94
10.88
0.99
3
46.39
11.32
1.03
2
25.52
24.95
1.23
3
16.92
15.67
1.18
3
50.67
16.77
1.31
5
36.58
18.14
1.08
4
35.73
15.85
1.20
4
15.29
17.25
1.02
3
24.32
17.77
1.32
4
13.47
17.23
0.53
3
12.51
4.31
0.44
4
31.86
18.23
1.00
5
73.11
17.99
0.89
5
12.58
4.41
0.45
5
48.39
23.46
0.90
4
45.60
13.50
0.89
3
8.60
2.76
0.45
3
39.85
14.40
0.56
4
10.95
4.63
0.62
3
49.81
16.70
1.36
4
23.59
12.46
1.07
3
32.26
12.81
0.90
3
54.83
12.31
0.86
2
15.30
15.31
1.32
3
10.56
5.14
0.60
5
17.44
15.16
1.31
5
27.86
32.70
1.16
3
31.92
15.33
1.08
4
40.37
9.51
1.05
2
10.68
13.57
1.25
3
26.27
23.68
1.36
4
53.89
51.10
1.24
4
22.46
16.91
0.80
4
24.07
15.91
1.01
3
37.53
15.46
1.27
4
12.10
4.31
0.62
3
24.42
13.41
0.29
4
23.71
21.77
0.64
5
Vanguard GNMA
Vanguard Sht-Tm TE
Vanguard Sm Cp Idx
Wasatch Sm Cp Growth
FI
FI
DE
DE
10.37
15.68
32.58
35.41
4.25
2.37
17.01
13.98
0.21
0.16
0.23
1.19
5
3
3
4