80.2K

Verified Solution

Link Copied!

DATA file Hore than 30,000 locations? MutualFunds 6. Mutual Funds Data. The file Mutual Funds contains a data set with information for 45 mutual funds 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. a. Prepare a Pivot Table 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 (%). b. What conclusions can you draw about the fund type and the average return over the past five years? hat Excel may the column egs as 0-10, 10-20, etc, but they be interpreted 99, 10-19.99 99, etc DATA file Hore than 30,000 locations? MutualFunds 6. Mutual Funds Data. The file Mutual Funds contains a data set with information for 45 mutual funds 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. a. Prepare a Pivot Table 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 (%). b. What conclusions can you draw about the fund type and the average return over the past five years? hat Excel may the column egs as 0-10, 10-20, etc, but they be interpreted 99, 10-19.99 99, etc

Answer & Explanation Solved by verified expert

See Answer