Fund Name	Fund Type	Net Asset Value ($)	5 Year Average Return (%)	Expense Ratio (%)	Morningstar Rank (Stars)
Fidelity	DE	39.85	14.40	0.56	4
Fairholme	DE	31.86	18.23	1.00	5
Ariel	DE	46.39	11.32	1.03	2
American Century Intl. Disc	IE	14.37	30.53	1.41	3
T. Rowe Price Mid Val	DE	22.46	16.91	0.80	4
Vanguard Equity-Inc	DE	24.42	13.41	0.29	4
Dodge & Cox Income	FI	12.51	4.31	0.44	4
Oakmark I	DE	40.37	9.51	1.05	2
Fidelity Overseas	IE	48.39	23.46	0.90	4
Marsico 21st Century	DE	17.44	15.16	1.31	5
Vanguard Sm Cp Idx	DE	32.58	17.01	0.23	3
Brown Cap Small	DE	35.73	15.85	1.20	4
Vanguard Sht-Tm TE	FI	15.68	2.37	0.16	3
USAA Income	FI	12.10	4.31	0.62	3
T. Rowe Price Latin Am.	IE	53.89	51.10	1.24	4
Managers Freemont Bond	FI	10.56	5.14	0.60	5
Wasatch Sm Cp Growth	DE	35.41	13.98	1.19	4
Buffalo Mid Cap	DE	15.29	17.25	1.02	3
Artisan Intl Val	IE	25.52	24.95	1.23	3
Fidelity Contrafund	DE	73.11	17.99	0.89	5
Janus	DE	32.26	12.81	0.90	3
American Century Tax-Free Bond	FI	10.73	3.34	0.49	4
Meridan Value	DE	31.92	15.33	1.08	4
FPA New Income	FI	10.95	4.63	0.62	3
Fidelity Sel Electronics	DE	45.60	13.50	0.89	3
Vanguard GNMA	FI	10.37	4.25	0.21	5
RS Value A	DE	26.27	23.68	1.36	4
PIMCO Emerg Mkts Bd D	FI	10.68	13.57	1.25	3
Baron Asset	DE	50.67	16.77	1.31	5
American Century Ultra	DE	24.94	10.88	0.99	3
Mathews Pacific Tiger	IE	27.86	32.70	1.16	3
Fidelity Municipal Income	FI	12.58	4.41	0.45	5

The file MutualFundsSecond contains a data set with information that are part of the Morningstar Funds 500. 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.

Present 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-10, 10-20, 20-30, etc.. for the Five-Year Average Return (%). Note that the dataset is revised. Make sure two decimal places in your calculation.

If the type of mutual fund is DE (Domestic Equity), what is the probability that the five-year average return rates are 20%-30%. The answer is %. (Make sure two decimal places.)

If the type of mutual fund is IE (International Equity), the probability of the fiver-year average return rates are 50%-60%. The answer is %. (Make sure no decimal place. For example: 90)

If the type of mutual fund is FI (Fixed Income), what is the probably of the five-year average return rates are 10%-20%. The answer is %. (Make sure two decimal places.)

What is the probability that a randomly selected mutual fund is FI (Fixed Income) and 10%-20% return rates? The answer is %. (Make sure two decimal places.)

What is the probably that a randomly selected mutual is DE (Domestic Equity) and 30-40% return rates? The answer is %. (Make sure two decimal places.)