Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HOUSE PRICE YRSOLD HSQFT LOTSFT YRBUILT PRICE_PER_SQFT NEB 1 $536,000 2009.00 1,500 4,000 1930 $357 WESTERLEIGH 2 $498,000 2009.00 1,563 6,100 1950 $318 WESTERLEIGH 3
| HOUSE | PRICE | YRSOLD | HSQFT | LOTSFT | YRBUILT | PRICE_PER_SQFT | NEB |
| 1 | $536,000 | 2009.00 | 1,500 | 4,000 | 1930 | $357 | WESTERLEIGH |
| 2 | $498,000 | 2009.00 | 1,563 | 6,100 | 1950 | $318 | WESTERLEIGH |
| 3 | $506,500 | 2009.00 | 1,536 | 4,000 | 1950 | $329 | WESTERLEIGH |
| 4 | $630,000 | 2009.00 | 1,152 | 4,000 | 1949 | $546 | WESTERLEIGH |
| 5 | $455,000 | 2009.00 | 1,214 | 2,775 | 1925 | $374 | WESTERLEIGH |
| 6 | $265,000 | 2009.00 | 1,627 | 1,800 | 1985 | $190 | WESTERLEIGH |
| 7 | $347,500 | 2009.00 | 1,100 | 4,500 | 1950 | $315 | WESTERLEIGH |
| 8 | $320,000 | 2009.00 | 1,104 | 3,000 | 1925 | $289 | WESTERLEIGH |
| 9 | $535,000 | 2009.00 | 2,400 | 3,879 | 2000 | $222 | WESTERLEIGH |
| 10 | $456,300 | 2009.00 | 1,650 | 2,552 | 2007 | $277 | WESTERLEIGH |
| 11 | $440,000 | 2009.00 | 1,124 | 2,405 | 1930 | $391 | WESTERLEIGH |
| 12 | $413,000 | 2009.00 | 1,410 | 3,600 | 1955 | $292 | WESTERLEIGH |
| 13 | $320,000 | 2009.00 | 1,740 | 7,230 | 1950 | $183 | WESTERLEIGH |
| 14 | $270,000 | 2009.00 | 1,080 | 1,590 | 1925 | $250 | WESTERLEIGH |
| 15 | $375,000 | 2009.00 | 1,158 | 4,500 | 1920 | $323 | WESTERLEIGH |
| 16 | $485,000 | 2009.00 | 1,685 | 5,000 | 1925 | $287 | WESTERLEIGH |
| 17 | $448,000 | 2009.00 | 1,776 | 3,000 | 1915 | $252 | WESTERLEIGH |
| 18 | $425,000 | 2009.00 | 1,148 | 6,100 | 1955 | $370 | WESTERLEIGH |
| 19 | $376,500 | 2009.00 | 1,237 | 3,000 | 1920 | $304 | WESTERLEIGH |
| 20 | $350,000 | 2009.00 | 890 | 3,600 | 1920 | $393 | WESTERLEIGH |
| 21 | $470,000 | 2009.00 | 1,205 | 5,900 | 1955 | $390 | WESTERLEIGH |
| 22 | $420,000 | 2009.00 | 1,207 | 3,828 | 1945 | $347 | WESTERLEIGH |
| 23 | $410,000 | 2009.00 | 1,256 | 3,600 | 1930 | $342 | WESTERLEIGH |
| 24 | $440,000 | 2009.00 | 900 | 3,600 | 1960 | $488 | WESTERLEIGH |
| 25 | $395,000 | 2009.00 | 1,176 | 3,920 | 1930 | $335 | WESTERLEIGH |
| 26 | $355,000 | 2009.00 | 1,296 | 3,000 | 1940 | $304 | WESTERLEIGH |
| 27 | $415,000 | 2009.00 | 1,092 | 4,000 | 1960 | $380 | WESTERLEIGH |
| 28 | $495,000 | 2009.00 | 1,950 | 3,600 | 1920 | $253 | WESTERLEIGH |
| 29 | $355,425 | 2009.00 | 1,600 | 1,744 | 1993 | $222 | WESTERLEIGH |
| 30 | $410,000 | 2009.00 | 1,440 | 3,742 | 1965 | $284 | WESTERLEIGH |
| 31 | $447,500 | 2009.00 | 1,450 | 3,000 | 1970 | $308 | WESTERLEIGH |
| 32 | $420,000 | 2009.00 | 1,420 | 3,758 | 2006 | $296 | WESTERLEIGH |
| 33 | $455,000 | 2009.00 | 1,427 | 3,800 | 1920 | $318 | WESTERLEIGH |
| 34 | $380,000 | 2009.00 | 1,480 | 2,100 | 1970 | $256 | WESTERLEIGH |
| 35 | $400,000 | 2009.00 | 1,512 | 4,000 | 1960 | $264 | WESTERLEIGH |
| 36 | $310,000 | 2009.00 | 1,240 | 960 | 1993 | $250 | WESTERLEIGH |
| 37 | $365,000 | 2009.00 | 840 | 5,000 | 1955 | $434 | WESTERLEIGH |
| 38 | $370,000 | 2009.00 | 1,280 | 3,456 | 1965 | $289 | WESTERLEIGH |
| 39 | $415,000 | 2009.00 | 1,820 | 4,200 | 1960 | $228 | WESTERLEIGH |
| 40 | $419,796 | 2009.00 | 1,592 | 7,575 | 1930 | $263 | WESTERLEIGH |
| 41 | $380,000 | 2009.00 | 1,280 | 3,408 | 1965 | $296 | WESTERLEIGH |
| 42 | $410,000 | 2009.00 | 1,332 | 2,800 | 1970 | $307 | WESTERLEIGH |
| 43 | $435,000 | 2009.00 | 1,660 | 2,373 | 1995 | $262 | WESTERLEIGH |
| 44 | $515,000 | 2009.00 | 1,712 | 5,880 | 1930 | $300 | WESTERLEIGH |
| 45 | $370,000 | 2009.00 | 1,450 | 4,000 | 1955 | $255 | WESTERLEIGH |
| 46 | $429,000 | 2009.00 | 4,040 | 4,040 | 1950 | $106 | WESTERLEIGH |
| 47 | $295,000 | 2009.00 | 1,320 | 2,000 | 1940 | $223 | WESTERLEIGH |
| 48 | $520,000 | 2009.00 | 1,500 | 5,000 | 1960 | $346 | WESTERLEIGH |
| 49 | $410,000 | 2009.00 | 1,500 | 3,000 | 1925 | $273 | WESTERLEIGH |
| 50 | $379,000 | 2009.00 | 926 | 4,000 | 1955 | $409 | WESTERLEIGH |
| 51 | $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 |
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
and please post the excel chart you come up with thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Internal Control Audit And Compliance Documentation And Testing Under The New COSO Framework
Authors: Graham
1st Edition
1118996216, 978-1118996218
