Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This xcl contains information regarding nine variables from a sample of 184 mutual bond funds: Fund numberIdentification number for each bond fund TypeBond fund type

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

This xcl contains information regarding nine variables from a sample of 184 mutual bond funds: Fund numberIdentification number for each bond fund TypeBond fund type (intermediate government or short-term corporate) AssetsIn millions of dollars FeesSales charges (no or yes) Expense ratioRatio of expenses to net assets in percentage Return 2009Twelve-month return in 2009 Three-year returnAnnualized return, 20072009 Five-year returnAnnualized return, 20052009 RiskRisk-of-loss factor of the mutual fund (below average, average, or above average)

Create and analyse:

a. Summary Table of levels of risk of bond funds.

b. Contingency Tables displaying the type of fund and whether a fee is charged - both based on the number of funds and as a percentage of the overall total, row total and column totals.

c. Frequency Distributions of the 2009 Return.

d. Relative Frequency Distributions and Percentage Distributions of the 2009 Return.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline . & A & B & C & D & E & F & G & H & 1 & J & K & L \\ \hline 1 & Fund Number & Type & Assets & Fees & Expense Ratio & Return 2009 & 3-Year Return & 5-Year Return & Risk & Bins & Midpoints & \\ \hline 2 & FN-1 & Intermediate Government & 7268.1 & No & 0.45 & 6.9 & 6.9 & 5.5 & Below average & -10.01 & -7.5 & \\ \hline 3 & FN2 & Intermediate Government & 475.1 & No & 0.50 & 9.8 & 7.5 & 6.1 & Below average & -5.01 & -2.5 & \\ \hline 4 & FN-3 & Intermediate Government & 193.0 & No & 0.71 & 6.3 & 7.0 & 5.6 & Average & -0.01 & 2.5 & \\ \hline 5 & FN-4 & Intermediate Government & 18603.5 & No & 0.13 & 5.4 & 6.6 & 5.5 & Average & 4.99 & 7.5 & \\ \hline 6 & FN-5 & Intermediate Government & 142.6 & No & 0.60 & 5.9 & 6.7 & 5.4 & Average & 9.99 & 12.5 & \\ \hline 7 & FN-6 & Intermediate Government & 1401.6 & No & 0.54 & 5.7 & 6.4 & 6.2 & Average & 14.99 & 17.5 & \\ \hline 8 & FN-7 & Intermediate Government & 985.6 & No & 0.49 & 3.0 & 6.8 & 5.3 & Average & 19.99 & 22.5 & \\ \hline 9 & FN-8 & Intermediate Government & 2188.8 & No & 0.55 & 7.4 & 6.4 & 5.2 & Below average & 24.99 & 27.5 & \\ \hline 10 & FN-9 & Intermediate Government & 390.6 & No & 0.67 & 5.3 & 6.1 & 5.0 & Below average & 29.99 & 32.5 & \\ \hline 11 & FN-10 & Intermediate Government & 544.1 & No & 0.63 & 5.7 & 6.2 & 5.1 & Below average & 34.99 & & \\ \hline 12 & FN-11 & Intermediate Government & 1407.4 & No & 0.45 & 0.9 & 6.2 & 4.7 & Average & & & \\ \hline 13 & FN-12 & Intermediate Government & 155.5 & No & 0.91 & 12.4 & 6.4 & 5.1 & Below average & & & \\ \hline 14 & FN-13 & Intermediate Government & 397.5 & No & 0.60 & 6.0 & 6.3 & 5.1 & Below average & & & \\ \hline 15 & FN-14 & Intermediate Government & 906.1 & No & 0.51 & 8.1 & 6.1 & 5.1 & Below average & & & \\ \hline 16 & FN-15 & Intermediate Government & 379.1 & No & 0.57 & 5.7 & 6.6 & 5.2 & Below average & & & \\ \hline 17 & FN-16 & Intermediate Government & 62.7 & No & 0.74 & 4.5 & 7.8 & 5.6 & Above average & & & \\ \hline 18 & FN-17 & Intermediate Government & 1539.1 & No & 0.66 & 6.4 & 6.2 & 5.0 & Below average & & & \\ \hline 19 & FN-18 & Intermediate Government & 167.3 & No & 0.60 & 5.8 & 6.2 & 5.1 & Below average & & & \\ \hline 20 & FN-19 & Intermediate Government & 448.0 & No & 0.77 & 10.1 & 6.5 & 5.3 & Below average & & & \\ \hline 21 & FN-20 & Intermediate Government & 238.1 & No & 1.13 & 4.4 & 5.5 & 4.3 & Below average & & & \\ \hline 22 & FN-21 & Intermediate Government & 557.8 & No & 0.74 & 9.0 & 6.0 & 4.9 & Below average & & & \\ \hline 23 & FN-22 & Intermediate Government & 192.7 & No & 0.70 & 3.2 & 6.0 & 4.9 & Average & & & \\ \hline 24 & FN23 & Intermediate Government & 261.8 & Yes & 1.08 & 3.5 & 5.1 & 4.0 & Below average & & & \\ \hline 25 & FN-24 & Intermediate Government & 135.8 & No & 0.65 & -1.1 & 6.0 & 4.6 & Average & & & \\ \hline 26 & FN-25 & Intermediate Government & 1807.3 & Yes & 0.80 & 7.8 & 6.1 & 4.9 & Average & & & \\ \hline 27 & FN-26 & Intermediate Government & 4615.4 & No & 0.45 & 1.3 & 6.7 & 5.2 & Above average & & & \\ \hline 28 & FN-27 & Intermediate Government & 86.2 & No & 0.61 & -0.2 & 5.6 & 4.4 & Average & & & \\ \hline 29 & FN-28 & Intermediate Government & 291.1 & Yes & 1.10 & 5.1 & 5.8 & 4.6 & Below average & & & \\ \hline 30 & FN-29 & Intermediate Government & 6332.5 & Yes & 0.73 & 4.8 & 6.0 & 4.9 & Below average & & & \\ \hline 31 & FN-30 & Intermediate Government & 110.7 & No & 1.08 & 1.9 & 5.4 & 4.2 & Average & & & \\ \hline 32 & FN-31 & Intermediate Government & 619.7 & Yes & 0.96 & 5.0 & 5.9 & 4.9 & Average & & & \\ \hline 33 & FN-32 & Intermediate Government & 628.7 & No & 0.55 & 2.1 & 6.3 & 5.1 & Above average & & & \\ \hline 34 & FN-33 & Intermediate Government & 274.3 & No & 0.80 & 12.7 & 6.1 & 5.0 & Average & & & \\ \hline 35 & FN-34 & Intermediate Government & 891.8 & Yes & 0.88 & 4.2 & 6.6 & 5.1 & Average & & & \\ \hline 36 & FN-35 & Intermediate Government & 94.7 & Yes & 0.83 & 3.5 & 6.4 & 5.1 & Average & & & \\ \hline 37 & FN-36 & Intermediate Government & 676.3 & Yes & 0.93 & 22.3 & 9.4 & 6.4 & Above average & & & \\ \hline 38 & FN-37 & Intermediate Government & 1182.1 & Yes & 0.92 & 28.6 & 9.4 & 6.8 & Above average & & & \\ \hline \end{tabular} SUM \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I & J & K & L \\ \hline 74 & FN-73 & Intermediate Government & 792.1 & Yes & 1.00 & 1.2 & 2.3 & 2.6 & Above average & & & \\ \hline 75 & FN-74 & Intermediate Government & 583.5 & No & 0.50 & 6.0 & 7.3 & 5.7 & Average & & & \\ \hline 76 & FN-75 & Intermediate Government & 56.1 & No & 0.65 & 0.7 & 5.2 & 4.4 & Average & & & \\ \hline 77 & FN-76 & Intermediate Government & 285.5 & No & 0.36 & 7.1 & 5.5 & 4.8 & Below average & & & \\ \hline 78 & FN-77 & Intermediate Government & 640.3 & No & 0.27 & 0.2 & 6.5 & 5.2 & Above average & & & \\ \hline 79 & FN-78 & Intermediate Government & 84.7 & Yes & 1.00 & -0.6 & 2.5 & 2.5 & Average & & & \\ \hline 80 & FN-79 & Intermediate Government & 81.3 & Yes & 1.16 & 7.0 & 1.0 & 1.7 & Above average & & & \\ \hline 81 & FN80 & Intermediate Government & 611.7 & No & 0.51 & 6.5 & 6.8 & 5.5 & Average & & & \\ \hline 82 & FN81 & Intermediate Government & 595.1 & No & 0.55 & 5.5 & 6.3 & 5.2 & Below average & & & \\ \hline 83 & FN82 & Intermediate Government & 131.3 & No & 0.65 & -3.8 & 4.4 & 3.8 & Above average & & & \\ \hline 84 & FN83 & Intermediate Government & 88.0 & No & 0.82 & 2.0 & 5.8 & 4.5 & Average & & & \\ \hline 85 & FN-84 & Intermediate Government & 686.6 & Yes & 0.94 & 7.2 & 3.7 & 3.5 & Below average & & & \\ \hline 86 & FN85 & Intermediate Government & 3531.8 & No & 0.12 & -1.6 & 7.2 & 5.4 & Above average & & & \\ \hline 87 & FN-86 & Intermediate Government & 358.0 & Yes & 1.06 & 0.5 & 4.9 & 4.0 & Average & & & \\ \hline 88 & FN-87 & Intermediate Government & 33.0 & No & 1.00 & 0.2 & 6.1 & 4.8 & Below average & & & \\ \hline 89 & FN88 & Short Term Corporate & 139.1 & No & 0.51 & 5.5 & 5.1 & 4.3 & Below average & & & \\ \hline 90 & FN-89 & Short Term Corporate & 123.9 & No & 0.32 & 5.0 & 4.4 & 4.1 & Below average & & & \\ \hline 91 & FN-90 & Short Term Corporate & 1922.0 & Yes & 1.08 & 12.1 & 5.5 & 5.0 & Average & & & \\ \hline 92 & FN-91 & Short Term Corporate & 203.4 & Yes & 1.00 & 8.3 & 5.2 & 4.4 & Below average & & & \\ \hline 93 & FN92 & Short Term Corporate & 66.1 & No & 0.71 & 6.8 & 4.9 & 4.0 & Below average & & & \\ \hline 94 & FN-93 & Short Term Corporate & 1346.0 & No & 0.65 & 8.6 & 6.1 & 4.8 & Below average & & & \\ \hline 95 & FN-94 & Short Term Corporate & 4772.9 & No & 0.56 & 5.0 & 4.9 & 4.2 & Below average & & & \\ \hline 96 & FN-95 & Short Term Corporate & 77.5 & No & 0.51 & 2.2 & 3.7 & 3.5 & Below average & & & \\ \hline 97 & FN-96 & Short Term & 76.2 & No & 0.68 & 2.5 & 5.2 & 4.2 & Below average & & & \\ \hline 98 & FN-97 & Short Term _... . ate & 146.3 & No & 0.55 & 12.2 & 5.8 & 4.8 & Average & & & \\ \hline 99 & FN-98 & Short Term Corporate & 49.2 & No & 0.60 & 10.0 & 5.0 & 4.6 & Average & & & \\ \hline 100 & FN-99 & Short Term Corporate & 96.1 & No & 0.73 & 7.3 & 4.8 & 4.1 & Below average & & & \\ \hline 101 & FN-100 & Short Term Corporate & 226.8 & No & 0.45 & 2.9 & 3.6 & 3.6 & Below average & & & \\ \hline 102 & FN-101 & Short Term Corporate & 122.3 & No & 0.53 & 7.3 & 5.9 & 4.6 & Average & & & \\ \hline 103 & FN-102 & Short Term Corporate & 725.9 & No & 0.68 & 15.5 & 5.9 & 4.7 & Average & & & \\ \hline 104 & FN-103 & Short Term Corporate & 1248.4 & No & 0.72 & 14.0 & 5.5 & 4.7 & Average & & & \\ \hline 105 & FN-104 & Short Term Corporate & 36.5 & No & 0.76 & 5.5 & 5.0 & 4.0 & Below average & & & \\ \hline 106 & FN-105 & Short Term Corporate & 127.4 & No & 0.45 & 3.6 & 3.3 & 3.3 & Below average & & & \\ \hline 107 & FN-106 & Short Term Corporate & 605.2 & No & 0.30 & 8.1 & 4.1 & 3.7 & Average & & & \\ \hline 108 & FN-107 & Short Term Corporate & 1879.2 & No & 0.48 & 9.6 & 4.9 & 4.2 & Average & & & \\ \hline 109 & FN-108 & Short Term Corporate & 964.7 & Yes & 0.85 & 12.9 & 7.1 & 5.3 & Average & & & \\ \hline 110 & FN-109 & Short Term Corporate & 325.3 & No & 0.53 & 10.7 & 4.5 & 4.1 & Average & & & \\ \hline 111 & FN-110 & Short Term Corporate & 69.8 & No & 0.90 & 6.0 & 4.6 & 3.8 & Average & & & \\ \hline 112 & FN-111 & Short Term Corporate & 177.8 & Yes & 0.94 & 8.2 & 5.4 & 4.4 & Below average & & & \\ \hline 113 & FN-112 & Short Term Corporate & 156.6 & No & 0.63 & 12.0 & 6.3 & 4.9 & Average & & & \\ \hline 114 & FN-113 & Short Term Corporate & 244.9 & No & 0.81 & 16.4 & 5.5 & 4.6 & Average & & & \\ \hline 115 & FN-114 & Short Term Corporate & 475.5 & Yes & 0.91 & 6.0 & 6.4 & 4.7 & Average & & & \\ \hline 116 & FN-115 & Short Term Corporate & 46.1 & No & 0.92 & 5.4 & 4.2 & 3.6 & Average & & & \\ \hline 117 & FN-116 & Short Term Corporate & 181.3 & No & 0.36 & 4.9 & 4.5 & 3.8 & Average & & & \\ \hline 118 & FN-117 & Short Term Corporate & 63.8 & Yes & 0.62 & 8.6 & 5.5 & 4.3 & Average & & & \\ \hline 119 & FN-118 & Short Term Corporate & 135.4 & No & 0.70 & 6.8 & 4.2 & 3.7 & Below average & & & \\ \hline 120 & FN-119 & Short Term Corporate & 388.0 & No & 0.56 & 6.7 & 4.6 & 3.8 & Below average & & & \\ \hline 121 & FN-120 & Short Term Corporate & 18.6 & No & 0.89 & 4.1 & 3.4 & 3.1 & Below average & & & \\ \hline 122 & FN-121 & Short Term Corporate & 298.1 & No & 0.51 & 11.2 & 5.0 & 4.3 & Average & & & \\ \hline 123 & FN-122 & Short Term Corporate & 461.3 & No & 0.46 & 8.4 & 4.5 & 4.0 & Average & & & \\ \hline 124 & FN123 & Short Term Corporate & 159.9 & Yes & 0.80 & 5.9 & 4.8 & 4.0 & Below average & & & \\ \hline 125 & FN-124 & Short Term Corporate & 3662.7 & No & 0.52 & 9.0 & 5.2 & 4.3 & Average & & & \\ \hline 126 & FN125 & Short Term Corporate & 42.6 & No & 0.74 & 5.4 & 4.6 & 4.0 & Below average & & & \\ \hline 127 & FN-126 & Short Term Corporate & 111.4 & No & 0.97 & 9.1 & 4.5 & 3.7 & Below average & & & \\ \hline 128 & FN-127 & Short Term Corporate & 114.5 & No & 0.65 & 9.5 & 4.9 & 4.1 & Below average & & & \\ \hline \end{tabular}

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

Commodity Market Trading And Investment

Authors: Tom James

1st Edition

1137432802, 978-1137432803

More Books

Students also viewed these Finance questions