Using the information from the data file, calculate means, and…
QuestionAnswered step-by-stepUsing the information from the data file, calculate means, and…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.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:The Average and the Standard Deviation for Sale Price for houses in the two neighborhoodsThe Average and the Standard Deviation for Sale Price Per Square Foot for houses in the two neighborhoodsThe 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.Present your results on the Averages in tables and charts.List at least four reasons that you think that the average price of houses in one neighborhood will be different from the other neighborhoodHOUSE PRICE YRSOLD HSQFT LOTSFT YRBUILT PRICE_PER_SQFT NEB1 $536,000 2009.00 1,500 4,000 1930 $357 WESTERLEIGH2 $498,000 2009.00 1,563 6,100 1950 $318 WESTERLEIGH3 $506,500 2009.00 1,536 4,000 1950 $329 WESTERLEIGH4 $630,000 2009.00 1,152 4,000 1949 $546 WESTERLEIGH5 $455,000 2009.00 1,214 2,775 1925 $374 WESTERLEIGH6 $265,000 2009.00 1,627 1,800 1985 $190 WESTERLEIGH7 $347,500 2009.00 1,100 4,500 1950 $315 WESTERLEIGH8 $320,000 2009.00 1,104 3,000 1925 $289 WESTERLEIGH9 $535,000 2009.00 2,400 3,879 2000 $222 WESTERLEIGH10 $456,300 2009.00 1,650 2,552 2007 $277 WESTERLEIGH11 $440,000 2009.00 1,124 2,405 1930 $391 WESTERLEIGH12 $413,000 2009.00 1,410 3,600 1955 $292 WESTERLEIGH13 $320,000 2009.00 1,740 7,230 1950 $183 WESTERLEIGH14 $270,000 2009.00 1,080 1,590 1925 $250 WESTERLEIGH15 $375,000 2009.00 1,158 4,500 1920 $323 WESTERLEIGH16 $485,000 2009.00 1,685 5,000 1925 $287 WESTERLEIGH17 $448,000 2009.00 1,776 3,000 1915 $252 WESTERLEIGH18 $425,000 2009.00 1,148 6,100 1955 $370 WESTERLEIGH19 $376,500 2009.00 1,237 3,000 1920 $304 WESTERLEIGH20 $350,000 2009.00 890 3,600 1920 $393 WESTERLEIGH21 $470,000 2009.00 1,205 5,900 1955 $390 WESTERLEIGH22 $420,000 2009.00 1,207 3,828 1945 $347 WESTERLEIGH23 $410,000 2009.00 1,256 3,600 1930 $342 WESTERLEIGH24 $440,000 2009.00 900 3,600 1960 $488 WESTERLEIGH25 $395,000 2009.00 1,176 3,920 1930 $335 WESTERLEIGH26 $355,000 2009.00 1,296 3,000 1940 $304 WESTERLEIGH27 $415,000 2009.00 1,092 4,000 1960 $380 WESTERLEIGH28 $495,000 2009.00 1,950 3,600 1920 $253 WESTERLEIGH29 $355,425 2009.00 1,600 1,744 1993 $222 WESTERLEIGH30 $410,000 2009.00 1,440 3,742 1965 $284 WESTERLEIGH31 $447,500 2009.00 1,450 3,000 1970 $308 WESTERLEIGH32 $420,000 2009.00 1,420 3,758 2006 $296 WESTERLEIGH33 $455,000 2009.00 1,427 3,800 1920 $318 WESTERLEIGH34 $380,000 2009.00 1,480 2,100 1970 $256 WESTERLEIGH35 $400,000 2009.00 1,512 4,000 1960 $264 WESTERLEIGH36 $310,000 2009.00 1,240 960 1993 $250 WESTERLEIGH37 $365,000 2009.00 840 5,000 1955 $434 WESTERLEIGH38 $370,000 2009.00 1,280 3,456 1965 $289 WESTERLEIGH39 $415,000 2009.00 1,820 4,200 1960 $228 WESTERLEIGH40 $419,796 2009.00 1,592 7,575 1930 $263 WESTERLEIGH41 $380,000 2009.00 1,280 3,408 1965 $296 WESTERLEIGH42 $410,000 2009.00 1,332 2,800 1970 $307 WESTERLEIGH43 $435,000 2009.00 1,660 2,373 1995 $262 WESTERLEIGH44 $515,000 2009.00 1,712 5,880 1930 $300 WESTERLEIGH45 $370,000 2009.00 1,450 4,000 1955 $255 WESTERLEIGH46 $429,000 2009.00 4,040 4,040 1950 $106 WESTERLEIGH47 $295,000 2009.00 1,320 2,000 1940 $223 WESTERLEIGH48 $520,000 2009.00 1,500 5,000 1960 $346 WESTERLEIGH49 $410,000 2009.00 1,500 3,000 1925 $273 WESTERLEIGH50 $379,000 2009.00 926 4,000 1955 $409 WESTERLEIGH51 $487,500 2009.00 2,472 3,420 1970 $197 MARINER 52 $425,000 2009.00 2,400 3,800 1975 $177 MARINER 53 $370,000 2009.00 2,100 5,500 1935 $176 MARINER 54 $300,000 2009.00 1,870 2,500 1920 $160 MARINER 55 $385,000 2009.00 1,340 2,500 1925 $287 MARINER 56 $265,000 2009.00 1,992 3,591 1975 $133 MARINER 57 $300,000 2009.00 2,416 3,325 1980 $124 MARINER 58 $339,000 2009.00 1,820 2,850 1920 $186 MARINER 59 $350,000 2009.00 1,650 2,500 1903 $212 MARINER 60 $460,000 2009.00 1,744 4,419 2008 $263 MARINER 61 $214,200 2009.00 1,270 5,721 1925 $168 MARINER 62 $270,000 2009.00 2,200 1,512 1931 $122 MARINER 63 $220,000 2009.00 1,408 2,560 1901 $156 MARINER 64 $290,000 2009.00 1,540 4,950 1901 $188 MARINER 65 $335,000 2009.00 2,800 2,880 1920 $119 MARINER 66 $400,000 2009.00 2,052 5,900 1920 $194 MARINER 67 $485,000 2009.00 1,884 2,886 1975 $257 MARINER 68 $500,000 2009.00 2,080 4,326 1970 $240 MARINER 69 $414,726 2009.00 2100 3,594 2005 $197 MARINER 70 $415,740 2009.00 1,400 3,594 2005 $296 MARINER 71 $560,000 2009.00 2,568 4,000 1970 $218 MARINER 72 $390,100 2009.00 1,896 3,630 1970 $205 MARINER MathStatistics and ProbabilityBU 203Share Question
