The file MutualFunds contains a data set with information for 45 mutual funds that are part of
Question:
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 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–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? Mutual Funds
Mutual funds are like a pool of funds gathered by different small investors that have simalar investment perspective about returns on their investments. These funds are managed by professional investment managers who act smartly on behalf of the...
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Question Posted: