1. The data in the worksheet fileMUFUND1.XLScontains information on two types of mutual funds: Equity funds (1), and Bond funds (2). Other variables in the data file are EXP = Expense ratio, PER1 = I year performance (Rate of return), and PER3 = 3-year performance (Rate of return). and ASSET = Asset Size in Millions.

What is a Mutual Fund? A mutual fund is a means by which small investors are able to participate in investments in diversified portfolios by pooling their funds. This is accomplished by contributing money into a pool of funds involving large numbers of investors, the total amount of whose contributions is large, thus making it possible for people who have small sums of money to diversify their portfolios. The money contributed by members is usually managed by investment companies that call themselves mutual funds. Periodically the fund managers distribute profits from dividends or interest payments, and from capital gains. Usually, the returns to investment in mutual funds are net of expenses incurred by the fund managers.

1. A bond fund is a mutual fund that invests only in bonds
2. An equity fund is a fund that invests only in stocks (i.e. in ownership claims)
3. The Expense ratio is the ratio of total expenses to total net assets of the fund.
4. The three-year performance (Rate of Return) is the average rate of profits over a three-year period. The one-year performance is the average rate of return in the last fiscal year of the fund.

MUTUAL FUNDS
CLOSED END FUNDS	2=BOND FUNDS
1=EQUITY FUNDS
ASSET	EXP	PER1	PER3	TYPE	AVG
1138.80	0.50	20.80	16.20	1	18.50
96.30	1.60	32.70	15.70	1	24.20
122.90	2.00	15.70	0.40	1	8.05
323.70	0.50	-7.00	-11.20	1	-9.10
279.20	1.60	8.30	-3.60	1	2.35
256.20	1.70	8.50	-2.50	1	3.00
136.30	1.80	14.60	7.10	1	10.85
760.70	0.70	14.70	14.60	1	14.65
151.40	0.80	8.80	18.00	1	13.40
107.80	1.20	21.40	19.10	1	20.25
418.00	1.60	29.50	16.70	1	23.10
100.20	1.90	27.70	12.10	1	19.90
289.10	1.20	32.80	17.70	1	25.25
347.60	0.60	28.00	23.30	1	25.65
317.00	1.50	-11.00	7.30	1	-1.85
177.10	2.60	34.60	-3.20	1	15.70
61.40	1.60	6.50	2.70	1	4.60
30.80	1.70	33.20	15.30	1	24.25
205.70	0.80	22.00	12.40	1	17.20
1678.50	1.20	4.00	5.40	1	4.70
147.70	1.50	16.10	2.80	1	9.45
216.60	1.80	14.90	-0.40	1	7.25
151.30	1.80	13.00	2.20	1	7.60
114.50	1.80	29.30	-16.00	1	6.65
15.40	3.30	-3.10	3.80	1	0.35
98.10	5.10	30.10	15.00	1	22.55
183.00	1.40	35.30	21.00	1	28.15
122.80	2.00	55.60	8.90	1	32.25
183.60	1.50	14.00	4.40	1	9.20
224.80	1.20	43.00	35.70	1	39.35
89.60	1.90	37.90	17.50	1	27.70
70.40	2.20	7.00	-4.10	1	1.45
224.70	1.80	20.60	-2.10	1	9.25
205.10	1.60	25.00	10.30	1	17.65
1015.40	1.20	9.00	9.40	1	9.20
597.80	1.30	19.40	12.80	1	16.10
220.90	1.20	27.80	16.30	1	22.05
417.60	1.20	15.10	25.30	1	20.20
228.20	2.40	37.70	-3.70	1	17.00
270.90	1.20	32.40	18.90	1	25.65
113.80	1.80	21.50	9.00	1	15.25
127.70	1.60	7.00	14.30	1	10.65
111.00	1.60	3.90	9.60	1	6.75
97.50	2.20	-13.20	-12.30	1	-12.75
49.20	2.00	14.30	-8.70	1	2.80
82.60	1.60	28.30	22.80	1	25.55
102.60	1.40	21.40	5.40	1	13.40
47.90	1.90	10.80	-1.70	1	4.55
97.10	1.00	-15.70	1.60	1	-7.05
80.00	1.50	-11.10	-7.60	1	-9.35
130.20	2.20	28.30	-11.70	1	8.30
509.30	1.30	-30.20	-3.10	1	-16.65
51.10	1.90	-33.10	-17.50	1	-25.30
62.80	2.00	-31.50	-14.30	1	-22.90
145.20	1.80	13.60	-0.20	1	6.70
150.00	1.30	18.00	13.90	1	15.95
193.30	2.20	48.30	1.20	1	24.75
973.90	1.10	21.60	16.50	1	19.05
46.80	1.40	18.30	10.90	1	14.60
241.60	1.40	21.10	-1.50	1	9.80
861.60	1.10	26.40	-17.00	1	4.70
137.90	1.70	27.30	-6.70	1	10.30
93.20	1.30	18.00	13.90	1	15.95
111.50	1.50	17.30	17.10	1	17.20
392.60	1.90	14.90	-3.50	1	5.70
222.70	1.30	1.50	13.30	1	7.40
575.00	1.00	24.50	11.90	1	18.20
57.50	2.20	-27.20	-30.10	1	-28.65
484.60	0.60	25.40	15.90	1	20.65
252.30	1.10	34.80	25.60	1	30.20
92.50	1.60	32.00	11.40	1	21.70
890.80	0.00	10.70	14.60	1	12.65
890.90	0.70	12.60	3.20	1	7.90
113.90	2.00	15.20	11.40	1	13.30
1588.40	0.40	30.20	20.90	1	25.55
269.50	1.70	6.80	-0.40	1	3.20
133.40	1.70	2.50	-0.40	1	1.05
281.10	1.60	34.40	16.80	1	25.60
120.60	2.00	3.10	1.20	1	2.15
328.50	0.90	22.40	14.10	1	18.25
590.10	1.30	16.90	8.20	2	12.55
771.00	2.00	17.60	8.10	2	12.85
390.10	1.10	40.50	11.70	2	26.10
1055.80	1.30	34.90	8.40	2	21.65
196.00	0.90	7.60	6.60	2	7.10
575.60	0.70	6.80	6.20	2	6.50
469.70	1.10	6.50	9.00	2	7.75
418.90	1.00	4.60	5.60	2	5.10
328.40	0.90	3.50	7.20	2	5.35
448.80	0.90	4.30	5.30	2	4.80
422.40	1.00	14.10	9.20	2	11.65
516.30	0.80	5.40	6.90	2	6.15
929.10	0.80	5.20	5.80	2	5.50
273.50	1.10	15.70	11.80	2	13.75
201.10	1.00	4.80	5.90	2	5.35
439.90	0.70	5.90	7.10	2	6.50
439.80	0.80	5.30	5.70	2	5.50
566.80	0.90	5.10	5.90	2	5.50
502.50	0.80	1.00	6.70	2	3.85
1291.40	1.30	18.60	11.60	2	15.10
351.10	1.50	23.90	10.80	2	17.35
432.60	0.70	5.90	7.20	2	6.55
434.10	1.70	6.40	5.60	2	6.00
352.70	0.80	5.00	7.10	2	6.05
524.50	1.30	9.30	8.40	2	8.85
128.00	0.80	6.30	6.20	2	6.25
394.20	1.20	14.90	9.60	2	12.25
417.60	1.00	3.80	5.20	2	4.50
728.50	0.90	8.60	7.80	2	8.20
552.80	1.00	4.80	6.10	2	5.45
1161.80	1.00	6.50	6.80	2	6.65
740.90	1.20	9.70	8.30	2	9.00
328.70	1.30	4.10	6.20	2	5.15
500.70	1.90	51.30	12.10	2	31.70
152.70	1.10	17.50	11.80	2	14.65
185.00	0.80	6.60	7.10	2	6.85
337.80	0.70	3.40	5.30	2	4.35
577.50	0.60	5.20	5.70	2	5.45
564.30	0.60	6.40	6.60	2	6.50
695.50	0.70	4.50	5.60	2	5.05
433.70	0.70	3.80	4.90	2	4.35
253.50	0.80	4.90	4.80	2	4.85
490.80	0.80	3.10	4.00	2	3.55
580.60	0.80	4.20	5.30	2	4.75
550.10	0.80	4.10	5.40	2	4.75
702.50	0.80	4.80	5.60	2	5.20
1968.90	0.70	4.90	5.50	2	5.20
653.60	0.80	4.80	5.60	2	5.20
359.40	0.80	3.60	4.90	2	4.25
892.70	0.80	5.00	5.50	2	5.25
957.80	0.80	5.20	5.50	2	5.35
507.10	0.80	4.30	5.40	2	4.85
102.10	1.20	6.90	7.80	2	7.35
196.60	1.20	5.90	5.90	2	5.90
546.00	1.00	5.00	6.20	2	5.60
444.70	1.20	3.40	4.90	2	4.15
491.60	1.00	10.60	8.30	2	9.45
332.50	1.00	9.50	7.70	2	8.60
1225.00	0.90	10.30	8.30	2	9.30
343.30	1.00	29.80	11.20	2	20.50
461.70	0.90	11.00	8.00	2	9.50
459.20	0.80	6.10	5.30	2	5.70
423.10	3.10	7.00	6.90	2	6.95
642.90	1.10	26.00	8.00	2	17.00
590.00	1.60	5.10	5.30	2	5.20
344.60	1.80	4.40	3.60	2	4.00