The following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables:Use Excel to answer the following question:a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10).B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong?Group of answer choicesOut of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%). Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%).Out of the 45 mutual funds, there are 28 DE type of funds. Out of the 45 mutual funds, there are 10 FI type of funds. C.What conclusions can you draw about the fund type and the average return over the past 5 years? TABLE 2.12 FINANCIAL DATA FOR A SAMPLE OF 45 MUTUAL FUNDSFund NameAmer Cent Inc & Growth InvAmerican Century Intl DiscAmerican Century Tax-Free BondAmerican Century UltraArielArtisan Intl ValArtisan Small CapBaron AssetBrandywineBrown Cap SmallBuffalo Mid CapDelafieldDFA U.S. Micro CapDodge & Cox IncomeFairholmeFidelity ContrafundFidelity Municipal IncomeFidelity OverseasFidelity Sel ElectronicsFidelity Sh-Term BondFidelityFPA New IncomeGabelli Asset AAAGreenspringJanusJanus WorldwideKalmar Gr Val Sm CpManagers Freemont BondMarsico 21st CenturyMathews Pacific TigerMeridan ValueOakmark IPIMCO Emerg Mkts Bd DRS Value AT. Rowe Price Latin AmT. Rowe Price Mid ValTempleton Growth AThornburg Value AUSAA IncomeVanguard Equity-IncVanguard Global EquityVanguard GNMAVanguard Sht-Tm TEVanguard Sm Cp IdxWasatch Sm Cp Growth7WFundTypeDEIEFI"DEDEIEDEDEDEDEDEDEDEFIDEDEAlIEDEMDEFIDEDEDEIEDEFIDEIEDEDEFIDEIEDEIEDEFIDEIEFIFIDEDENet AssetValue ($)28.8814.3710.7324.9446.3925.5216.9250,6736.5835.7315.2924.3213.4712.5131.8673.1112.5848.3945.608.6039.8510.9549.8123.5932.2654.8315.3010.5617.4427,8631.9240.3710.6826.2753.8922.4624.0737.5312.1024.4223.7110.3715.6832.5835.415-YearAverageReturn (%)12.3930.533.3410.8811.3224.9515.6716.7718.1415.8547.2517.7717.234.3118.2317.994.4123.4613.502.7614.404,6316.7012.4612.8112.3115.315.1415.1632.7015.339.5113.5723.6851.1016.9115.9115.464.3113.4121.774.252.3717.0113.98ExpenseRatio (%)0.671.410,490.991.031.231.181.311.081.201.021.320.530.441.000.890.450.900.890.450.560.621.361.070.900.861.320.601.311.161.081.051.251.361.240.801.011.270.620.290.640.210.160.231.19MorningstarRank2-Star3-Star4-Star3-Star2-Star3-Star3-Star5-Star4-Star4-Star3-Star4-Star3-Star4-Star5-Star5-Star5-Star4-Star3-Star3-Star4-Star3-Star4-Star3-Star3-Star2-Star3-Star5-Star5-Star3-Star4-Star2-Star3-Star4-Star4-Star4-Star3-Star4-Star3-Star4-Star5-Star5-Star3-Star3-Star4-Starbersa9,8

Given information: Fund Type 5-Year Average Return(%) DE 12.39 IE 30.53 FI 3.34 DE 10.88…

Answered: The following table shows a data set…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

The following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables:

Use Excel to answer the following question:

a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10).

B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong?

Group of answer choices

Out of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%).

Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%).

Out of the 45 mutual funds, there are 28 DE type of funds.

Out of the 45 mutual funds, there are 10 FI type of funds.

C.What conclusions can you draw about the fund type and the average return over the past 5 years?

