Hi This is a long shot in the dark, but I am clearly struggling I attached what I have been working on Literally any help is appreciated You are asked to find the best fit model to predict the price of a property in Chicago You are considering the following regression models Model1 use square feet as the independent variable Model2 use square feet and beds as the independent variables Model3 use property type, square feet, and beds as the independent variables Answer the following a What is the RSquare for Model 1 b The RSquare Adj for Model1 is what c Model 1 predicts the price for a property of 3,000 sq ft to be what d What is The RSquare for Model 2 e The RSquare Adj for Model2 is what f Model 2 predicts the price for a property of 3,000 sq ft with 3 bedrooms to be what g What is the RSquare for Model 3 h What is the RSquare Adj for Model 3 i Model3 predicts the price for a single family residential property of 3,000 sq ft with 3 bedrooms to be what j Model3 is the best fit model (T F) 73 450000 Single Family 777 2326 2 1887 C A 74 284900 Single Family 1138 3702 1958 75 59000 Single Family 1500 3123 4 2 1905 76 550000 Multi Family (5 7863 7863 15 6 1927 77 515000 Townhouse 1482 320 2 1987 78 75000 Single Family 1902 2979 3 1 1962 79 1650 Single Family 4300 3125 4 5 2018 80 523900 Single Family 1852 8642 2 1938 81 475000 Single Family 1751 4090 1 5 1942 Columns (7 0) 82 150000 Single Family 3660 6198 A 2 1908 Q 83 419000 Single Family 2600 3720 3 1984 PRICE 84 145000 Single Family 809 4373 1941 PROPERTY TYPE 85 679000 Single Family 3600 3654 3 5 1916 SQUARE FEET 86 309000 Single Family 1238 4782 W W A 2 5 1943 LOT SIZE 87 719000 Single Family 2200 2975 3 1992 BEDS 3750 4 3 1951 BATHS 88 447500 Single Family 1480 YEAR BUILT 89 109000 Single Family 2200 4913 2 1946 90 359000 Single Family 1418 5623 3 1942 91 434900 Single Family 2144 9539 2 5 1931 92 289900 Single Family 1458 4887 2 1959 On A 93 418000 Single Family 2826 7679 3 1946 94 459000 Single Family 2300 2156 4 3 5 2005 95 1050 Condo Co op 2100 9432 2 2018 96 869900 Multi Family (5 5841 4356 12 6 1885 97 414900 Single Family 1758 4382 4 3 1950 98 659900 Single Family 3600 8000 3 1951 99 41000 Single Family 736 3750 T A 1913 100 339900 Single Family 2274 10049 A 2 5 1953 101 49900 Single Family 800 3001 3 1920 102 45000 Single Family 1300 2474 2 1900 103 217500 Single Family 1892 5431 3 2 5 1910 Rows 104 189900 Single Family 2100 3689 3 3 1948 All rows 500 105 1075 Single Family 3300 3750 3 5 1899 Selected O Excluded 106 335000 Single Family 1489 4961 1 5 1944 Hidden 107 512000 Townhouse 2372 2184 4 2 5 1963 Labeled 108 239000 Single Family 2200 4251 4 2 19453 real estate v6 (1) mp EIIM EV Distribution Fit Y by X Fit Model Window Tools Recode g PROPERTY SQUARE LOT YEAR Note Real estate data E PRICE TYPE FEEI' SIZE BEDS BATHS BUILT 1 330000 Single Family 1971 5187 4 2 5 1929 2 479900 Single Family 2850 5079 4 3 5 1924 3 439000 Single Family 1400 10153 3 3 1922 4 500000 Single Family 1500 2905 3 2 1998 5 315000 Single Family 1324 3720 3 1 5 1951 5 224900 Single Family 2550 4822 4 3 1920 7 239900 Single Family 2840 4438 5 2 1910 8 439000 Townhouse 2500 3000 3 3 2000 9 579000 Condo Co op 2650 8512 3 2 5 2017 10 59900 Single Family 1328 4338 4 2 1922 q 11 599900 Single Family 4428 8498 4 3 2007 A PRICE 12 120000 Multi Family (5 7005 3049 15 5 1894 I PROPEFlTYTYPE 13 295000 Single Family 1311 3689 3 1 5 1945 A SQUARE FEEF 14 157000 Single Family 1250 4215 3 1 1913 1 323 25 15 489900 Townhouse 1850 535 3 2 5 1997 A BATHS 15 285900 Single Family 2150 4921 5 2 1955 'YEAR BUILT 17 159900 Single Family 958 4154 3 1 5 1944 18 135000 Single Family 1558 5000 4 2 1949 19 415000 Single Family 2268 3720 4 3 2000 20 15000 Single Family 1964 5998 4 2 1885 21 349000 Single Family 1452 4725 3 1 1899 22 479000 Single Family 2599 5248 4 3 5 1994 23 339997 Single Family 2371 3750 4 2 5 1951 24 500000 Single Family 1555 3149 5 3 1892 25 2499 Single Family 3395 1375 4 4 5 1883 25 174900 Single Family 1015 3575 2 1 5 1947 27 259900 Single Family 1300 5318 3 1 5 1948 28 179900 Single Family 900 3123 2 1 1954 29 399000 Single Family 2070 3937 5 2 1928 30 124999 Single Family 1430 3375 5 2 1910 31 419900 Single Family 3750 3750 5 3 1952 32 525000 Condo Co op 2000 3125 2 3 2000 32$ 0 33 325000 Single Family 2450 3524 5 3 1955 Excluded 0 34 499900 Single Family 2545 4125 4 1 5 1920 Hidden 0 35 255000 Condo Co op 853 853 1 1 2008 Labeled 0 35 349900 Single Family 1277 3750 5 2 5 2008 37 339900 Single Family 1850 5000 4 2 1939 38 149900 Single Family 1181 4613 A 1 5 1961 39 549900 Single Family 2600 4303 6 3 5 1906 40 439900 Single Family 2026 1961 3 2 5 1936 41 619000 Single Family 2778 6599 3 2 5 1931 42 595000 Single Family 3000 2949 4 2 5 2007 43 286900 Single Family 2046 3088 3 1947 44 184900 Single Family 1584 3750 2 1915 45 229000 Single Family 980 4573 2 1 5 1947 Columns (7 0) 46 165200 Single Family 1169 3624 1920 Q 47 1375 Single Family 3444 2400 4 5 1998 PRICE 48 259000 Single Family 1959 3720 3 2 1923 PROPERTY TYPE 49 25000 Single Family 1250 3123 5 1 5 1910 SQUARE FEET 50 374900 Single Family 2200 3750 5 2 1927 LOT SIZE 51 799000 Single Family 2000 1925 4 2 1888 BEDS 52 249500 Single Family 3800 3750 5 3 1914 BATHS YEAR BUILT 53 549900 Single Family 2500 5039 4 1924 54 200000 Single Family 1260 3125 2 1925 55 46200 Single Family 1249 5000 3 1 5 1947 56 275000 Single Family 1350 2252 4 2 1959 57 273900 Single Family 1150 3632 5 2 1965 58 259000 Single Family 4000 4024 5 3 1920 59 820000 Condo Co op 1979 10190 2 2018 60 4995 Single Family 7000 8646 6 5 5 2003 61 40000 Single Family 1081 3075 3 1 1895 62 775000 Townhouse 1775 735 3 2 5 1969 63 550000 Single Family 2650 2648 2 5 1891 64 289900 Single Family 1750 3720 4 3 1922 65 225000 Single Family 1045 4373 2 1951 66 329000 Single Family 2080 4159 3 1 1914 67 149900 Townhouse 1435 1435 2 2008 Rows 68 94500 Townhouse 1352 4440 3 1 1945 All rows 500 69 719000 Single Family 2800 3123 4 3 5 1905 Selected O Excluded 70 229000 Single Family 2250 3123 A 2 1916 Hidden 71 274000 Single Family 1200 3149 6 2 1965 Labeled 72 1550 Single Family 4191 3101 3 5 2011109 112500 Single Family 931 3249 1 5 1942 110 64900 Single Family 1212 3728 1908 111 500000 Single Family 2000 8772 A 1 5 1896 112 21900 Single Family 1849 4647 4 2 1885 113 395000 Single Family 2080 6751 3 3 1926 114 559900 Single Family 3098 7501 6 4 1910 115 2495 Single Family 5000 4944 4 1875 116 377900 Single Family 1725 5623 4 2 1950 117 165000 Single Family 1235 4373 1 5 1968 Columns (7 0) 118 497500 Townhouse 2000 2000 NWA 2 1999 Q 119 259000 Townhouse 966 3300 1947 PRICE 120 850000 Single Family 1558 3484 3 1896 PROPERTY TYPE 121 309000 Single Family 1210 4499 3 2 1922 SQUARE FEET 122 1299 Single Family 5000 6250 4 1905 W O LOT SIZE 123 27137 Single Family 1380 3937 1 5 1895 BEDS 124 799900 Single Family 4965 10079 5 5 5 2002 BATHS YEAR BUILT 125 110000 Single Family 956 3101 1 1880 UI N 126 299900 Single Family 1700 3750 3 1937 127 299900 Single Family 1600 4464 3 2 1945 128 349000 Condo Co op 1600 4875 3 3 2006 129 119900 Single Family 1000 3101 A 1969 130 234900 Single Family 1027 5357 3 1 1952 131 330000 Single Family 1530 4321 1 5 1960 132 123500 Single Family 1684 3049 2 1888 133 350000 Single Family 1648 1524 3 1 1885 134 259400 Single Family 2200 5144 3 1914 135 89900 Single Family 298 3689 6 3 1919 136 149900 Single Family 1400 3149 4 2 1895 137 279000 Single Family 2280 4687 5 3 1913 138 135000 Single Family 891 5806 3 1946 A UT 139 177000 Single Family 1600 4159 2 1957 Rows 140 169999 Single Family 1396 3125 A 1 5 1924 All rows 500 1323 5000 Selected 141 339900 Single Family 5 2 1919 O 3101 Co 1928 Excluded 142 459900 Single Family 2800 UI A Hidden 143 1695 Single Family 5200 3079 4 5 1994 Labeled 144 209900 Single Family 1272 3781 Co 2 1956146 375400 Single Family 1212 3750 5 3 1922 147 2999 Single Family 5850 1755 5 5 5 1909 148 479900 Single Family 2430 3746 5 3 5 1953 149 650000 Single Family 2000 2674 3 2 5 1875 150 230000 Single Family 2702 4303 4 2 1954 151 182900 Single Family 1100 4094 2 1 5 1949 152 475000 Single Family 2000 3014 2 5 1901 153 214900 Single Family 1135 7339 4 2 1955 154 92500 Single Family 1524 3123 5 1 5 1905 Columns (7 0) 155 614900 Single Family 2498 5884 4 2 5 1969 Q 156 195000 Single Family 1600 4268 3 2 1937 PRICE 157 349000 Single Family 2850 2748 2 2 5 1875 PROPERTY TYPE 158 139000 Townhouse 1093 4000 3 1 5 1952 SQUARE FEET 159 599900 Single Family 2970 3036 4 3 5 2018 LOT SIZE 160 1489 Single Family 5100 3720 3 5 1914 BEDS 2265 8001 4 1925 BATHS 161 474900 Single Family 1 5 YEAR BUILT 162 874900 Single Family 3124 3750 4 5 1911 163 345900 Single Family 1300 4800 5 2 1955 164 72500 Single Family 1320 3720 3 2 1919 165 2400 Single Family 5600 4112 4 5 2008 166 324900 Condo Co op 1200 6250 2 2009 167 375000 Single Family 1144 2700 4 2 5 1914 168 449000 Single Family 1576 3781 3 2 1924 169 85000 Single Family 1100 3125 3 2 1912 170 49900 Single Family 1400 3123 2 1 1921 171 76900 Single Family 1150 4090 1 1912 UI N 172 1500 Single Family 5000 2600 4 5 2009 173 620000 Single Family 3600 4229 A 3 5 2018 174 650000 Single Family 1600 2265 2 5 1994 175 139000 Single Family 1320 4373 2 5 1880 176 299900 Single Family 1060 3125 A 2 1959 Rows 177 169900 Single Family 1500 3149 2 5 1912 All rows 500 178 225000 Condo Co op 1000 10650 W N W 2 1920 Selected O 179 259900 Single Family IN Excluded 790 3750 1912 Hidden 180 174873 Single Family 1449 6250 2 1905 Labeled 181 1675 Single Family 3600 2400 A 1886182 229900 Single Family 1564 3149 5 2 5 1905 183 139995 Single Family 1310 4913 A 1 5 1900 184 14900 Single Family 903 3123 1 1918 NN 185 665000 Condo Co op 1250 3125 2 2015 186 1399 Single Family 6500 21122 4 4 5 1999 187 90000 Single Family 4032 7501 5 3 1901 188 499000 Condo Co op 2400 6250 3 3 2001 189 359000 Single Family 2478 5863 5 2 1927 190 779000 Single Family 2500 8576 4 4 1966 Columns (7 0) 191 499900 Single Family 1352 3123 3 1901 Q 192 309900 Single Family 1402 5187 1 5 1945 PRICE 193 545000 Single Family 1891 2444 A 3 5 2016 PROPERTY TYPE 194 1295 Single Family 3800 4125 A 3 5 2014 SQUARE FEET 195 272000 Single Family 1100 5052 2 1938 LOT SIZE 196 25000 Single Family 1500 3750 1 1907 BEDS BATHS 197 264900 Single Family 1735 3541 3 1939 YEAR BUILT 198 364500 Single Family 1000 3750 O W A 2 1955 199 2399 Single Family 6700 4530 5 5 2005 200 3099 Single Family 5826 3001 6 4 5 2011 201 76385 Single Family 1387 2613 A 2 1890 202 130000 Single Family 1510 3680 3 2 1917 203 350000 Single Family 1677 3049 4 2 1895 204 298700 Single Family 1364 6050 2 5 1949 205 239000 Single Family 1015 4159 A 3 1924 206 139900 Single Family 1026 3123 1 1922 207 35000 Single Family 1920 6250 A 2 1889 208 70000 Single Family 1344 4613 A 1 5 1914 209 231000 Single Family 1050 4752 1 1952 210 489900 Single Family 2506 3968 5 3 1945 211 435000 Condo Co op 1258 3125 2 2 2008 212 113500 Single Family 1430 3685 4 1 1895 Rows 213 499000 Single Family 2987 4687 8 3 1950 All rows 500 214 306900 Single Family 2000 3149 A 3 1924 Selected O Excluded 215 800000 Single Family 3122 10659 A 3 5 1947 Hidden 216 175000 Single Family 1600 3750 A 2 1920 Labeled 217 849900 Condo Co op 3100 4575 3 2 5 2000218 1175 Single Family 3200 2861 3 5 1886 A 219 649000 Single Family 5549 5296 6 4 5 1890 220 228000 Single Family 1100 3750 3 1 1954 221 230000 Single Family 1482 6015 A 3 1920 222 209900 Single Family 1699 4499 A 2 5 1952 223 23000 Single Family 1492 3275 4 2 1885 224 139900 Single Family 726 5079 1 1966 225 1650 Single Family 3739 2500 4 4 5 1994 226 359900 Single Family 2000 3811 5 2 1954 Columns (7 0) 227 258900 Single Family 1969 6650 1 5 1966 Q 228 2550 Single Family 5369 4199 4 5 2002 PRICE 229 349900 Townhouse 1606 2376 3 3 2007 PROPERTY TYPE 230 20000 Single Family 1256 3101 4 1 5 1885 SQUARE FEET 231 379900 Single Family 2400 6200 3 1949 LOT SIZE 232 335000 Single Family 1448 4586 2 1921 BEDS 233 699000 Single Family 2460 9901 4 2 5 1951 BATHS 234 68900 Single Family 1308 3750 2 1920 YEAR BUILT 235 359000 Single Family 3061 10898 A 4 1926 236 358900 Single Family 2000 1393 A 3 1960 237 229900 Single Family 1080 3750 A 3 1917 238 419900 Single Family 2352 3994 3 3 5 2006 239 45000 Single Family 2436 3781 5 2 1899 240 244900 Single Family 975 3541 2 1946 241 419000 Single Family 1672 4125 3 2 1925 242 59900 Single Family 1690 4687 1 1911 243 1479 Single Family 4400 3123 4 5 2018 244 498000 Single Family 3200 7500 A 3 5 1929 245 268900 Single Family 2078 5318 4 2 1993 246 275000 Condo Co op 1400 5400 IN 1 1921 247 297500 Single Family 1224 3990 3 3 1977 248 125000 Single Family 1137 3685 1 IN 1948 Rows 249 139000 Single Family 1000 5000 2 1 5 1949 All rows 500 3300 3125 4 3 5 2018 Selected 250 779000 Single Family O Excluded 251 196900 Single Family 2500 3720 2 1937 Hidden 252 144900 Single Family 1875 3720 4 2 1925 Labeled 253 234900 Single Family 2250 4251 Co 1919254 255000 Single Family 1072 4375 3 2 1953 255 129900 Single Family 1188 3689 5 N 1947 256 139900 Single Family 1141 3149 4 1920 257 449000 Townhouse 2200 2950 A 3 5 2018 258 925000 Single Family 4300 3123 5 3 5 2005 259 179000 Single Family 2400 3632 4 2 1885 260 725000 Single Family 1975 2748 3 5 1896 261 1139 Condo Co op 3300 3125 A 3 5 2017 262 369000 Single Family 1335 4499 A 1 5 1950 Columns (7 0) 263 534500 Single Family 3100 8498 2 5 1970 Q 264 53000 Single Family 1350 4726 1905 PRICE 265 1300 Single Family 4000 2021 A 4 5 1989 PROPERTY TYPE 266 449000 Condo Co op 1325 1000 2 1921 W N SQUARE FEET 267 399900 Single Family 2400 3123 3 5 2008 LOT SIZE 268 974900 Single Family 3600 8001 A 3 5 1935 BEDS 269 279000 Condo Co op 1100 10000 2 1 5 1918 BATHS 270 229900 Condo Co op 1300 7500 2 2 2003 YEAR BUILT 271 375000 Single Family 1309 3720 1 5 195 272 330000 Condo Co op 1380 6250 2 2 2005 273 300000 Single Family 1479 4159 2 1924 274 349900 Single Family 1660 4090 3 1 5 1951 275 89900 Single Family 1100 3423 3 2 1959 276 45000 Single Family 1091 3018 1953 277 89900 Single Family 1225 4356 2 2 1925 278 168000 Single Family 1835 3680 IN 1920 279 239900 Single Family 2923 4092 3 1915 WNOA 280 79900 Single Family 3720 3720 1923 281 89900 Single Family 1032 2848 1 5 1959 282 22000 Single Family 1298 3101 3 1 1895 283 334900 Single Family 1400 4512 2 1963 284 50000 Townhouse 1000 2500 N 1 5 1889 Rows 285 198000 Single Family 1238 5344 3 2 1936 All rows 500 286 450000 Single Family 2600 3750 2 5 2001 Selected O 287 109900 Single Family 550 3123 2 5 1895 Excluded Hidden 288 523000 Townhouse 2500 3750 3 1918 Labeled 289 276900 Single Family 2500 4264 1956290 359900 Single Family 1281 4909 3 2 1962 291 134999 Single Family 1364 7126 IN 1 195 292 999000 Single Family 3300 2901 3 5 2018 293 319900 Single Family 1932 5758 6 1 5 1940 294 439999 Single Family 2700 4774 A 3 5 2000 295 279900 Single Family 1100 5632 2 2011 296 389000 Single Family 2018 3781 3 1985 297 274888 Single Family 1130 3123 A 2 5 1997 298 380000 Single Family 2800 5492 3 1930 W O) Columns (7 0) 299 309000 Single Family 1748 7531 2 1913 Q 300 268000 Single Family 1100 3149 A 2 1958 A PRICE 301 198900 Condo Co op 2300 18787 3 1907 PROPERTY TYPE 302 125000 Single Family 1332 3750 1 5 1947 N W SQUARE FEET 303 299000 Condo Co op 1000 1000 1 1960 LOT SIZE 304 275000 Single Family 1215 4125 IN 1 5 1929 BEDS 1100 3750 1 BATHS 305 101000 Single Family 4 1943 YEAR BUILT 306 135900 Single Family 2500 3123 2 1960 307 409900 Single Family 2532 3781 3 1909 308 379500 Condo Co op 1600 8250 2 1 1914 309 550000 Single Family 2097 9178 3 2 1918 310 68000 Single Family 1333 7044 3 2 1941 311 229900 Single Family 1670 3001 4 2 1890 312 160000 Single Family 2098 7030 2 1878 A O 313 65000 Single Family 1100 3149 1875 314 539900 Townhouse 2400 968 2 5 2002 315 47000 Single Family 1862 3781 1 5 1900 316 279000 Single Family 1054 3123 N 1896 317 649000 Single Family 3300 3171 4 3 5 2018 318 259000 Single Family 1367 3123 4 2 1945 319 359000 Single Family 1498 5000 3 2 1960 320 399900 Single Family 2283 5244 2 1943 Rows 321 27000 Single Family 1272 3689 3 1 1908 All rows 500 322 184900 Single Family 1309 5641 Co 1 5 1948 Selected O 323 649900 Single Family 3600 4726 A 3 5 1906 Excluded Hidden 324 2449 Single Family 6400 5497 7 5 5 2004 Labeled 325 329000 Single Family 1207 2326 3 1891326 285000 Townhouse 2000 918 3 2008 327 569900 Single Family 1741 5318 W AA 2 5 1946 328 65000 Single Family 1152 3720 1913 329 999999 Single Family 4200 3123 3 5 2006 330 242000 Single Family 1224 3876 3 2 1956 331 269500 Single Family 1260 3720 4 1 1949 332 126900 Single Family 1207 3123 3 1 1944 333 439000 Single Family 1180 6351 3 2 1956 334 419000 Single Family 1744 4190 5 2 5 1952 Columns (7 0) 335 475900 Single Family 1869 3497 4 3 1905 Q 336 252500 Single Family 1439 6751 4 1 5 1933 PRICE 337 2495 Single Family 5400 3149 4 5 1994 PROPERTY TYPE 338 2465 Single Family 4250 3375 5 4 5 1886 SQUARE FEET 339 1299 Single Family 4400 3023 3 5 2001 LOT SIZE 340 599000 Single Family 4600 5471 4 3 5 1967 BEDS 341 399900 Single Family 3000 5000 6 3 1924 BATHS YEAR BUILT 342 330000 Single Family 880 2652 5 2 1885 343 235000 Single Family 1112 3750 N 1 5 1903 344 369900 Townhouse 1460 3 1 5 1996 345 1199 Single Family 4200 3075 3 5 2018 346 2500 Single Family 6212 2060 8 5 1865 347 750000 Single Family 4043 2949 5 3 5 1889 348 535000 Single Family 2650 2082 2 5 1895 349 240000 Single Family 2080 6150 3 1 5 1921 350 94800 Townhouse 890 2016 2 2 1944 351 77000 Single Family 1806 3125 3 2 1905 352 318000 Single Family 1600 3841 7 3 1925 353 650000 Single Family 3000 5000 4 1929 W O) 354 225000 Single Family 1715 3100 2 1913 355 458000 Single Family 2700 4656 4 3 5 1923 356 1390 Single Family 5894 990 6 5 2012 Rows 357 349000 Single Family 1458 6141 3 2 1978 All rows 500 358 94900 Single Family 1040 3123 1 5 1962 Selected O 1963 Excluded 359 279000 Condo Co op 350 850 1 Hidden 360 1549 Single Family 4200 3125 6 5 2018 Labeled 361 419000 Single Family 1344 4586 Co 2 5 1904362 529900 Single Family 2284 3125 3 3 5 1971 363 85900 Single Family 720 3123 N 1895 364 1399 Multi Family (5 22000 9147 31 22 1920 365 9000 Single Family 600 3349 1 1943 366 192400 Single Family 2100 3946 2 1920 367 99900 Single Family 1820 6250 5 2 1900 368 234900 Single Family 1082 3750 2 5 1956 369 520000 Single Family 2095 5614 2 1901 370 175000 Single Family 1700 3750 2 1947 Columns (7 0) 371 175000 Single Family 1000 3001 1 5 1885 Q 372 269900 Single Family 1200 6429 2 1948 PRICE 373 224900 Single Family 1700 6480 4 2 1921 PROPERTY TYPE 374 42000 Single Family 660 3149 2 1890 UI A SQUARE FEET 375 69900 Single Family 1914 4425 1 5 1903 LOT SIZE 376 509000 Single Family 2967 3850 3 5 2018 BEDS 377 44500 Townhouse 1002 1309 2 1 5 1966 BATHS 378 313900 Single Family 1100 3811 3 1937 YEAR BUILT 379 729900 Single Family 3815 3632 2 5 2002 W A 380 195500 Single Family 1500 3214 2 1975 381 99000 Single Family 1050 3001 1 1890 382 499900 Single Family 2500 3876 A 2 5 2015 383 167000 Single Family 1500 3123 3 2 1895 384 290000 Single Family 1097 4687 2 1947 385 380000 Single Family 1600 6198 3 2 5 1975 386 229900 Single Family 1397 4281 4 2 1926 387 169999 Single Family 1057 3750 2 1954 388 310000 Single Family 1008 3811 4 3 1915 389 1850 Single Family 3082 3084 4 45 1886 390 164900 Single Family 998 4303 3 1 1949 391 104900 Single Family 1282 4687 1 5 1956 392 230000 Single Family 3780 3781 2 5 1945 Rows 393 152000 Single Family 1215 3667 3 1 5 1959 All rows 500 394 338000 Single Family 1020 3249 2 1958 Selected NA O Excluded 395 264500 Condo Co op 1000 12500 1 5 1925 Hidden 396 210000 Single Family 1700 4748 6 3 1911 Labeled 397 50000 Single Family 3080 4159 4 3 1885398 140000 Single Family 2240 5505 3 1913 399 1998 Single Family 5462 3660 6 5 5 2006 400 79900 Single Family 954 6699 1951 401 118700 Single Family 1272 6000 3 1 1921 402 389900 Single Family 2300 4726 A 2 5 1912 403 139900 Single Family 2100 2975 4 2 1885 404 169000 Single Family 1178 3624 3 2 1927 405 324900 Single Family 1440 3800 1 5 1939 406 173000 Single Family 1214 5000 3 2 1963 Columns (7 0) 407 689000 Single Family 2058 10168 CO 2 5 1947 Q 408 659900 Single Family 2686 4125 4 3 5 2018 PRICE 409 369900 Single Family 1325 5401 2 5 1971 PROPERTY TYPE 410 599900 Single Family 1200 2975 3 1891 SQUARE FEET 411 2450 Single Family 6313 4573 6 5 5 2005 LOT SIZE 412 190000 Single Family 831 6211 Co 2 1943 BEDS BATHS 413 1450 Single Family 4000 3105 5 3 5 2004 414 1599 Single Family 4500 4125 6 5 2018 YEAR BUILT 415 739000 Single Family 3700 5079 5 4 2017 416 490000 Multi Family (5 3600 3437 6 6 1904 417 235000 Single Family 1108 3781 5 3 1953 418 134900 Single Family 1169 3301 4 2 1923 419 1699 Single Family 1848 5318 3 3 1876 420 33000 Single Family 1723 3027 2 1918 421 549900 Single Family 2452 5079 A 3 5 1945 422 2095 Single Family 4500 3123 4 4 5 1989 423 200500 Single Family 2250 4965 1 5 1965 424 159900 Single Family 1197 3650 2 1951 425 349900 Single Family 3100 3123 3 1901 W O) 426 264900 Single Family 2700 4064 2 5 1938 427 1999 Single Family 4630 2975 5 3 5 1888 428 150000 Single Family 1200 4050 2 2 1944 Rows 429 135922 Single Family 1212 4373 3 1 1941 All rows 500 2952 3781 3 1945 Selected 430 355000 Single Family O Excluded 431 154900 Single Family 980 3123 IN 1961 Hidden 432 499000 Single Family 3800 5998 4 1955 Labeled N 433 162000 Single Family 1266 3720 Co 1993434 152900 Single Family 864 4935 1 1949 435 323900 Single Family 2000 3781 5 IN 1918 436 699000 Single Family 3800 6320 4 3 1913 437 449900 Single Family 1600 2526 2 1904 438 310000 Single Family 2086 3023 A 2 5 2014 439 215000 Single Family 1004 3750 4 2 1951 440 91000 Single Family 1044 3445 1922 441 199900 Single Family 1373 4164 2 1952 442 95000 Single Family 1000 5497 2 1978 Columns (7 0) 443 619000 Single Family 2500 8001 4 3 5 1926 444 254499 Single Family 1241 5079 5 Q 2 1952 PRICE 445 699900 Condo Co op 1300 6324 2 2 2018 PROPERTY TYPE 446 799900 Condo Co op 1450 6324 2 2018 SQUARE FEET 447 649000 Single Family 4100 3125 3 5 2006 LOT SIZE 448 1100 Condo Co op 2600 6324 A 2 5 2018 BEDS 1050 3149 3 BATHS 449 279000 Single Family 1964 YEAR BUILT 450 50000 Single Family 920 3907 1 1913 451 157000 Single Family 2122 1668 1 1890 452 589000 Single Family 3500 3171 3 5 2018 453 299000 Single Family 1400 3101 3 1889 454 439000 Single Family 1656 4373 1 5 1911 455 59900 Single Family 882 3101 3 1 5 1885 456 127900 Condo Co op 1000 3125 2 2 1893 457 325000 Single Family 1125 3123 4 3 1898 458 195499 Single Family 2500 3750 5 3 1922 459 85000 Townhouse 1088 2000 3 1 5 1888 460 185500 Single Family 1488 3075 3 1 5 1945 461 349000 Single Family 3780 3781 1 5 1917 462 399000 Single Family 2100 3250 3 1956 463 615000 Single Family 3800 4375 7 3 5 2006 464 400000 Single Family 3200 2750 4 3 5 2007 Rows 465 500000 Single Family 1267 3125 3 2 1901 All rows 500 466 300000 Single Family 2004 3906 2 5 1916 Selected O 467 164900 Single Family 1 5 Excluded 1132 5217 1958 Hidden 468 2500 Single Family 11000 5985 10 10 5 2006 Labeled 469 1299 Single Family 4200 2975 5 3 5 2017470 139500 Single Family 1032 2953 3 2 1964 471 1489 Single Family 5000 4508 4 5 1899 472 625000 Single Family 5000 3484 3 5 1900 473 45000 Single Family 963 5401 1 5 1922 474 57000 Single Family 1008 3101 1921 Columns (7 0) 475 779000 Single Family 4000 5625 3 1925 a 476 599000 Multi Family (5 4928 6098 1970 C CO PRICE 477 285000 Single Family 1200 6751 1911 PROPERTY TYPE 478 13000 Single Family 1218 3750 3 1908 SQUARE FEET 479 139900 Single Family 1040 3123 1957 LOT SIZE 3908 3920 3 5 1890 BEDS 480 999900 Single Family WANTWA BATHS 481 51300 Single Family 1030 3125 1 1937 YEAR BUILT 482 229500 Single Family 1700 3781 2 5 1917 483 139000 Single Family 1215 4375 1920 484 1300 Single Family 3439 2550 A 3 5 1996 485 820000 Single Family 3490 2520 3 1891 486 510000 Single Family 2700 4257 3 5 2002 487 205000 Single Family 3750 3750 A 2 1954 488 3250 Single Family 5900 3000 6 2015 489 190000 Single Family 1051 5166 2 1949 490 160000 Single Family 3125 3125 O W A 1 5 2005 491 54400 Single Family 974 3907 1954 A N 492 105000 Single Family 2200 3660 1 5 1948 493 110000 Single Family 1040 3125 1963 C N 494 155000 Single Family 1600 5318 2 1945 495 170000 Single Family 1760 3750 2 1956 496 595000 Townhouse 2200 1340 A 2 1964 Rows 497 22000 Single Family 1080 4687 1 1890 All rows 500 C N 498 325000 Condo Co op 1400 3250 2 5 2006 Selected Excluded 499 180000 Single Family 7250 3998 2 5 1939 W A Hidden 500 229000 Townhouse 1510 3125 1 5 1944 Labeled

Question

Hi  This is a long shot in the dark, but I am clearly struggling  I attached what I have been working on  Literally any help is appreciated  You are asked to find the best fit model to predict the price of a property in Chicago  You are considering the following regression models  Model1  use square feet as the independent variable  Model2  use square feet and beds as the independent variables  Model3  use property type, square feet, and beds as the independent variables  Answer the following  a  What is the RSquare for Model 1  b  The RSquare Adj for Model1 is what  c  Model 1 predicts the price for a property of 3,000 sq ft to be what  d  What is The RSquare for Model 2  e  The RSquare Adj for Model2 is what  f  Model 2 predicts the price for a property of 3,000 sq ft with 3 bedrooms to be what  g  What is the RSquare for Model 3  h  What is the RSquare Adj for Model 3  i  Model3 predicts the price for a single family residential property of 3,000 sq ft with 3 bedrooms to be what  j  Model3 is the best fit model (T F) 73 450000 Single Family     777 2326 2 1887 C A 74 284900 Single Family     1138 3702 1958 75 59000 Single Family     1500 3123 4 2 1905 76 550000 Multi Family (5    7863 7863 15 6 1927 77 515000 Townhouse 1482 320 2 1987 78 75000 Single Family     1902 2979 3 1 1962 79 1650    Single Family     4300 3125 4 5 2018 80 523900 Single Family     1852 8642 2 1938 81 475000 Single Family     1751 4090 1 5 1942 Columns (7 0) 82 150000 Single Family     3660 6198 A 2 1908 Q 83 419000 Single Family     2600 3720 3 1984 PRICE 84 145000 Single Family     809 4373 1941 PROPERTY TYPE 85 679000 Single Family     3600 3654 3 5 1916 SQUARE FEET 86 309000 Single Family     1238 4782 W W A 2 5 1943 LOT SIZE 87 719000 Single Family     2200 2975 3 1992 BEDS 3750 4 3 1951 BATHS 88 447500 Single Family     1480 YEAR BUILT 89 109000 Single Family     2200 4913 2 1946 90 359000 Single Family     1418 5623 3 1942 91 434900 Single Family     2144 9539 2 5 1931 92 289900 Single Family     1458 4887 2 1959 On A 93 418000 Single Family     2826 7679 3 1946 94 459000 Single Family     2300 2156 4 3 5 2005 95 1050    Condo Co op 2100 9432 2 2018 96 869900 Multi Family (5    5841 4356 12 6 1885 97 414900 Single Family     1758 4382 4 3 1950 98 659900 Single Family     3600 8000 3 1951 99 41000 Single Family     736 3750 T A 1913 100 339900 Single Family     2274 10049 A 2 5 1953 101 49900 Single Family     800 3001 3 1920 102 45000 Single Family     1300 2474 2 1900 103 217500 Single Family     1892 5431 3 2 5 1910 Rows 104 189900 Single Family     2100 3689 3 3 1948 All rows 500 105 1075    Single Family     3300 3750 3 5 1899 Selected O Excluded 106 335000 Single Family     1489 4961 1 5 1944 Hidden 107 512000 Townhouse 2372 2184 4 2 5 1963 Labeled 108 239000 Single Family     2200 4251 4 2 19453 real estate v6 (1)  mp EIIM EV Distribution Fit Y by X Fit Model Window Tools Recode g  PROPERTY SQUARE LOT YEAR Note Real estate data E  PRICE TYPE FEEI' SIZE BEDS BATHS BUILT 1 330000 Single Family    1971 5187 4 2 5 1929 2 479900 Single Family    2850 5079 4 3 5 1924 3 439000 Single Family    1400 10153 3 3 1922 4 500000 Single Family    1500 2905 3 2 1998 5 315000 Single Family    1324 3720 3 1 5 1951 5 224900 Single Family    2550 4822 4 3 1920 7 239900 Single Family    2840 4438 5 2 1910 8 439000 Townhouse 2500 3000 3 3 2000 9 579000 Condo Co op 2650 8512 3 2 5 2017 10 59900 Single Family    1328 4338 4 2 1922 q 11 599900 Single Family    4428 8498 4 3 2007 A PRICE 12 120000 Multi Family (5    7005 3049 15 5 1894 I  PROPEFlTYTYPE 13 295000 Single Family    1311 3689 3 1 5 1945 A SQUARE FEEF 14 157000 Single Family 1250 4215 3 1 1913 1 323 25 15 489900 Townhouse 1850 535 3 2 5 1997 A BATHS 15 285900 Single Family    2150 4921 5 2 1955 'YEAR BUILT 17 159900 Single Family    958 4154 3 1 5 1944 18 135000 Single Family    1558 5000 4 2 1949 19 415000 Single Family    2268 3720 4 3 2000 20 15000 Single Family    1964 5998 4 2 1885 21 349000 Single Family    1452 4725 3 1 1899 22 479000 Single Family    2599 5248 4 3 5 1994 23 339997 Single Family    2371 3750 4 2 5 1951 24 500000 Single Family    1555 3149 5 3 1892 25 2499    Single Family    3395 1375 4 4 5 1883 25 174900 Single Family    1015 3575 2 1 5 1947 27 259900 Single Family    1300 5318 3 1 5 1948 28 179900 Single Family    900 3123 2 1 1954 29 399000 Single Family    2070 3937 5 2 1928 30 124999 Single Family    1430 3375 5 2 1910 31 419900 Single Family    3750 3750 5 3 1952 32 525000 Condo Co op 2000 3125 2 3 2000 32$  0 33 325000 Single Family    2450 3524 5 3 1955 Excluded 0 34 499900 Single Family    2545 4125 4 1 5 1920 Hidden 0 35 255000 Condo Co op 853 853 1 1 2008 Labeled 0 35 349900 Single Family    1277 3750 5 2 5 2008 37 339900 Single Family     1850 5000 4 2 1939 38 149900 Single Family     1181 4613 A 1 5 1961 39 549900 Single Family     2600 4303 6 3 5 1906 40 439900 Single Family     2026 1961 3 2 5 1936 41 619000 Single Family     2778 6599 3 2 5 1931 42 595000 Single Family     3000 2949 4 2 5 2007 43 286900 Single Family     2046 3088 3 1947 44 184900 Single Family     1584 3750 2 1915 45 229000 Single Family     980 4573 2 1 5 1947 Columns (7 0) 46 165200 Single Family     1169 3624 1920 Q 47 1375    Single Family     3444 2400 4 5 1998 PRICE 48 259000 Single Family     1959 3720 3 2 1923 PROPERTY TYPE 49 25000 Single Family     1250 3123 5 1 5 1910 SQUARE FEET 50 374900 Single Family     2200 3750 5 2 1927 LOT SIZE 51 799000 Single Family     2000 1925 4 2 1888 BEDS 52 249500 Single Family     3800 3750 5 3 1914 BATHS YEAR BUILT 53 549900 Single Family     2500 5039 4 1924 54 200000 Single Family     1260 3125 2 1925 55 46200 Single Family     1249 5000 3 1 5 1947 56 275000 Single Family     1350 2252 4 2 1959 57 273900 Single Family     1150 3632 5 2 1965 58 259000 Single Family     4000 4024 5 3 1920 59 820000 Condo Co op 1979 10190 2 2018 60 4995    Single Family     7000 8646 6 5 5 2003 61 40000 Single Family     1081 3075 3 1 1895 62 775000 Townhouse 1775 735 3 2 5 1969 63 550000 Single Family     2650 2648 2 5 1891 64 289900 Single Family     1750 3720 4 3 1922 65 225000 Single Family     1045 4373 2 1951 66 329000 Single Family     2080 4159 3 1 1914 67 149900 Townhouse 1435 1435 2 2008 Rows 68 94500 Townhouse 1352 4440 3 1 1945 All rows 500 69 719000 Single Family     2800 3123 4 3 5 1905 Selected O Excluded 70 229000 Single Family     2250 3123 A 2 1916 Hidden 71 274000 Single Family     1200 3149 6 2 1965 Labeled 72 1550    Single Family     4191 3101 3 5 2011109 112500 Single Family     931 3249 1 5 1942 110 64900 Single Family     1212 3728 1908 111 500000 Single Family     2000 8772 A 1 5 1896 112 21900 Single Family     1849 4647 4 2 1885 113 395000 Single Family     2080 6751 3 3 1926 114 559900 Single Family     3098 7501 6 4 1910 115 2495    Single Family     5000 4944 4 1875 116 377900 Single Family     1725 5623 4 2 1950 117 165000 Single Family     1235 4373 1 5 1968 Columns (7 0) 118 497500 Townhouse 2000 2000 NWA 2 1999 Q 119 259000 Townhouse 966 3300 1947 PRICE 120 850000 Single Family     1558 3484 3 1896 PROPERTY TYPE 121 309000 Single Family     1210 4499 3 2 1922 SQUARE FEET 122 1299    Single Family     5000 6250 4 1905 W O LOT SIZE 123 27137 Single Family     1380 3937 1 5 1895 BEDS 124 799900 Single Family     4965 10079 5 5 5 2002 BATHS YEAR BUILT 125 110000 Single Family     956 3101 1 1880 UI N 126 299900 Single Family     1700 3750 3 1937 127 299900 Single Family     1600 4464 3 2 1945 128 349000 Condo Co op 1600 4875 3 3 2006 129 119900 Single Family     1000 3101 A 1969 130 234900 Single Family     1027 5357 3 1 1952 131 330000 Single Family     1530 4321 1 5 1960 132 123500 Single Family     1684 3049 2 1888 133 350000 Single Family     1648 1524 3 1 1885 134 259400 Single Family     2200 5144 3 1914 135 89900 Single Family     298 3689 6 3 1919 136 149900 Single Family     1400 3149 4 2 1895 137 279000 Single Family     2280 4687 5 3 1913 138 135000 Single Family     891 5806 3 1946 A UT 139 177000 Single Family     1600 4159 2 1957 Rows 140 169999 Single Family     1396 3125 A 1 5 1924 All rows 500 1323 5000 Selected 141 339900 Single Family     5 2 1919 O 3101 Co 1928 Excluded 142 459900 Single Family     2800 UI A Hidden 143 1695    Single Family     5200 3079 4 5 1994 Labeled 144 209900 Single Family     1272 3781 Co 2 1956146 375400 Single Family     1212 3750 5 3 1922 147 2999    Single Family     5850 1755 5 5 5 1909 148 479900 Single Family     2430 3746 5 3 5 1953 149 650000 Single Family     2000 2674 3 2 5 1875 150 230000 Single Family     2702 4303 4 2 1954 151 182900 Single Family     1100 4094 2 1 5 1949 152 475000 Single Family     2000 3014 2 5 1901 153 214900 Single Family     1135 7339 4 2 1955 154 92500 Single Family     1524 3123 5 1 5 1905 Columns (7 0) 155 614900 Single Family     2498 5884 4 2 5 1969 Q 156 195000 Single Family     1600 4268 3 2 1937 PRICE 157 349000 Single Family     2850 2748 2 2 5 1875 PROPERTY TYPE 158 139000 Townhouse 1093 4000 3 1 5 1952 SQUARE FEET 159 599900 Single Family     2970 3036 4 3 5 2018 LOT SIZE 160 1489    Single Family     5100 3720 3 5 1914 BEDS 2265 8001 4 1925 BATHS 161 474900 Single Family     1 5 YEAR BUILT 162 874900 Single Family     3124 3750 4 5 1911 163 345900 Single Family     1300 4800 5 2 1955 164 72500 Single Family     1320 3720 3 2 1919 165 2400    Single Family     5600 4112 4 5 2008 166 324900 Condo Co op 1200 6250 2 2009 167 375000 Single Family     1144 2700 4 2 5 1914 168 449000 Single Family     1576 3781 3 2 1924 169 85000 Single Family     1100 3125 3 2 1912 170 49900 Single Family     1400 3123 2 1 1921 171 76900 Single Family     1150 4090 1 1912 UI N 172 1500    Single Family     5000 2600 4 5 2009 173 620000 Single Family     3600 4229 A 3 5 2018 174 650000 Single Family     1600 2265 2 5 1994 175 139000 Single Family     1320 4373 2 5 1880 176 299900 Single Family     1060 3125 A 2 1959 Rows 177 169900 Single Family     1500 3149 2 5 1912 All rows 500 178 225000 Condo Co op 1000 10650 W N W 2 1920 Selected O 179 259900 Single Family     IN Excluded 790 3750 1912 Hidden 180 174873 Single Family     1449 6250 2 1905 Labeled 181 1675    Single Family     3600 2400 A 1886182 229900 Single Family     1564 3149 5 2 5 1905 183 139995 Single Family     1310 4913 A 1 5 1900 184 14900 Single Family     903 3123 1 1918 NN 185 665000 Condo Co op 1250 3125 2 2015 186 1399    Single Family     6500 21122 4 4 5 1999 187 90000 Single Family     4032 7501 5 3 1901 188 499000 Condo Co op 2400 6250 3 3 2001 189 359000 Single Family     2478 5863 5 2 1927 190 779000 Single Family     2500 8576 4 4 1966 Columns (7 0) 191 499900 Single Family     1352 3123 3 1901 Q 192 309900 Single Family     1402 5187 1 5 1945 PRICE 193 545000 Single Family     1891 2444 A 3 5 2016 PROPERTY TYPE 194 1295    Single Family     3800 4125 A 3 5 2014 SQUARE FEET 195 272000 Single Family     1100 5052 2 1938 LOT SIZE 196 25000 Single Family     1500 3750 1 1907 BEDS BATHS 197 264900 Single Family     1735 3541 3 1939 YEAR BUILT 198 364500 Single Family     1000 3750 O W A 2 1955 199 2399    Single Family     6700 4530 5 5 2005 200 3099    Single Family     5826 3001 6 4 5 2011 201 76385 Single Family     1387 2613 A 2 1890 202 130000 Single Family     1510 3680 3 2 1917 203 350000 Single Family     1677 3049 4 2 1895 204 298700 Single Family     1364 6050 2 5 1949 205 239000 Single Family     1015 4159 A 3 1924 206 139900 Single Family     1026 3123 1 1922 207 35000 Single Family     1920 6250 A 2 1889 208 70000 Single Family     1344 4613 A 1 5 1914 209 231000 Single Family     1050 4752 1 1952 210 489900 Single Family     2506 3968 5 3 1945 211 435000 Condo Co op 1258 3125 2 2 2008 212 113500 Single Family     1430 3685 4 1 1895 Rows 213 499000 Single Family     2987 4687 8 3 1950 All rows 500 214 306900 Single Family     2000 3149 A 3 1924 Selected O Excluded 215 800000 Single Family     3122 10659 A 3 5 1947 Hidden 216 175000 Single Family     1600 3750 A 2 1920 Labeled 217 849900 Condo Co op 3100 4575 3 2 5 2000218 1175    Single Family     3200 2861 3 5 1886 A 219 649000 Single Family     5549 5296 6 4 5 1890 220 228000 Single Family     1100 3750 3 1 1954 221 230000 Single Family     1482 6015 A 3 1920 222 209900 Single Family     1699 4499  A 2 5 1952 223 23000 Single Family     1492 3275 4 2 1885 224 139900 Single Family     726 5079 1 1966 225 1650    Single Family     3739 2500 4 4 5 1994 226 359900 Single Family     2000 3811 5 2 1954 Columns (7 0) 227 258900 Single Family     1969 6650 1 5 1966 Q 228 2550    Single Family     5369 4199 4 5 2002 PRICE 229 349900 Townhouse 1606 2376 3 3 2007 PROPERTY TYPE 230 20000 Single Family     1256 3101 4 1 5 1885 SQUARE FEET 231 379900 Single Family     2400 6200 3 1949 LOT SIZE 232 335000 Single Family     1448 4586 2 1921 BEDS 233 699000 Single Family     2460 9901 4 2 5 1951 BATHS 234 68900 Single Family     1308 3750 2 1920 YEAR BUILT 235 359000 Single Family     3061 10898 A 4 1926 236 358900 Single Family     2000 1393 A 3 1960 237 229900 Single Family     1080 3750 A 3 1917 238 419900 Single Family     2352 3994 3 3 5 2006 239 45000 Single Family     2436 3781 5 2 1899 240 244900 Single Family     975 3541 2 1946 241 419000 Single Family     1672 4125 3 2 1925 242 59900 Single Family     1690 4687 1 1911 243 1479    Single Family     4400 3123 4 5 2018 244 498000 Single Family     3200 7500 A 3 5 1929 245 268900 Single Family     2078 5318 4 2 1993 246 275000 Condo Co op 1400 5400 IN 1 1921 247 297500 Single Family     1224 3990 3 3 1977 248 125000 Single Family     1137 3685 1 IN 1948 Rows 249 139000 Single Family     1000 5000 2 1 5 1949 All rows 500 3300 3125 4 3 5 2018 Selected 250 779000 Single Family     O Excluded 251 196900 Single Family     2500 3720 2 1937 Hidden 252 144900 Single Family     1875 3720 4 2 1925 Labeled 253 234900 Single Family     2250 4251 Co 1919254 255000 Single Family     1072 4375 3 2 1953 255 129900 Single Family     1188 3689 5 N 1947 256 139900 Single Family     1141 3149 4 1920 257 449000 Townhouse 2200 2950 A 3 5 2018 258 925000 Single Family     4300 3123 5 3 5 2005 259 179000 Single Family     2400 3632 4 2 1885 260 725000 Single Family     1975 2748 3 5 1896 261 1139    Condo Co op 3300 3125 A 3 5 2017 262 369000 Single Family     1335 4499 A 1 5 1950 Columns (7 0) 263 534500 Single Family     3100 8498 2 5 1970 Q 264 53000 Single Family     1350 4726 1905 PRICE 265 1300    Single Family     4000 2021 A 4 5 1989 PROPERTY TYPE 266 449000 Condo Co op 1325 1000 2 1921 W N SQUARE FEET 267 399900 Single Family     2400 3123 3 5 2008 LOT SIZE 268 974900 Single Family     3600 8001 A 3 5 1935 BEDS 269 279000 Condo Co op 1100 10000 2 1 5 1918 BATHS 270 229900 Condo Co op 1300 7500 2 2 2003 YEAR BUILT 271 375000 Single Family     1309 3720 1 5 195 272 330000 Condo Co op 1380 6250 2 2 2005 273 300000 Single Family     1479 4159 2 1924 274 349900 Single Family     1660 4090 3 1 5 1951 275 89900 Single Family     1100 3423 3 2 1959 276 45000 Single Family     1091 3018 1953 277 89900 Single Family     1225 4356 2 2 1925 278 168000 Single Family     1835 3680 IN 1920 279 239900 Single Family     2923 4092 3 1915 WNOA 280 79900 Single Family     3720 3720 1923 281 89900 Single Family     1032 2848 1 5 1959 282 22000 Single Family     1298 3101 3 1 1895 283 334900 Single Family     1400 4512 2 1963 284 50000 Townhouse 1000 2500 N 1 5 1889 Rows 285 198000 Single Family     1238 5344 3 2 1936 All rows 500 286 450000 Single Family     2600 3750 2 5 2001 Selected O 287 109900 Single Family     550 3123 2 5 1895 Excluded Hidden 288 523000 Townhouse 2500 3750 3 1918 Labeled 289 276900 Single Family     2500 4264 1956290 359900 Single Family     1281 4909 3 2 1962 291 134999 Single Family     1364 7126 IN 1 195 292 999000 Single Family     3300 2901 3 5 2018 293 319900 Single Family     1932 5758 6 1 5 1940 294 439999 Single Family     2700 4774 A 3 5 2000 295 279900 Single Family     1100 5632 2 2011 296 389000 Single Family     2018 3781 3 1985 297 274888 Single Family     1130 3123 A 2 5 1997 298 380000 Single Family     2800 5492 3 1930 W O) Columns (7 0) 299 309000 Single Family     1748 7531 2 1913 Q 300 268000 Single Family     1100 3149 A 2 1958 A PRICE 301 198900 Condo Co op 2300 18787 3 1907 PROPERTY TYPE 302 125000 Single Family     1332 3750 1 5 1947 N W SQUARE FEET 303 299000 Condo Co op 1000 1000 1 1960 LOT SIZE 304 275000 Single Family     1215 4125 IN 1 5 1929 BEDS 1100 3750 1 BATHS 305 101000 Single Family     4 1943 YEAR BUILT 306 135900 Single Family     2500 3123 2 1960 307 409900 Single Family     2532 3781 3 1909 308 379500 Condo Co op 1600 8250 2 1 1914 309 550000 Single Family     2097 9178 3 2 1918 310 68000 Single Family     1333 7044 3 2 1941 311 229900 Single Family     1670 3001 4 2 1890 312 160000 Single Family     2098 7030 2 1878 A O 313 65000 Single Family     1100 3149 1875 314 539900 Townhouse 2400 968 2 5 2002 315 47000 Single Family     1862 3781 1 5 1900 316 279000 Single Family     1054 3123 N 1896 317 649000 Single Family     3300 3171 4 3 5 2018 318 259000 Single Family     1367 3123 4 2 1945 319 359000 Single Family     1498 5000 3 2 1960 320 399900 Single Family     2283 5244 2 1943 Rows 321 27000 Single Family     1272 3689 3 1 1908 All rows 500 322 184900 Single Family     1309 5641 Co 1 5 1948 Selected O 323 649900 Single Family     3600 4726 A 3 5 1906 Excluded Hidden 324 2449    Single Family     6400 5497 7 5 5 2004 Labeled 325 329000 Single Family     1207 2326 3 1891326 285000 Townhouse 2000 918 3 2008 327 569900 Single Family     1741 5318 W AA 2 5 1946 328 65000 Single Family     1152 3720 1913 329 999999 Single Family     4200 3123 3 5 2006 330 242000 Single Family     1224 3876 3 2 1956 331 269500 Single Family     1260 3720 4 1 1949 332 126900 Single Family     1207 3123 3 1 1944 333 439000 Single Family     1180 6351 3 2 1956 334 419000 Single Family     1744 4190 5 2 5 1952 Columns (7 0) 335 475900 Single Family     1869 3497 4 3 1905 Q 336 252500 Single Family     1439 6751 4 1 5 1933 PRICE 337 2495    Single Family     5400 3149 4 5 1994 PROPERTY TYPE 338 2465    Single Family     4250 3375 5 4 5 1886 SQUARE FEET 339 1299    Single Family     4400 3023 3 5 2001 LOT SIZE 340 599000 Single Family     4600 5471 4 3 5 1967 BEDS 341 399900 Single Family     3000 5000 6 3 1924 BATHS YEAR BUILT 342 330000 Single Family     880 2652 5 2 1885 343 235000 Single Family     1112 3750 N 1 5 1903 344 369900 Townhouse 1460 3 1 5 1996 345 1199    Single Family     4200 3075 3 5 2018 346 2500    Single Family     6212 2060 8 5 1865 347 750000 Single Family     4043 2949 5 3 5 1889 348 535000 Single Family     2650 2082 2 5 1895 349 240000 Single Family     2080 6150 3 1 5 1921 350 94800 Townhouse 890 2016 2 2 1944 351 77000 Single Family     1806 3125 3 2 1905 352 318000 Single Family     1600 3841 7 3 1925 353 650000 Single Family     3000 5000 4 1929 W O) 354 225000 Single Family     1715 3100 2 1913 355 458000 Single Family     2700 4656 4 3 5 1923 356 1390    Single Family     5894 990 6 5 2012 Rows 357 349000 Single Family     1458 6141 3 2 1978 All rows 500 358 94900 Single Family     1040 3123 1 5 1962 Selected O 1963 Excluded 359 279000 Condo Co op 350 850 1 Hidden 360 1549    Single Family     4200 3125 6 5 2018 Labeled 361 419000 Single Family     1344 4586 Co 2 5 1904362 529900 Single Family     2284 3125 3 3 5 1971 363 85900 Single Family     720 3123 N 1895 364 1399    Multi Family (5    22000 9147 31 22 1920 365 9000 Single Family     600 3349 1 1943 366 192400 Single Family     2100 3946 2 1920 367 99900 Single Family     1820 6250 5 2 1900 368 234900 Single Family     1082 3750 2 5 1956 369 520000 Single Family     2095 5614 2 1901 370 175000 Single Family     1700 3750 2 1947 Columns (7 0) 371 175000 Single Family     1000 3001 1 5 1885 Q 372 269900 Single Family     1200 6429 2 1948 PRICE 373 224900 Single Family     1700 6480 4 2 1921 PROPERTY TYPE 374 42000 Single Family     660 3149 2 1890 UI A SQUARE FEET 375 69900 Single Family     1914 4425 1 5 1903 LOT SIZE 376 509000 Single Family     2967 3850 3 5 2018 BEDS 377 44500 Townhouse 1002 1309 2 1 5 1966 BATHS 378 313900 Single Family     1100 3811 3 1937 YEAR BUILT 379 729900 Single Family     3815 3632 2 5 2002 W A 380 195500 Single Family     1500 3214 2 1975 381 99000 Single Family     1050 3001 1 1890 382 499900 Single Family     2500 3876 A 2 5 2015 383 167000 Single Family     1500 3123 3 2 1895 384 290000 Single Family     1097 4687 2 1947 385 380000 Single Family     1600 6198 3 2 5 1975 386 229900 Single Family     1397 4281 4 2 1926 387 169999 Single Family     1057 3750 2 1954 388 310000 Single Family     1008 3811 4 3 1915 389 1850    Single Family     3082 3084 4 45 1886 390 164900 Single Family     998 4303 3 1 1949 391 104900 Single Family     1282 4687 1 5 1956 392 230000 Single Family     3780 3781 2 5 1945 Rows 393 152000 Single Family     1215 3667 3 1 5 1959 All rows 500 394 338000 Single Family     1020 3249 2 1958 Selected NA O Excluded 395 264500 Condo Co op 1000 12500 1 5 1925 Hidden 396 210000 Single Family     1700 4748 6 3 1911 Labeled 397 50000 Single Family     3080 4159 4 3 1885398 140000 Single Family     2240 5505 3 1913 399 1998    Single Family     5462 3660 6 5 5 2006 400 79900 Single Family     954 6699 1951 401 118700 Single Family     1272 6000 3 1 1921 402 389900 Single Family     2300 4726 A 2 5 1912 403 139900 Single Family     2100 2975 4 2 1885 404 169000 Single Family     1178 3624 3 2 1927 405 324900 Single Family     1440 3800 1 5 1939 406 173000 Single Family     1214 5000 3 2 1963 Columns (7 0) 407 689000 Single Family     2058 10168 CO 2 5 1947 Q 408 659900 Single Family     2686 4125 4 3 5 2018 PRICE 409 369900 Single Family     1325 5401 2 5 1971 PROPERTY TYPE 410 599900 Single Family     1200 2975 3 1891 SQUARE FEET 411 2450    Single Family     6313 4573 6 5 5 2005 LOT SIZE 412 190000 Single Family     831 6211 Co 2 1943 BEDS BATHS 413 1450    Single Family     4000 3105 5 3 5 2004 414 1599    Single Family     4500 4125 6 5 2018 YEAR BUILT 415 739000 Single Family     3700 5079 5 4 2017 416 490000 Multi Family (5    3600 3437 6 6 1904 417 235000 Single Family     1108 3781 5 3 1953 418 134900 Single Family     1169 3301 4 2 1923 419 1699    Single Family     1848 5318 3 3 1876 420 33000 Single Family     1723 3027 2 1918 421 549900 Single Family     2452 5079 A 3 5 1945 422 2095    Single Family     4500 3123 4 4 5 1989 423 200500 Single Family     2250 4965 1 5 1965 424 159900 Single Family     1197 3650 2 1951 425 349900 Single Family     3100 3123 3 1901 W O) 426 264900 Single Family     2700 4064 2 5 1938 427 1999    Single Family     4630 2975 5 3 5 1888 428 150000 Single Family     1200 4050 2 2 1944 Rows 429 135922 Single Family     1212 4373 3 1 1941 All rows 500 2952 3781 3 1945 Selected 430 355000 Single Family     O Excluded 431 154900 Single Family     980 3123 IN 1961 Hidden 432 499000 Single Family     3800 5998 4 1955 Labeled N 433 162000 Single Family     1266 3720 Co 1993434 152900 Single Family     864 4935 1 1949 435 323900 Single Family     2000 3781 5 IN 1918 436 699000 Single Family     3800 6320 4 3 1913 437 449900 Single Family     1600 2526 2 1904 438 310000 Single Family     2086 3023 A 2 5 2014 439 215000 Single Family     1004 3750 4 2 1951 440 91000 Single Family     1044 3445 1922 441 199900 Single Family     1373 4164 2 1952 442 95000 Single Family     1000 5497 2 1978 Columns (7 0) 443 619000 Single Family     2500 8001 4 3 5 1926 444 254499 Single Family     1241 5079 5 Q 2 1952 PRICE 445 699900 Condo Co op 1300 6324 2 2 2018 PROPERTY TYPE 446 799900 Condo Co op 1450 6324 2 2018 SQUARE FEET 447 649000 Single Family     4100 3125 3 5 2006 LOT SIZE 448 1100    Condo Co op 2600 6324 A 2 5 2018 BEDS 1050 3149 3 BATHS 449 279000 Single Family     1964 YEAR BUILT 450 50000 Single Family     920 3907 1 1913 451 157000 Single Family     2122 1668 1 1890 452 589000 Single Family     3500 3171 3 5 2018 453 299000 Single Family     1400 3101 3 1889 454 439000 Single Family     1656 4373 1 5 1911 455 59900 Single Family     882 3101 3 1 5 1885 456 127900 Condo Co op 1000 3125 2 2 1893 457 325000 Single Family     1125 3123 4 3 1898 458 195499 Single Family     2500 3750 5 3 1922 459 85000 Townhouse 1088 2000 3 1 5 1888 460 185500 Single Family     1488 3075 3 1 5 1945 461 349000 Single Family     3780 3781 1 5 1917 462 399000 Single Family     2100 3250 3 1956 463 615000 Single Family     3800 4375 7 3 5 2006 464 400000 Single Family     3200 2750 4 3 5 2007 Rows 465 500000 Single Family     1267 3125 3 2 1901 All rows 500 466 300000 Single Family     2004 3906 2 5 1916 Selected O 467 164900 Single Family     1 5 Excluded 1132 5217 1958 Hidden 468 2500    Single Family     11000 5985 10 10 5 2006 Labeled 469 1299    Single Family     4200 2975 5 3 5 2017470 139500 Single Family     1032 2953 3 2 1964 471 1489    Single Family     5000 4508 4 5 1899 472 625000 Single Family     5000 3484 3 5 1900 473 45000 Single Family     963 5401 1 5 1922 474 57000 Single Family     1008 3101 1921 Columns (7 0) 475 779000 Single Family     4000 5625 3 1925 a 476 599000 Multi Family (5    4928 6098 1970 C CO PRICE 477 285000 Single Family     1200 6751 1911 PROPERTY TYPE 478 13000 Single Family     1218 3750 3 1908 SQUARE FEET 479 139900 Single Family     1040 3123 1957 LOT SIZE 3908 3920 3 5 1890 BEDS 480 999900 Single Family     WANTWA BATHS 481 51300 Single Family     1030 3125 1 1937 YEAR BUILT 482 229500 Single Family     1700 3781 2 5 1917 483 139000 Single Family     1215 4375 1920 484 1300    Single Family     3439 2550 A 3 5 1996 485 820000 Single Family     3490 2520 3 1891 486 510000 Single Family     2700 4257 3 5 2002 487 205000 Single Family     3750 3750 A 2 1954 488 3250    Single Family     5900 3000 6 2015 489 190000 Single Family     1051 5166 2 1949 490 160000 Single Family     3125 3125 O W A 1 5 2005 491 54400 Single Family     974 3907 1954 A N 492 105000 Single Family     2200 3660 1 5 1948 493 110000 Single Family     1040 3125 1963 C N 494 155000 Single Family     1600 5318 2 1945 495 170000 Single Family     1760 3750 2 1956 496 595000 Townhouse 2200 1340 A 2 1964 Rows 497 22000 Single Family     1080 4687 1 1890 All rows 500 C N 498 325000 Condo Co op 1400 3250 2 5 2006 Selected Excluded 499 180000 Single Family     7250 3998 2 5 1939 W A Hidden 500 229000 Townhouse 1510 3125 1 5 1944 Labeled

Accepted Answer

The Answer is in the image, click to view ...

Question

Hi. This is a long shot in the dark, but I am clearly struggling. I attached what I have been working on. Literally any help

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Precalculus A Concise Course

Students also viewed these Mathematics questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question