PRICE100 FLOOR DIST VIEW END FURNISH SOLD 1 199 1 2 0 0 0 F 2 204 1 13 0 0 0 F 3 275 1 15 1 0 0 F 4 209 2 14 0 0 0 F 5 259 1 2 1 0 0 F 6 264 1 9 1 0 0 F 7 264 1 12 1 0 0 F 8 264 1 13 1 0 0 F 9 254 3 9 1 0 0 F 10 264 3 15 1 0 0 F 11 279 8 15 1 0 0 F 12 204 1 12 0 0 0 F 13 199 2 13 0 0 0 F 14 249 2 15 1 0 0 F 15 264 3 11 1 0 0 F 16 209 3 14 0 0 0 F 17 259 4 15 1 0 0 F 18 204 1 14 0 0 0 F 19 274 7 15 1 0 0 F 20 199 1 3 0 0 0 F 21 199 1 11 0 0 0 F 22 274 2 14 1 0 0 F 23 180 3 11 0 0 0 F 24 254 3 12 1 0 0 F 25 284 4 14 1 0 0 F 26 269 3 5 1 0 0 F 27 159 2 3 0 0 0 F 28 199 1 6 0 0 0 F 29 204 1 9 0 0 0 F 30 190 2 11 0 0 0 F 31 261 2 12 1 0 0 F 32 159 2 12 0 0 0 F 33 261 2 13 1 0 0 F 34 169 3 6 0 0 0 F 35 199 4 14 0 0 0 F 36 189 5 14 0 0 0 F 37 294 6 15 1 0 0 F 38 199 6 14 0 0 0 F 39 204 2 6 0 0 0 F 40 279 3 14 1 0 0 F 41 159 6 9 0 0 0 F 42 151 2 4 0 0 0 F 43 151 2 5 0 0 0 F 44 159 2 10 0 0 0 F 45 190 8 12 0 0 0 F 46 190 8 13 0 0 0 F 47 175 1 4 0 0 0 F 48 175 1 5 0 0 0 F 49 175 1 10 0 0 0 F 50 159 2 2 0 0 0 F 51 163 3 13 0 0 0 F 52 219 8 14 0 0 0 F 53 161 3 5 0 0 0 F 54 169 3 3 0 0 0 F 55 169 3 4 0 0 0 F 56 165 3 10 0 0 0 F 57 169 3 12 0 0 0 F 58 269 3 13 1 0 0 F 59 176 4 11 0 0 0 F 60 186 5 11 0 0 0 F 61 195 8 11 0 0 0 F 62 259 1 3 1 0 0 F 63 235 1 4 1 0 0 F 64 240 1 11 1 0 0 F 65 159 2 1 0 0 0 F 66 169 3 1 0 0 0 F 67 260 4 1 1 0 0 F 68 209 4 1 0 0 0 F 69 176 4 6 0 0 0 F 70 179 4 9 0 0 0 F 71 179 4 12 0 0 0 F 72 274 4 13 1 0 0 F 73 179 5 13 0 0 0 F 74 180 6 2 0 0 0 F 75 199 6 6 0 0 0 F 76 190 6 12 0 0 0 F 77 210 1 1 1 0 0 A 78 225 1 5 1 1 0 A 79 200 1 6 1 1 1 A 80 220 1 10 1 0 0 A 81 210 2 1 1 0 0 A 82 225 2 3 1 1 0 A 83 225 2 4 1 1 0 A 84 220 2 5 1 1 0 A 85 195 2 6 1 0 1 A 86 190 2 9 1 0 0 A 87 195 2 10 1 0 0 A 88 200 3 1 1 0 0 A 89 210 3 2 1 1 0 A 90 170 3 2 0 1 0 A 91 200 3 3 1 0 0 A 92 180 3 6 1 0 1 A 93 205 3 10 1 1 0 A 94 215 4 2 1 0 0 A 95 175 4 2 0 1 0 A 96 200 4 3 1 0 0 A 97 175 4 3 0 1 0 A 98 195 4 4 1 0 0 A 99 165 4 4 0 1 0 A 100 195 4 5 1 0 0 A 101 175 4 6 1 0 1 A 102 200 4 9 1 1 0 A 103 190 4 10 1 0 0 A 104 160 4 10 0 0 0 A 105 205 4 11 1 1 0 A 106 190 4 12 1 0 0 A 107 205 5 1 1 0 0 A 108 175 5 1 0 1 0 A 109 215 5 2 1 1 0 A 110 220 5 3 1 1 0 A 111 265 5 4 1 1 0 A 112 175 5 4 0 1 0 A 113 200 5 5 1 1 0 A 114 195 5 6 1 1 1 A 115 185 5 6 0 1 0 A 116 195 5 9 1 1 0 A 117 160 5 9 0 1 0 A 118 205 5 10 1 1 0 A 119 175 5 10 0 1 0 A 120 205 5 11 1 1 0 A 121 205 5 12 1 1 0 A 122 166 5 12 0 1 0 A 123 195 5 13 1 0 0 A 124 205 5 15 1 0 0 A 125 210 6 1 0 1 0 A 126 165 6 1 0 0 0 A 127 220 6 2 1 0 0 A 128 180 6 2 0 1 0 A 129 215 6 3 1 0 0 A 130 175 6 3 0 0 0 A 131 200 6 4 1 1 0 A 132 165 6 4 0 0 0 A 133 175 6 5 0 1 0 A 134 185 6 6 1 0 0 A 135 200 6 9 1 1 0 A 136 165 6 9 0 0 0 A 137 175 6 10 1 0 0 A 138 170 6 10 0 1 0 A 139 190 6 11 1 0 0 A 140 170 6 11 0 0 0 A 141 200 6 12 1 1 0 A 142 195 6 13 1 0 0 A 143 195 6 14 1 0 0 A 144 205 7 1 1 0 0 A 145 180 7 1 0 1 0 A 146 195 7 2 1 0 0 A 147 170 7 2 0 0 0 A 148 195 7 3 1 0 0 A 149 186 7 3 0 1 0 A 150 200 7 4 1 0 0 A 151 175 7 4 0 1 0 A 152 190 7 5 1 0 0 A 153 190 7 6 1 1 1 A 154 195 7 9 1 0 0 A 155 170 7 9 0 0 0 A 156 200 7 10 1 0 0 A 157 180 7 10 0 1 0 A 158 190 7 11 1 0 0 A 159 180 7 11 0 1 0 A 160 190 7 12 1 0 0 A 161 175 7 12 0 0 0 A 162 195 7 14 1 0 0 A 163 190 8 1 1 0 0 A 164 180 8 1 0 1 0 A 165 205 8 2 1 0 0 A 166 175 8 2 0 0 0 A 167 215 8 3 1 1 0 A 168 175 8 3 0 0 0 A 169 195 8 4 1 0 0 A 170 170 8 4 0 0 0 A 171 185 8 5 1 0 0 A 172 175 8 5 0 0 0 A 173 175 8 6 1 0 1 A 174 175 8 6 0 0 0 A 175 205 8 9 1 1 0 A 176 165 8 9 0 0 0 A 177 200 8 10 1 0 0 A 178 175 8 10 0 0 0 A 179 205 8 11 1 0 0 A 180 190 8 12 1 0 0 A 181 205 8 13 1 1 0 A 182 195 8 14 1 0 0 A 183 150 3 13 0 1 0 F 184 140 5 1 1 1 0 F 185 130 5 2 0 1 0 F 186 182 6 5 1 1 0 F 187 175 5 1 0 1 0 F 188 164 5 14 1 1 0 F 189 249 4 1 1 1 0 F 190 215 7 13 1 1 0 F 191 199 2 12 0 1 0 F 192 190 8 5 0 1 0 F 193 295 1 13 1 1 0 F 194 217 2 13 0 1 0 F 195 265 3 10 1 1 0 F 196 202 4 1 0 1 0 F 197 177 4 4 0 1 0 F 198 189 8 11 0 1 0 F 199 197 3 12 0 1 0 F 200 205 3 1 0 1 0 F 201 206 2 13 0 1 0 F 202 231 7 4 1 1 0 F 203 255 4 10 1 1 0 F 204 250 7 14 1 1 0 F 205 230 1 14 0 1 0 F 206 279 4 12 1 1 0 F 207 215 6 1 0 1 0 F 208 306 3 15 1 1 0 F 209 190 3 6 0 1 0 F Call: lm(formula = PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH, data = condo) Residuals: Min 1Q Median 3Q Max -70.878 -17.141 -1.102 14.253 66.830 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 183.5701 5.2207 35.162 < 2e-16 *** FLOOR -3.8076 0.7482 -5.089 8.18e-07 *** DIST 1.7414 0.3750 4.644 6.14e-06 *** VIEW 40.3251 3.4565 11.667 < 2e-16 *** END 4.2792 3.6023 1.188 0.236267 FURNISH -32.7162 9.5814 -3.415 0.000771 *** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 24.39 on 203 degrees of freedom Multiple R-squared: 0.4943, Adjusted R-squared: 0.4819 F-statistic: 39.69 on 5 and 203 DF, p-value: < 2.2e-16 Analysis of Variance Table Response: PRICE100 Df Sum Sq Mean Sq F value Pr(>F) FLOOR 1 14149 14149 23.7772 2.180e-06 *** DIST 1 21208 21208 35.6384 1.046e-08 *** VIEW 1 75065 75065 126.1426 < 2.2e-16 *** END 1 731 731 1.2281 0.2690833 FURNISH 1 6938 6938 11.6591 0.0007714 *** Residuals 203 120802 595 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Call: lm(formula = PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH + FLOORSQ + DISTSQ + FLR_DST, data = condo) Residuals: Min 1Q Median 3Q Max -80.475 -11.746 -1.844 11.834 61.781 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 209.8545 10.1218 20.733 < 2e-16 *** FLOOR -10.9558 3.5083 -3.123 0.00206 ** DIST -5.6603 1.7851 -3.171 0.00176 ** VIEW 39.2424 3.1916 12.296 < 2e-16 *** END 6.9211 3.4099 2.030 0.04371 * FURNISH -22.0264 9.0412 -2.436 0.01572 * FLOORSQ 1.0263 0.3478 2.951 0.00355 ** DISTSQ 0.5607 0.1030 5.444 1.51e-07 *** FLR_DST -0.2642 0.1529 -1.728 0.08546 . --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 22.38 on 200 degrees of freedom Multiple R-squared: 0.5807, Adjusted R-squared: 0.5639 F-statistic: 34.63 on 8 and 200 DF, p-value: < 2.2e-16 Analysis of Variance Table Response: PRICE100 Df Sum Sq Mean Sq F value Pr(>F) FLOOR 1 14149 14149 28.2527 2.831e-07 *** DIST 1 21208 21208 42.3466 6.017e-10 *** VIEW 1 75065 75065 149.8861 < 2.2e-16 *** END 1 731 731 1.4593 0.2284694 FURNISH 1 6938 6938 13.8537 0.0002568 *** FLOORSQ 1 3640 3640 7.2679 0.0076179 ** DISTSQ 1 15503 15503 30.9550 8.407e-08 *** FLR_DST 1 1496 1496 2.9873 0.0854621 . Residuals 200 100163 501 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Call: lm(formula = PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH + FLOORSQ + DISTSQ + FLR_DST + VIEW_FLOOR + VIEW_DIST + VIEW_FLOORSQ + VIEW_DISTSQ + VIEW_FLR_DST, data = condo) Residuals: Min 1Q Median 3Q Max -78.901 -11.495 -1.625 9.841 60.194 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 207.15942 14.37824 14.408 < 2e-16 *** FLOOR -11.58591 4.89540 -2.367 0.01893 * DIST -5.51740 2.66877 -2.067 0.04002 * VIEW 45.88975 19.25930 2.383 0.01815 * END 6.92359 3.33289 2.077 0.03908 * FURNISH -20.16191 8.79415 -2.293 0.02294 * FLOORSQ 1.23545 0.47521 2.600 0.01004 * DISTSQ 0.46382 0.15503 2.992 0.00313 ** FLR_DST -0.05759 0.22076 -0.261 0.79448 VIEW_FLOOR 0.45467 6.53511 0.070 0.94460 VIEW_DIST -0.12025 3.53146 -0.034 0.97287 VIEW_FLOORSQ -0.36807 0.64693 -0.569 0.57004 VIEW_DISTSQ 0.16893 0.20515 0.823 0.41127 VIEW_FLR_DST -0.36150 0.29795 -1.213 0.22649 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 21.34 on 195 degrees of freedom Multiple R-squared: 0.6282, Adjusted R-squared: 0.6034 F-statistic: 25.34 on 13 and 195 DF, p-value: < 2.2e-16 Analysis of Variance Table Response: PRICE100 Df Sum Sq Mean Sq F value Pr(>F) FLOOR 1 14149 14149 31.0618 8.236e-08 *** DIST 1 21208 21208 46.5570 1.094e-10 *** VIEW 1 75065 75065 164.7890 < 2.2e-16 *** END 1 731 731 1.6044 0.2067937 FURNISH 1 6938 6938 15.2311 0.0001309 *** FLOORSQ 1 3640 3640 7.9905 0.0051925 ** DISTSQ 1 15503 15503 34.0327 2.223e-08 *** FLR_DST 1 1496 1496 3.2843 0.0714816 . VIEW_FLOOR 1 9411 9411 20.6603 9.609e-06 *** VIEW_DIST 1 721 721 1.5837 0.2097325 VIEW_FLOORSQ 1 148 148 0.3246 0.5694917 VIEW_DISTSQ 1 385 385 0.8449 0.3591478 VIEW_FLR_DST 1 671 671 1.4721 0.2264867 Residuals 195 88827 456 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Analysis of Variance Table Model 1: PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH + FLOORSQ + DISTSQ + FLR_DST + VIEW_FLOOR + VIEW_DIST + VIEW_FLOORSQ + VIEW_DISTSQ + VIEW_FLR_DST Model 2: PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH + FLOORSQ + DISTSQ + FLR_DST Res.Df RSS Df Sum of Sq F Pr(>F) 1 195 88827 2 200 100163 -5 -11336 4.9771 0.0002592 *** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Call: lm(formula = PRICE100 ~ FLOOR_FACT + DIST + DISTSQ + FLOOR_FACT * DIST + VIEW + END + FURNISH + FLOOR_FACT * VIEW + VIEW_DIST + VIEW_DISTSQ + FLOOR_FACT * DISTSQ + FLOOR_FACT * VIEW_DIST, data = condo) Residuals: Min 1Q Median 3Q Max -64.309 -9.576 -0.560 8.875 56.783 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 200.70667 19.45680 10.316 < 2e-16 *** FLOOR_FACT2 -35.39732 23.91717 -1.480 0.14077 FLOOR_FACT3 -26.03362 22.46849 -1.159 0.24825 FLOOR_FACT4 8.94047 22.54130 0.397 0.69215 FLOOR_FACT5 -59.31226 23.02907 -2.576 0.01088 * FLOOR_FACT6 6.10380 21.98284 0.278 0.78162 FLOOR_FACT7 -17.54228 23.93456 -0.733 0.46464 FLOOR_FACT8 -16.96107 23.69552 -0.716 0.47513 DIST -4.43757 5.06817 -0.876 0.38253 DISTSQ 0.37138 0.29795 1.246 0.21435 VIEW 44.66751 19.00038 2.351 0.01990 * END 8.18408 3.34744 2.445 0.01554 * FURNISH -21.38413 8.05673 -2.654 0.00872 ** VIEW_DIST -1.44658 3.57865 -0.404 0.68657 VIEW_DISTSQ 0.20036 0.19357 1.035 0.30213 FLOOR_FACT2:DIST 1.33621 6.38269 0.209 0.83443 FLOOR_FACT3:DIST 3.30362 5.89416 0.560 0.57590 FLOOR_FACT4:DIST -10.57122 5.90544 -1.790 0.07526 . FLOOR_FACT5:DIST 11.76381 5.96142 1.973 0.05012 . FLOOR_FACT6:DIST -9.32484 6.05939 -1.539 0.12573 FLOOR_FACT7:DIST -1.64581 6.29792 -0.261 0.79417 FLOOR_FACT8:DIST -0.61209 6.16791 -0.099 0.92107 FLOOR_FACT2:VIEW 13.48029 23.68280 0.569 0.56999 FLOOR_FACT3:VIEW -13.61012 22.65989 -0.601 0.54891 FLOOR_FACT4:VIEW -2.56399 22.23919 -0.115 0.90835 FLOOR_FACT5:VIEW 8.02452 22.69195 0.354 0.72407 FLOOR_FACT6:VIEW -3.84066 23.76993 -0.162 0.87184 FLOOR_FACT7:VIEW -6.77214 24.52607 -0.276 0.78280 FLOOR_FACT8:VIEW -12.84423 22.80921 -0.563 0.57412 FLOOR_FACT2:DISTSQ 0.05163 0.38544 0.134 0.89361 FLOOR_FACT3:DISTSQ -0.28417 0.35599 -0.798 0.42586 FLOOR_FACT4:DISTSQ 0.69205 0.36211 1.911 0.05771 . FLOOR_FACT5:DISTSQ -0.75560 0.36726 -2.057 0.04121 * FLOOR_FACT6:DISTSQ 0.61952 0.38192 1.622 0.10668 FLOOR_FACT7:DISTSQ 0.10362 0.40641 0.255 0.79907 FLOOR_FACT8:DISTSQ 0.10693 0.37258 0.287 0.77447 FLOOR_FACT2:VIEW_DIST -1.76526 2.49842 -0.707 0.48084 FLOOR_FACT3:VIEW_DIST 3.48902 2.39670 1.456 0.14735 FLOOR_FACT4:VIEW_DIST -0.39212 2.48675 -0.158 0.87490 FLOOR_FACT5:VIEW_DIST -3.65756 2.47040 -1.481 0.14062 FLOOR_FACT6:VIEW_DIST -3.00974 2.64864 -1.136 0.25745 FLOOR_FACT7:VIEW_DIST -1.54777 2.87626 -0.538 0.59122 FLOOR_FACT8:VIEW_DIST -2.32693 2.48226 -0.937 0.34990 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 19.35 on 166 degrees of freedom Multiple R-squared: 0.7398, Adjusted R-squared: 0.674 F-statistic: 11.24 on 42 and 166 DF, p-value: < 2.2e-16 Analysis of Variance Table Response: PRICE100 Df Sum Sq Mean Sq F value Pr(>F) FLOOR_FACT 7 23576 3368 8.9958 2.181e-09 *** DIST 1 21085 21085 56.3181 3.566e-12 *** DISTSQ 1 23499 23499 62.7663 3.198e-13 *** VIEW 1 70079 70079 187.1787 < 2.2e-16 *** END 1 3989 3989 10.6535 0.0013341 ** FURNISH 1 2693 2693 7.1927 0.0080597 ** VIEW_DIST 1 581 581 1.5517 0.2146351 VIEW_DISTSQ 1 531 531 1.4179 0.2354458 FLOOR_FACT:DIST 7 4875 696 1.8600 0.0791923 . FLOOR_FACT:VIEW 7 11454 1636 4.3704 0.0001789 *** FLOOR_FACT:DISTSQ 7 9551 1364 3.6445 0.0011017 ** FLOOR_FACT:VIEW_DIST 7 4830 690 1.8428 0.0822479 . Residuals 166 62150 374 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Analysis of Variance Table Model 1: PRICE100 ~ FLOOR_FACT + DIST + DISTSQ + FLOOR_FACT * DIST + VIEW + END + FURNISH + FLOOR_FACT * VIEW + VIEW_DIST + VIEW_DISTSQ + FLOOR_FACT * DISTSQ + FLOOR_FACT * VIEW_DIST Model 2: PRICE100 ~ FLOOR + DIST + VIEW + END + FURNISH + FLOORSQ + DISTSQ + FLR_DST + VIEW_FLOOR + VIEW_DIST + VIEW_FLOORSQ + VIEW_DISTSQ + VIEW_FLR_DST Res.Df RSS Df Sum of Sq F Pr(>F) 1 166 62150 2 195 88827 -29 -26677 2.457 0.0001976 *** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1