TABLE 2.12 FINANCIAL DATA FOR A SAMPLE OF 45 MUTUAL FUNDS
Fund Name
Amer Cent Inc & Growth Inv
American Century Intl Disc
American Century Tax-Free Bond
American Century Ultra
Ariel
Artisan Intl Val
Artisan Small Cap
Baron Asset
Brandywine
Brown Cap Small
Buffalo Mid Cap
Delafield
DFA U.S. Micro Cap
Dodge & Cox Income
Fairholme
Fidelity Contrafund
Fidelity Municipal Income
Fidelity Overseas
Fidelity Sel Electronics
Fidelity Sh-Term Bond
Fidelity
FPA New Income
Gabelli Asset AAA
Greenspring
Janus
Janus Worldwide
Kalmar Gr Val Sm Cp
Managers Freemont Bond
Marsico 21st Century
Mathews Pacific Tiger
Meridan Value
Oakmark I
PIMCO Emerg Mkts Bd D
RS Value A
T. Rowe Price Latin Am
T. Rowe Price Mid Val
Templeton Growth A
Thornburg Value A
USAA Income
Vanguard Equity-Inc
Vanguard Global Equity
Vanguard GNMA
Vanguard Sht-Tm TE
Vanguard Sm Cp Idx
Wasatch Sm Cp Growth
7
W
Fund
Type
DE
IE
FI"
DE
DE
IE
DE
DE
DE
DE
DE
DE
DE
FI
DE
DE
Al
IE
DE
M
DE
FI
DE
DE
DE
IE
DE
FI
DE
IE
DE
DE
FI
DE
IE
DE
IE
DE
FI
DE
IE
FI
FI
DE
DE
Net Asset
Value ($)
28.88
14.37
10.73
24.94
46.39
25.52
16.92
50,67
36.58
35.73
15.29
24.32
13.47
12.51
31.86
73.11
12.58
48.39
45.60
8.60
39.85
10.95
49.81
23.59
32.26
54.83
15.30
10.56
17.44
27,86
31.92
40.37
10.68
26.27
53.89
22.46
24.07
37.53
12.10
24.42
23.71
10.37
15.68
32.58
35.41
5-Year
Average
Return (%)
12.39
30.53
3.34
10.88
11.32
24.95
15.67
16.77
18.14
15.85
47.25
17.77
17.23
4.31
18.23
17.99
4.41
23.46
13.50
2.76
14.40
4,63
16.70
12.46
12.81
12.31
15.31
5.14
15.16
32.70
15.33
9.51
13.57
23.68
51.10
16.91
15.91
15.46
4.31
13.41
21.77
4.25
2.37
17.01
13.98
Expense
Ratio (%)
0.67
1.41
0,49
0.99
1.03
1.23
1.18
1.31
1.08
1.20
1.02
1.32
0.53
0.44
1.00
0.89
0.45
0.90
0.89
0.45
0.56
0.62
1.36
1.07
0.90
0.86
1.32
0.60
1.31
1.16
1.08
1.05
1.25
1.36
1.24
0.80
1.01
1.27
0.62
0.29
0.64
0.21
0.16
0.23
1.19
Morningstar
Rank
2-Star
3-Star
4-Star
3-Star
2-Star
3-Star
3-Star
5-Star
4-Star
4-Star
3-Star
4-Star
3-Star
4-Star
5-Star
5-Star
5-Star
4-Star
3-Star
3-Star
4-Star
3-Star
4-Star
3-Star
3-Star
2-Star
3-Star
5-Star
5-Star
3-Star
4-Star
2-Star
3-Star
4-Star
4-Star
4-Star
3-Star
4-Star
3-Star
4-Star
5-Star
5-Star
3-Star
3-Star
4-Star
bersa
9,8

Expert Solution

Step 1

Given information:

Fund Type	5-Year Average Return(%)
DE	12.39
IE	30.53
FI	3.34
DE	10.88
DE	11.32
IE	24.95
DE	15.67
DE	16.77
DE	18.14
DE	15.85
DE	17.25
DE	17.77
DE	17.23
FI	4.31
DE	18.23
DE	17.99
FI	4.41
IE	23.46
DE	13.5
FI	2.76
DE	14.4
FI	4.63
DE	16.7
DE	12.46
DE	12.81
IE	12.31
DE	15.31
FI	5.14
DE	15.16
IE	32.7
DE	15.33
DE	9.51
FI	13.57
DE	23.68
IE	51.1
DE	16.91
IE	15.91
DE	15.46
FI	4.31
DE	13.41
IE	21.77
FI	4.25
FI	2.37
DE	17.01
DE	13.98