Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Chuck Williams

4th Edition

978-0324316797, 0324316798

More Books

Students also viewed these General Management questions

Question

What part of a neuron responsible for receiving information?

Answered: 1 week ago

Question

In evolutionary terms with is the oldest pat of the brain ?

Answered: 1 week ago

Question

The limbic system includes?

Answered: 1 week ago

Question

Which is the most common neurotransmitter in the brain?

Answered: 1 week ago

Question

What was new York's original name?

Answered: 1 week ago