| | | | | Olivia Stratton | | | | | Price: S-L | | Percentiles | for Price | | | | | | | mean | median | minimum | maximum | standard deviation |
| address | price | bedrooms | bathrooms | house ft2 | lot ft2 | yr built | zip code | 1 | $279,500 | | Minimum | $279,500 | | | | | | price | $750,233 | $670,000 | $279,500 | $1,270,000 | 285792.8112 |
| 8353 18th Ave NW | $630,000 | 1 | 1 | 1,440 | 4,005 | 1930 | 98117 | 2 | $385,000 | | 25th percentile | $554,000 | (25/100)15 = | 3.75 ~ 4 | | | | bedrooms | $750,233 | 3 | 1 | 4 | 0.8837151017 |
| 1932 NW 98th St | $950,000 | 3 | 2.5 | 1,610 | 4,791 | 1981 | 98117 | 3 | $450,000 | | 50th percentile | $670,000 | (50/100)15 = | 7.5 ~ 8 | | | | bathrooms | 1.95 | 2 | 1 | 3 | 0.5840132092 |
| 2141 NW 96th St | $279,500 | 2 | 1 | 860 | 7,840 | 1920 | 98117 | 4 | $554,000 | | 75th percentile | $950,000 | (75/100)15 = | 11.25 ~ 12 | | | | house ft2 | 1,858 | 2,000 | 860 sqft | 2,850 sqft | 551.5122327 |
| 608 NW 77th St | $760,000 | 3 | 2 | 2,000 | 3,811 | 1926 | 98117 | 5 | $630,000 | | Maximum | $1,270,000 | | | | | | lot ft2 | 4,274 | 4,005 | 1,043 sqft | 7,840 sqft | 1588.800131 |
| 7519 24th Ave NW | $554,000 | 3 | 2.5 | 1,150 | 1,043 | 2001 | 98117 | 6 | $635,000 | | | | | | | | | yr built | 1950.866667 | 1930 | 1906 | 2014 | 37.065322 |
| 6553 1st Ave NW | $1,135,000 | 3 | 2 | 2,400 | 4,500 | 1924 | 98117 | 7 | $650,000 | | IQR of points: | 950000 - 554000 = . | 396,000 |
| 7010 23rd Ave NW | $1,270,000 | 3 | 2.5 | 2,850 | 3,750 | 2014 | 98117 | 8 | $670,000 |
| 8366 31st Ave NW | $450,000 | 3 | 1 | 1,530 | 4,000 | 1906 | 98117 | 7 | $760,000 |
| 148 NW 81st St | $635,000 | 4 | 2 | 2,240 | 3,920 | 1941 | 98117 | 6 | $860,000 |
| 2417 NW 77th St | $650,000 | 4 | 2 | 2,200 | 4,000 | 1962 | 98117 | 5 | $950,000 |
| 8530 14th Ave NW | $950,000 | 3 | 3 | 2,190 | 6,160 | 2007 | 98117 | 4 | $950,000 |
| 9702 8th Ave NW | $385,000 | 2 | 2 | 1,440 | 1,820 | 1984 | 98117 | 3 | $1,075,000 |
| 6703 17th Ave NW | $1,075,000 | 4 | 2 | 2,450 | 5,227 | 1912 | 98117 | 2 | $1,135,000 |
| 7712 9th Ave NW | $860,000 | 4 | 1.75 | 2,073 | 4,234 | 1930 | 98117 | 1 | $1,270,000 |
| 7717 11th Ave NW | $670,000 | 2 | 2 | 1,440 | 5,009 | 1925 | 98117 |
| | 285792.8112 |
| | 81677530952 |
| Mean | $750,233 | 2.933333333 | 1.95 | 1,858 | 4,274 | 1950.866667 |
| Median | $670,000 | 3 | 2 | 2,000 | 4,005 | 1930 |
| Min | $279,500 | 1 | 1 | 860 | 1,043 | 1906 |
| Max | $1,270,000 | 4 | 3 | 2,850 | 7,840 | 2014 |
| Stdev | 285792.8112 | 0.8837151017 | 0.5840132092 | 551.5122327 | 1588.800131 | 37.065322 |
| Address | Price | Bedrooms | Bathrooms | House ft2 | Lot ft2 | Year built | Zipcode | Sarah Dundas (Queen Anne) |
| 1016 W Howe St, Seattle, WA 98119 | 552,700 | 2 | 2 | 2,200 | 2,800 | 1925 | 98119 |
| 2541 13th Ave W, Seattle, WA 98119 | 525,000 | 3 | 2 | 1,840 | 2,048 | 1926 | 98119 |
| 8 W Fulton St, Seattle, WA 98119 | 535,000 | 2 | 1.5 | 1,610 | 3,005 | 1947 | 98119 |
| 2540 12th Ave W, Seattle, WA 98119 | 775,000 | 2 | 1.5 | 1,591 | 3,920 | 1911 | 98119 |
| 2217 14th Ave W, Seattle, WA 98119 | 540,000 | 4 | 2 | 1,730 | 2,626 | 1908 | 98119 |
| 2111 5th Ave W, Seattle, WA 98119 | 557,000 | 2 | 1 | 770 | 3,600 | 1900 | 98119 |
| 1922 11th Ave W #B, Seattle, WA 98119 | 575,000 | 3 | 3.25 | 1,280 | 1,742 | 2005 | 98119 |
| 2517 2nd Ave W, Seattle, WA 98119 | 575,000 | 3 | 3 | 2,860 | 3,600 | 1909 | 98119 |
| 2129 6th Ave W, Seattle, WA 98119 | 589,000 | 4 | 2.75 | 1,100 | 3,600 | 1904 | 98119 |
| 715 W Florentina Pl, Seattle, WA 98119 | 866,000 | 4 | 3 | 2,410 | 5,543 | 1929 | 98119 |
| 920 W Emerson St, Seattle, WA 98119 | 690,000 | 3 | 1.1 | 1,290 | 4,356 | 1949 | 98119 |
| 1985 Gilman Dr W, Seattle, WA 98119 | 832,100 | 2 | 2 | 1,460 | 2,613 | 2008 | 98119 |
| 2423 2ns Ave W, Seattle, WA 98119 | 1,575,000 | 4 | 3.1 | 2,650 | 3,484 | 2007 | 98119 |
| 2575 5th Ave W, Seattle, WA 98119 | 885,000 | 3 | 2 | 2,820 | 3,280 | 1916 | 98119 |
| 2113 3rd Ave W, Seattle, WA 98119 | 899,000 | 3 | 1.75 | 1,387 | 3,600 | 1907 | 98119 |
| MEAN | 731,387 | 2.933333333 | 2.13 | 1,800 | 3,321 | 1936.733333 |
| MEDIAN | 589,000 | 3 | 2 | 1,610 | 3,484 | 1925 |
| MIN | 525,000 | 2 | 1 | 770 | 1,742 | 1900 |
| MAX | 1,575,000 | 4 | 3.25 | 2,860 | 5,543 | 2008 |
| STDEV | 273152.6074 | 0.7988086367 | 0.7296770323 | 647.6578535 | 932.5954464 | 38.94770609 |
| Addresss | Price | Bedrooms | Bathrooms | House ft2 | Lot ft2 | Year Built | Zip Code |
| 4200 Washington Ave | $3,750,000 | 6 | 5 | 6656 | 35283 | 1909 | 98199 | Nicolette
Voskericyan
MAGNOLIA |
| 4317 32nd Ave | $1,187,000 | 4 | 3.5 | 3470 | 4800 | 2006 | 98199 |
| 3231 24th Ave W | $1,020,000 | 4 | 4 | 2590 | 3360 | 1991 | 98199 |
| 3514 W Dravus | $701,500 | 3 | 1.75 | 1770 | 4308 | 1963 | 98199 |
| 2612 30th Ave W | $1,300,000 | 4 | 3 | 2850 | 6800 | 1937 | 98199 |
| 2107 Thordyke Ave W | $595,000 | 3 | 1 | 1390 | 4000 | 1918 | 98199 |
| 5656 42nd Ave W | $1,475,000 | 4 | 4 | 2530 | 4650 | 1973 | 98199 |
| 2553 35th Ave W | $795,000 | 4 | 2 | 2427 | 5000 | 1937 | 98199 |
| 2901 25th Ave W | $1,000,000 | 3 | 1.1 | 3230 | 6534 | 1957 | 98199 |
| 3820 36th Ave W | $705,300 | 3 | 2 | 1960 | 6000 | 1908 | 98199 |
| 3410 W Barrett St | $935,000 | 3 | 3 | 4250 | 6000 | 1910 | 98199 |
| 2001 35th Ave W | $761,100 | 3 | 2 | 2700 | 5662 | 1950 | 98199 |
| 2627 W Lynn St | $759,950 | 3 | 2 | 1970 | 3920 | 1926 | 98199 |
| 4205 34th Ave W | $725,000 | 1 | 1 | 500 | 5332 | 1953 | 98199 |
| 1408 Magnolia Blvd W | $1,130,000 | 4 | 2 | 3130 | 4950 | 1933 | 98199 |
| Mean | $1,122,657 | 3.466666667 | 2.49 | 2761.533333 | 7106.6 | 1944.733333 |
| Median | $935,000 | 3 | 2 | 2590 | 5000 | 1937 |
| Min | $595,000 | 1 | 1 | 500 | 3360 | 1908 |
| Max | $3,750,000 | 6 | 5 | 6656 | 35283 | 2006 |
| Stdev | 769102.9879 | 1.060098827 | 1.210696376 | 1406.461358 | 7856.458324 | 29.79565325 |
| Address | Price | Bedrooms | Bathrooms | House ft2 | Lot ft2 | Year Built | Zip Code |
| 1706 N 50th St, Seattle,WA,98103 | $833,444 | 2 | 1 | 1100 | 4356 | 1908 | 98103 |
| 1011 N 50th St APT A, Seattle, WA,98103 | $759,735 | 2 | 2.25 | 1400 | 1132 | 2007 | 98103 |
| 1208 N 46th St, Seattle, WA, 98103 | $838,938 | 3 | 2 | 1710 | 5000 | 1925 | 98103 |
| 4418 Corliss Ave N APT D,Seattle, WA,98103 | $711,075 | 2 | 2.25 | 1074 | 1001 | 1998 | 98103 |
| 719 N 48th St, Seattle, WA, 98103 | $878,558 | 4 | 2 | 1880 | 4000 | 1909 | 98103 |
| 2303 N 59th St, Seattle, WA,98103 | $890,827 | 3 | 1 | 1710 | 4520 | 1923 | 98103 |
| 5762 E Green Lake Way N,Seattle, WA,98103 | $1,240,883 | 3 | 2 | 2500 | 6534 | 1917 | 98103 | Mingxi Li (Vivian) |
| 6221 Greenwood Ave N,Seattle,WA,98103 | $942,242 | 4 | 2 | 3180 | 4791 | 1922 | 98103 | |
| 311 N 42nd St, Seattle,WA,98103 | $542,040 | 2 | 1 | 530 | 1698 | 1946 | 98103 | |
| 3965 Fremont Ave N,Seattle, WA,98103 | $678,375 | 2 | 1 | 1500 | 3920 | 1900 | 98103 | |
| 808 N 49th St, Seattle, WA,98103 | $795,348 | 3 | 4 | 1560 | 1306 | 2008 | 98103 | |
| 3735 Eastern Ave N, Seattle, WA,98103 | $1,205,072 | 3 | 2 | 2100 | 4160 | 1925 | 98103 | |
| 800 N Motor PI, Seattle, WA, 98103 | $968,374 | 3 | 2.5 | 2170 | 3750 | 1925 | 98103 |
| 607 N 63rd St, Seattle, WA,98103 | $850,881 | 2 | 2 | 1800 | 5000 | 1916 | 98103 |
| 939 N 89th St, Seattle,WA,98103 | $1,254,640 | 4 | 2.5 | 3200 | 5227 | 2016 | 98103 |
| Mean | $892,695 | 2.8 | 1.966666667 | 1827.6 | 3759.666667 | 1943 |
| Median | $850,881 | 3 | 2 | 1710 | 4160 | 1925 |
| Min | $542,040 | 2 | 1 | 530 | 1001 | 1900 |
| Max | $1,254,640 | 4 | 4 | 3200 | 6534 | 2016 |
| Stdev | 206222.0612 | 0.7745966692 | 0.7841434514 | 733.3898593 | 1689.333455 | 41.51763825 |
| | Price | Bedrooms | Bathrooms | House ft^2 | Lot ft^2 | Year Built | Zip Code |
| 98107 | 920,000 | 3 | 3 | 2,300 | 7,405 | 1998 | 98107 |
| | 495,000 | 2 | 2 | 1,240 | 2,625 | 1983 | 98107 |
| | 726,000 | 3 | 2 | 1,310 | 10,018 | 1967 | 98107 |
| | 400,000 | 3 | 1.5 | 1,470 | 7,590 | 1959 | 98107 | Emad (soth ballard) |
| | 1,030,000 | 4 | 3 | 4,060 | 7,405 | 2002 | 98107 |
| | 795,000 | 4 | 3 | 2,810 | 9,191 | 1975 | 98107 |
| | 970,000 | 4 | 3.25 | 3,127 | 3,998 | 2014 | 98107 |
| | 685,000 | 4 | 2 | 2,440 | 12,632 | 1961 | 98107 |
| | 760,000 | 4 | 2.5 | 2,780 | 13,503 | 1990 | 98107 |
| | 1,399,990 | 5 | 4 | 4,140 | 8,276 | 2016 | 98107 |
| | 480,000 | 3 | 3 | 1,590 | 7,350 | 1968 | 98107 |
| | 569,500 | 3 | 1.75 | 1,670 | 8,842 | 1975 | 98107 |
| | 520,000 | 3 | 1.5 | 1,820 | 9,200 | 1978 | 98107 |
| | 379,950 | 3 | 2 | 1,080 | 5,079 | 1985 | 98107 |
| | 933,000 | 4 | 2.75 | 2,520 | 18,731 | 1988 | 98107 |
| Mean | 737,563 | 3.466666667 | 2.483333333 | 2,290 | 8,790 | 1983.933333 |
| Median | 726,000 | 3 | 2.5 | 2,300 | 8,276 | 1983 |
| Min | 379,950 | 2 | 1.5 | 1,080 | 2,625 | 1959 |
| Max | 1,399,990 | 5 | 4 | 4,140 | 18,731 | 2016 |
| Stdev | 280194.3131 | 0.743223353 | 0.7286647933 | 968.676038 | 3964.058682 | 17.71789518 |
helpmeout11
20171019074853case_study_1_3.xlsx
