a. Prepare a crosstabulation with 5 year average return as the columns and net a

Question

a. Prepare a crosstabulation with 5 year average return as the columns and net asset value as the rows. Use classes starting with 0 in increments of 10 for Net Asset Value.
b. Comment on the relationship, if any, between variables.




TABLE 2.12 FINANCIAL DATA FOR A SAMPLE OF 45 MUTUAL FUNDS Fund Type Net Asset Value ($) Average Return (%) 12.39 Expense Ratio (%) Morningstar Rank Fund Name DE 28.88 Amer Cent Inc & Growth Inv American Century Intl. Disc American Century Tax-Free Bond American Century Ultra FI 4-Star 3-Star 46.39 11.32 24.95 Artisan Intl Va Artisan Small Cap Baron Asset Brandywine Brown Cap Small Buffalo Mid Cap 36.58 DEI 35.73 DFA U.S. Micro Cap Dodge & Cox Income Fairholme 12.51 5-Star Fidelity Municipal Income Fidelity Overseas 5-Star 48.39 45.60 Fidelity Sel Electronics 3-Star 3-Star 4-Star 3-Star ile Fidelity Sh-Term Bond 39.85 FPA New Income Gabelli Asset AAA Funds 23.59 32.26 Janus Worldwide Kalmar Gr Val Sm Cp Managers Freemont Bond Marsico 21st Century Mathews Pacific Tiger Meridan Value DEI 15.30 5-Star 31.92 DEI 40.37 PIMCO Emerg Mkts Bd D RS Value A T. Rowe Price Latin Am. T. Rowe Price Mid Val Templeton Growth A Thomburg Value A USAA Income 3-Star 23.68 DE 22.46 24.07 DEI 37.53 4-Star 4-Star 3-Star Vanguard Global Equity Vanguard GNMA Vanguard Sht-Tm TE Vanguard Sm Cp Idx 3-Star 4-Star Wasatch Sm Cp Growth DE 35.41

Explanation / Answer

a.) Please find the cross tabulation below:

b.)

-> Clearly visible that there are more companies woth net asset value between 10 to 30

-> But it looks like that average return increases with increase in asset value showing that they are more stable and with less risk.

Bin Number Bins(Net-Asset) Frequency (5-Year Average Return) Sum(5-Year Average return) Mean (5-Year Average return) 1 0 -9 1 2.76 2.760 2 10-19 15 157.48 10.499 3 20-29 11 202.83 18.439 4 30-39 8 126.81 15.851 5 40-49 4 57.79 14.448 6 50-59 3 80.18 26.727 7 60-69 0 0 NULL 8 70-79 1 17.99 17.99

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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