data Analysis project

zachzhang
data.xlsx

Sheet1

Zip Code Selling Price Bedrooms Bathrooms Home Square Feet Lot Square Feet Year Built Address Age
98006 995,000 3 3 2780 8215 1993 15739 SE 44th Pl, Bellevue, WA 28
98006 2,289,950 6 4 3321 6773 2021 5848 110th Ave SE, Bellevue, WA 0
98006 4,200,000 5 6 9682 35,283 2021 6999 SE Cougar Mountain Way, Bellevue, WA 0
98006 519,990 3 2.5 1387 1387 1970 12605 SE 42nd St #605, Bellevue, WA 51
98006 418,000 2 1 898 898 1984 4106 Factoria Blvd SE APT 301, Bellevue, WA 37
98006 5,188,000 3 3 3040 25,700 1961 99 Cascade Key, Bellevue, WA 60
98006 3,298,000 5 5 4331 9148 2021 14020 SE 38th St, Bellevue, WA 0
98006 3,150,000 5 5 4039 9147 2021 3961 154th Ave SE, Bellevue, WA 0
98006 3,120,000 6 5 4396 10890 2018 15755 Se 45th Pl, Bellevue, WA 3
98006 2,750,000 5 4 3230 8712 1974 4416 139th Ave SE, Bellevue, WA 47
98006 2,625,000 5 4 3760 7405 2021 4012 148th Pl SE, Bellevue, WA 0
98006 2,498,000 5 4 5330 39,204 1985 17104 Se 60th St, Bellevue, WA 36
98006 2,349,000 4 3 4060 15,682 1994 16868 Se 57th Pl, Bellevue, WA 27
98006 2,299,950 6 4 3321 6969 2021 5876 110th Ave SE, Bellevue, WA 0
98006 1,980,000 5 4 3190 15,246 1976 4738 Somerset Dr SE, Bellevue, WA 45 Mean Median Std. dev. Min Max
98040 $1,425,000 4 3 2,700 9,000 1975 8421 SE 33rd Pl, Mercer Island, WA 46 Asking Price 3,660,438 2,998,389 2492621.98 418,000 12,888,000
98040 $1,175,000 3 1.5 1,600 10,019 1950 4005 85th Ave SE, Mercer Island, WA 71 Age as of 2021 33.1166666667 38.5 25.81 0 71
98040 $1,495,000 4 3 2,730 17,424 1976 9260 SE 46th ST, Mercer Island, WA 45 Home Square Footage 3850.6833333333 3845 1715.51 898 9682
98040 $1,950,000 7 5 4,500 21,344 1970 7545 E Mercer Way, Mercer Island, WA 51 Lot Square Footage 16188.4333333333 13068 10572.12 898 52460
98040 $1,475,000 5 2 2,700 11,326 1953 3632 90th Ave SE, Mercer Island, WA 68 Number of Bedrooms 4.4333333333 4 1.1404231547 2 8
98040 $7,680,000 4 4 5,457 25,700 2001 6430 E Mercer Way, Mercer Island, WA 20 Number of Bathrooms 3.75 4 1.485808574 1 8
98040 $1,500,000 4 2 1,800 9,525 1965 4544 88th Ave SE, Mercer Island, WA 56
98040 $1,595,000 4 2 1,920 11,326 1957 9734 SE 41st ST, Mercer Island, WA 64
98040 $1,780,000 5 3 3,040 9,601 1968 522 90th Ave SE, Mercer Island, WA 53
98040 $5,485,000 5 4.5 6,005 16,117 2021 9818 SE 42nd PL, Mercer Island, WA 0
98040 $1,985,000 3 2.5 2,350 18,731 1981 7923 E Mercer Way, Mercer Island, WA 40
98040 $2,995,000 3 2.5 4,340 13,068 2006 2241 74th Ave SE, Mercer Island, WA 15
98040 $2,599,800 4 4 3,880 15,246 1990 3625 W Mercer Way, Mercer Island, WA 31
98040 $3,895,000 5 4 5,140 26,136 2021 8720 SE 52nd PL, Mercer Island, WA 0
98040 $3,595,000 5 4 4,946 12,197 1972 9432 SE 52nd ST, Mercer Island, WA 49
98039 $2,980,000 3 2 2,040 14,375 1,952 2539 82nd Ave NE, Medina, WA 69
98039 $4,400,000 5 4 5,110 18,730 1,950 1034 Evergreen Point RD, Medina, WA 71
98039 $2,997,777 3 2 1,600 16,117 1962 2436 82nd Ave NE, Medina, WA 59
98039 $9,250,000 6 7 7,300 20,038 2021 7823 NE 14th St, Medina, WA 0
98039 $10,988,000 4 2.5 2,400 48,787 1969 3217 Evergreen Point RD, Medina, WA 52
98039 $5,100,000 5 4 4,300 16,117 1994 8618 NE 6th St, Medina, WA 27
98039 $5,753,000 5 5 5,159 8,120 2021 2627 78th Ave NE, Medina, WA 0
98039 $5,200,000 3 2 2,760 13,068 1954 8637 NE 6th St, Medina, WA 67
98039 $5,250,000 5 5 4,937 13,068 2021 2519 82nd Ave NE, Medina, WA 0
98039 $12,888,000 6 7 8,350 36,155 2020 7545 NE 28th PL, Medina, WA 1
98039 $3,250,000 4 3 2,817 13,504 1962 8050 NE 27th St, Medina, WA 59
98039 $2,999,000 4 4 3,500 52,460 1974 1270 80th Pl NE, Medina, WA 47
98039 $6,450,000 4 5 4,470 14,810 1998 8414 Overlake Dr W, Medina, WA 23
98039 $2,780,000 3 3 2,140 10,206 1991 7622 NE 14th ST, Medina, WA 30
98039 $5,398,000 4 6 4,805 10,890 2021 2604 79th Ave NE, Medina, WA 0
98004 1,790,000 4 3 2250 9034 1959 248 111th Ave SE, Bellevue, WA 62
98004 4,495,000 6 6 4690 11356 2021 2416 108th Ave SE, Bellevue, WA 0
98004 3,189,000 3 3 1869 11356 1956 9080 NE 17th St, Clyde Hill, WA 65
98004 4,195,000 4 3 4169 21344 1968 8832 NE 25th Pl, Clyde Hill, WA 53
98004 10,800,000 5 8 7360 15246 2021 9243 NE 20th St, Clyde Hill, WA 0
98004 2,698,000 6 6 5407 8240 2018 112 111th Ave SE, Bellevue, WA 3
98004 1,800,000 4 3.5 2660 8113 1951 3245 110th Ave SE, Bellevue, WA 70
98004 1,350,000 3 2 2303 43560 1980 1806 101st Pl NE Unit H3, Bellevue, WA 41
98004 2,900,000 4 1.5 4100 23522 1961 8628 NE 23rd Pl, Clyde Hill, WA 60
98004 2,250,000 4 2 1810 10890 1958 9804 NE 22nd St, Bellevue 63
98004 3,688,000 4 3.5 3810 8681 1992 1617 108th Ave NE, Bellevue, WA 29
98004 4,200,000 5 3.5 5476 20038 1972 9118 NE 13th St, Clyde Hill, WA 49
98004 3,980,000 8 4 4369 20909 1978 8515 NE 25th St, Clyde Hill, WA 43
98004 4,598,000 5 4.5 4995 15682 2021 2210 108th Ave SE, Bellevue, WA 0
98004 3,698,800 4 5.5 4212 9471 2020 10642 SE 22nd St, Bellevue, WA 1