Due to the increasing property prices in the Seattle Area and the bear market in tech stocks and cryptocurrencies, Leo is looking to sell his property, transfer the funds into more volatile assets, and take advantage of the discounted prices. While realtors are convenient, they take 3% of the profit, which is significant when considering the potential value of the property. Thus, Leo is deciding to perform the market research himself and conduct the sale privately.

Please use the data fromHousing Prices to elaborate a regression model with a 5% level of significance and propose a listing price. You are free to make assumptions as necessary, but please make note of it in the report. There is no need to separate the data into training and testing data, please use all of it (barring outliers, etc) in your regression analysis.

Your report should have the following sections: Executive Summary or Introduction, Methods, Regression Analysis, Discussion, Conclusion

• (6) Regression Analysis
  • (1) Performing regression analyses and eliminating irrelevant factors
  • (1) Performing regression analyses and incorporating relevant factors
  • (2) Generating a multivariate regression formula for housing price
  • (2) Pricing the property in question

Property Information:

Zip Code: 98078 (47.5601, -122.2139)

Age: 51 years, unrenovated

Rooms: 3 bedrooms, 1.5 bathroom, 2 floors

Size (square feet): 5300 Living, 15420 Lot, 3800 Above Ground, 1500 Basement

Ratings: View (2), Grade (9), Condition (4), No waterfront (0)

Days on Market: 0 (so far)

Price: ????

