5 YearExpense Type Freq Morningstar.xlsx contains information for 25 mutual fund

Question

5 YearExpense Type Freq Morningstar.xlsx contains information for 25 mutual funds. Please use Excel to answer the following questions a. How many of them are 4-star? Use 'COUNTIF" function. b. Fill the frequency table shown below. Make a bar chart and a pie chart about fund type Intl. Disc 3 American Century Tax-Free Bon FI 10.73 Which type has the most mutual funds? Type Frequency 13 Kalmar Gr Val Sm Cp c. Use ToolPak to calculate the skewness of the net asset value. Comment on the shape of distri- bution d. Make a scatter diagram with net asset value (as x) and 5-year average return (as y) Comment. 20 T. Rowe Price Mid Val

Explanation / Answer

SOLUTION:

a)

type

=COUNTIF(F2:F26,("4-Star"))

b)

=COUNTIF(B2:b26,("IE"))

=COUNTIF(B2:b26,("FI"))

=COUNTIF(B2:b26,("DE"))

c) you can use skew function in excel

=skew(c2:c26)

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.