Question

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

Using the information from the data file, calculate means and standard deviations to compare the equity funds with the bond funds. Be sure to compare the asset sizes, performances, expense ratios.

Answer 1

Explanation:

Here, 1= equity funds and 2 = bond funds

From the Count table, we found that there are 146 total funds of which 80 are equity funds and 66 are bond funds.

From the above tables, we found that mean and standard deviation of assets for equity funds are 288.865 and 328.123 whereas mean and standard deviation of assets for bond funds are 535.4878 and 306.003, i.e mean assets for bond funds is greater than mean assets of equity funds but standard deviation of asset is more for equity bond.

for Expense ratios, Mean and standard deviation of euity funds are 1.55 and 0.668 whereas mean and standard deviation for bond fund are 1.036 and 0.398, i.e both mean and standard deviation of expense ratios for equity fund are more than bond fund.

for performences 1, Mean and standard deviation of euity funds are 16.253 and 17.325 whereas mean and standard deviation for bond fund are 9.425 and 9.277 , i.e both mean and standard deviation of performences 1 for equity fund are more than bond fund.

for performences 2 , Mean and standard deviation of euity funds are 6.516 and 11.849 whereas mean and standard deviation for bond fund are 7.003 and 2.033 , i.e mean of performences 2 for equity fund is more than bond fund.wheras standard deviation is more for equity funds.