MEANS

1.The attached MS-Excel file contains data on the contains data the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.

a. Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel
c. Present your results in a table and a chart. Cut and paste your chart and table into MS-Word and attach your results.

STANDEV

2.The attached MS-Excel file contains data on the contains data the bus fleet of the Johnson Bus Fleet. Download the file and analyze the characteristics of the Johnson Bus fleet.

a. Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage and Standard deviation of mileage by each fuel type of fuel
c. Present your results in a table. Cut and paste your chart and table into MS-Word and attach your results.

3. The data in the worksheet file MUFUND1.XLS contains information on two types of mutual funds: Equity funds (1), and Bond funds (2). Other variables in the data file are EXP = Expense ratio, PER1 = I year performance (Rate of return), PER3 = 3 year performance (Rate of return). and ASSET = Asset Size in Millions.

What is a Mutual Fund?
A mutual fund in a means by which small investors are able to 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. A bond fund is a mutual fund that invests only in bonds
b. An equity fund is a fund that invests only in stocks (i.e. in ownership claims)
c. The Expense ratio is the ratio of total expenses to total net assets of the fund.
d. 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.

ASSIGNMENT
Using the information from the data file, calculate means and standard deviations to compare the equity funds with the bond funds. Be sure to compare the asset sizes, performances, expense ratios.

4. 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 you results on the Averages in tables and a 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.

MEANS 1.The attached MS-Excel file contains data on the contain...