What is a Mutual Fund? A mutual fund is a means by which small investors can participate in investments in diversified portfolios by pooling their funds. This is accomplished by contributing money into a pool of funds involving large numbers of investors, the total amount of whose contributions is large, thus making it possible for people who have small sums of money to diversify their portfolios. The money contributed by members is usually managed by investment companies that call themselves mutual funds. Periodically the fund managers distribute profits from dividends or interest payments, and from capital gains. Usually, the returns to investment in mutual funds are net of expenses incurred by the fund managers.

A bond fund is a mutual fund that invests only in bonds

An equity fund is a fund that invests only in stocks (i.e. in ownership claims)

The Expense ratio is the ratio of total expenses to total net assets of the fund.

The three-year performance (Rate of Return) is the average rate of profits over a three-year period.

The one-year performance is the average rate of return in the last fiscal year of the fund.

4. The three-year per URL 5. The one-year performance is the average rate of return in the last fiscal year of the fund Assignment Using the information from the data file, calculate means and standard deviations of Expense Ratio. Three Year Rate of Return, and the One-Year Rate of Return to compare the equity funds with the bond funds. Be sure to compare the asset sizes, performances, expense ratios. Present your results in a table or tables. 3. You have downloaded the MS-Excel file with data on the prices of homes in two neighborhoods around the City of New York. The data is taken from Staten Island. Using the MS-Excel, calculate a. The Average and the Standard Deviation for Sale Price for houses in the two neighborhoods b. The Average and the Standard Deviation for Sale Price Per Square Foot for houses in the two neighborhoods c. The Average and the Standard Deviation for Age of houses in the two neighborhoods. Please note that you must calculate the Age of each house sold. Take note also that all houses were sold in 2009. d. Present your results on the Averages in tables and charts e. List at least four reasons that you think that the average price of houses in one neighborhood will be different from the other neighborhood Activate Windows Go to Settings to activate Windo 1:11 AM 7/22/2020 4. The three-year per URL 5. The one-year performance is the average rate of return in the last fiscal year of the fund Assignment Using the information from the data file, calculate means and standard deviations of Expense Ratio. Three Year Rate of Return, and the One-Year Rate of Return to compare the equity funds with the bond funds. Be sure to compare the asset sizes, performances, expense ratios. Present your results in a table or tables. 3. You have downloaded the MS-Excel file with data on the prices of homes in two neighborhoods around the City of New York. The data is taken from Staten Island. Using the MS-Excel, calculate a. The Average and the Standard Deviation for Sale Price for houses in the two neighborhoods b. The Average and the Standard Deviation for Sale Price Per Square Foot for houses in the two neighborhoods c. The Average and the Standard Deviation for Age of houses in the two neighborhoods. Please note that you must calculate the Age of each house sold. Take note also that all houses were sold in 2009. d. Present your results on the Averages in tables and charts e. List at least four reasons that you think that the average price of houses in one neighborhood will be different from the other neighborhood Activate Windows Go to Settings to activate Windo 1:11 AM 7/22/2020