Question
Can you assist me with the excel formulas for this problem The file Mutual Funds contains a data set with information for 45 mutual funds
Can you assist me with the excel formulas for this problem
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: Note that Excel may display the column headings as 010, 1020, 2030, etc., but they should be interpreted as 09.99, 1019.99, 2029.99, etc. 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. 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 09.99, 1019.99, 2029.99, 3039.99, 4049.99, and 5059.99 for the Five-Year Average Return (%).
Fund Type | Net Asset Value ($) | 5 Year Average Return (%) | Expense Ratio (%) | Morningstar Rank (Stars) |
DE | 28.88 | 12.39 | 0.67 | 2 |
IE | 14.37 | 30.53 | 1.41 | 3 |
FI | 10.73 | 3.34 | 0.49 | 4 |
DE | 24.94 | 10.88 | 0.99 | 3 |
DE | 46.39 | 11.32 | 1.03 | 2 |
IE | 25.52 | 24.95 | 1.23 | 3 |
DE | 16.92 | 15.67 | 1.18 | 3 |
DE | 50.67 | 16.77 | 1.31 | 5 |
DE | 36.58 | 18.14 | 1.08 | 4 |
DE | 35.73 | 15.85 | 1.20 | 4 |
DE | 15.29 | 17.25 | 1.02 | 3 |
DE | 24.32 | 17.77 | 1.32 | 4 |
DE | 13.47 | 17.23 | 0.53 | 3 |
FI | 12.51 | 4.31 | 0.44 | 4 |
DE | 31.86 | 18.23 | 1.00 | 5 |
DE | 73.11 | 17.99 | 0.89 | 5 |
FI | 12.58 | 4.41 | 0.45 | 5 |
IE | 48.39 | 23.46 | 0.90 | 4 |
DE | 45.60 | 13.50 | 0.89 | 3 |
FI | 8.60 | 2.76 | 0.45 | 3 |
DE | 39.85 | 14.40 | 0.56 | 4 |
FI | 10.95 | 4.63 | 0.62 | 3 |
DE | 49.81 | 16.70 | 1.36 | 4 |
DE | 23.59 | 12.46 | 1.07 | 3 |
DE | 32.26 | 12.81 | 0.90 | 3 |
IE | 54.83 | 12.31 | 0.86 | 2 |
DE | 15.30 | 15.31 | 1.32 | 3 |
FI | 10.56 | 5.14 | 0.60 | 5 |
DE | 17.44 | 15.16 | 1.31 | 5 |
IE | 27.86 | 32.70 | 1.16 | 3 |
DE | 31.92 | 15.33 | 1.08 | 4 |
DE | 40.37 | 9.51 | 1.05 | 2 |
FI | 10.68 | 13.57 | 1.25 | 3 |
DE | 26.27 | 23.68 | 1.36 | 4 |
IE | 53.89 | 51.10 | 1.24 | 4 |
DE | 22.46 | 16.91 | 0.80 | 4 |
IE | 24.07 | 15.91 | 1.01 | 3 |
DE | 37.53 | 15.46 | 1.27 | 4 |
FI | 12.10 | 4.31 | 0.62 | 3 |
DE | 24.42 | 13.41 | 0.29 | 4 |
IE | 23.71 | 21.77 | 0.64 | 5 |
FI | 10.37 | 4.25 | 0.21 | 5 |
FI | 15.68 | 2.37 | 0.16 | 3 |
DE | 32.58 | 17.01 | 0.23 | 3 |
DE | 35.41 | 13.98 | 1.19 | 4 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started