Find the "Mutual Funds" file. The file Mutualfunds 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 Fl (Fixed Income) Net Asset Value (5): 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 Ranko The risk adjusted star rating for each fund, Morningstar ranks go from a low of 1 Star to a high of 5 stars Prepare a Pivottable that gives the frequency count of the data by Fund Type (rows) and the five-year average annual retum (columns). Use classes of 6-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 five year average return rates are 50% 60%. The answer %. (Make sure no decimal place. For example: 90) If the type of mutual fund is F (Fixed Income), what is the probably of the five-year average return rates are 10%20%. The answer %. (Make sure two decimal places.) What is the probability that a randomly selected mutual fund is Fl (Fixed Income) and 10% 20% return rates? The answer is %. (Make sure two decimal places.) What is the probably that a randomly selected mutualis DE (Domestic Equity) and 30-40% retum rates? The answer is po. (Make sure two decimal places.) is IS 9:20 PM Find the "Mutual Funds" file. The file Mutualfunds 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 Fl (Fixed Income) Net Asset Value (5): 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 Ranko The risk adjusted star rating for each fund, Morningstar ranks go from a low of 1 Star to a high of 5 stars Prepare a Pivottable that gives the frequency count of the data by Fund Type (rows) and the five-year average annual retum (columns). Use classes of 6-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 five year average return rates are 50% 60%. The answer %. (Make sure no decimal place. For example: 90) If the type of mutual fund is F (Fixed Income), what is the probably of the five-year average return rates are 10%20%. The answer %. (Make sure two decimal places.) What is the probability that a randomly selected mutual fund is Fl (Fixed Income) and 10% 20% return rates? The answer is %. (Make sure two decimal places.) What is the probably that a randomly selected mutualis DE (Domestic Equity) and 30-40% retum rates? The answer is po. (Make sure two decimal places.) is IS 9:20 PM