F P Q R S A B C D E G H K M N O Listing Listing Price Bedroom |Bathroom Floor |Waterfro Vie Condition Grad Livin Lot (sqf Abov Baseme |Yea Year Zip Cod |Latitudengitud 7.136+09 ######## $221,900 1 1180 5650 1180 0 1955 0 98178 47.5112 -122.257 6.41E+09 12-9-2021 $538,000 2.25 7 2570 7242 2170 400 1951 1991 98125 47.721 -122.319 5.63E+09 2-25-2022 $180,000 770 10000 770 0 1933 98028 47.7379 -122.233 2.49E+09 12-9-2021 $604,000 1960 5000 1050 910 1965 98136 47.5208 -122.393 1.95E+09 2-18-2022 $510,000 1680 8080 1680 0 1987 98074 47.6168 -122.045 7.24E+09 5-12-2021 ####### 4.5 5420 101930 3890 1530 2001 98053 47.6561 -122.005 1.32E+09 6-27-2021 $257,500 2.25 1715 6819 1715 0 1995 98003 47.3097 -122.327 9 2.01E+09 1-15-2022 $291,850 1060 9711 1060 0 1963 98198 47.4095 -122.315 98146 47.5123 -122.337 10 2.41E+09 4-15 1780 7470 1050 730 1960 11 3.79E+09 3-12-2022 $323,000 1890 6560 1890 0 2003 98038 47.3684 -122.031 1.74E+09 4-3-2022 $662,500 3560 9796 1860 1700 1965 98007 47.6007 -122.145 12 9.21E+09 5-27-2021 $468,000 1160 6000 860 300 1942 98115 47.69 -122.292 13 14 1.14E+08 5-28-2021 $310,000 1430 19901 1430 0 1927 98028 47.7558 -122.229 6.05E+09 10-7-2021 $400,000 .37 9680 1370 0 1977 98074 47.6127 122.045 15 U H H H N W N U H H J V H in 98107 47.67 -122.394 16 1.18E+09 3-12-2022 $530,000 .810 4850 1810 1900 9.3E+09 1-24-2022 $650,000 2950 5000 1980 970 1979 98126 47.5714 -122.375 17 1.88E+09 7-31-2021 $395,000 1890 14040 1890 0 1994 98019 47.7277 -121.962 18 19 6.87E+09 5-29-2021 $485,000 .600 4300 1600 1916 98103 47.6648 122.343 20 16000397 12-5-2021 $189,000 1200 9850 1200 o 1921 98002 47.3089 -122.21 o o o o o o o o o o o o o o o o o o o o o o o o o o ooo ooo 7.98E+09 4-24-2022 $230,000 250 3774 1250 0 1969 98003 47.3343 122.306 21 22 6.3E+09 5-14-2021 $385,000 .620 4980 860 60 1947 98133 47.7025 -122.341 2.52E+09 8-26-2021 ####### 2330 720 196 47.5316 23 3050 44867 98040 -122.233 24 7.14E+09 7-3-2021 $285,00 2270 5300 2270 0 1995 98092 47.3266 -122.169 25 8.09E+09 5-16-2021 $252,700 1070 3643 1070 0 1985 98030 47.3533 -122.166 3.81E+09 ######## $329,000 450 6500 2450 0 1985 98030 47.3739 -122.172 26 27 1.2E+09 11-3-2021 $233,000 710 4697 1710 o 1941 98002 47.3048 122.218 1.79E+09 6-26-2021 $937,000 2450 2691 1750 700 1915 98119 47.6386 -122.36 28 WAD WUD DW WA W WW WW N D H W W A D W W W W U W U A W W W A D D D W WW ADD WW WWWWWWWW o o o o N o o o o o o o o o o o o o o o o o o o O o o 0 0 0 0 0 A O O O O O W O O O O O O O 0 0 0 0 0 0 0 0 o o o O H o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o O O O O O O N W UW WW A W W W W U D D D D D D W A W D N W A W W W W W N U W A W N A W A U W W N W W W W W A W A N W W 3.3E+09 12-1-2021 $667,000 1400 1581 1400 0 1909 98112 47.6221 -122.314 29 30 5. 1E+09 6-24-2021 $438,000 1.75 1520 5380 790 730 1948 98115 47.695 -122.304 31 1.87E+09 3-2-2022 $719,000 2570 7173 2570 0 2005 98052 47.7073 -122.11 32 8.56E+09 ######## $580,500 2320 3980 2320 2003 98027 47.5391 -122.07 2.43E+09 12-1-2021 $280,000 1190 1265 1190 0 98133 47.7274 -122.357 33 2005 34 4.61E+08 6-24-2021 $687,500 1.75 2330 5000 1510 320 1929 98117 47.6823 -122.368 35 7.59E+09 ######## $535,000 1090 3000 1090 0 1929 98117 47.6889 122.375 36 7.96E+09 12-3-2021 $322,500 2.75 2060 5659 1280 780 1981 98058 47.4276 122.157 37 9.55E+09 6-13-2021 $696,000 2300 3060 1510 790 1930 002 98115 47.6827 -122.31 38 9.44E+09 5-28-2021 $550,000 1660 3484 930 1933 98052 47.6621 -122.132 2.77E+09 ######## $640,000 1904 47.6702 -122.362 39 2360 6000 2360 98107 40 7.9E+09 2-13-2022 $240,000 .220 8075 890 330 1969 98001 47.3341 122.282 41 2.08E+09 6-20-2021 $605,000 2620 7553 2620 0 1996 98056 47.5301 -122.18 42 5.55E+09 7-15-2021 $625,000 2570 5520 2570 o 2000 98074 47.6145 -122.027 43 7.77E+09 8-11-2021 $775,000 2.25 220 24186 2600 1620 1984 98166 47.445 -122.347 7.2E+09 7-7-2021 $861,990 .75 3595 5639 3595 0 2014 98053 47.6848 -122.016 44 45 9.27E+09 ######## $685,000 570 2280 1570 0 1922 98119 47.6413 -122.364 920 360 98058 47.4485 -122.175 46 1.43E+09 7-29-2021 $309,000 1280 9656 1959 o o o o o o o o o ooo ooo OOO 47 8.04E+09 7-18-2021 $488,000 2.5 3160 13603 3160 0 2003 98019 47.7443 -121.977 48 8.95E+09 3-25-2022 $210,490 990 8528 990 0 1966 98023 47.3066 122.371 49 4.18E+09 7-16-2021 $785,000 2.5 2290 13416 2290 1981 98007 47.6194 -122.151 50 9.22E+09 4-28-2022 $450,000 .75 250 5963 1250 1953 98115 47.6796 -122.301 51 8.22E+08 3-11-2022 ####### 2753 65005 2165 588 1953 98070 47.4041 -122.451 52 5.25E+09 9-16-2021 $228,000 1190 9199 1190 1955 98148 47.4258 122.322 53 7.23E+09 2-17-2022 $345,000 3150 9134 1640 1510 1966 98056 47.4934 122.189 54 7.526+09 ######## $600,000 1410 4080 1000 410 1950 98117 47.6808 122.384 55 3.63E+09 2-5-2022 $585,000 75 7 1980 3550 990 990 1981 98117 47.6989 122.369