Descriptive and Inferential Statistics Applications Presentation

profilett2vtfjy
realestatedata-1_1.xls

Data

No. Price LotSize SqrFt Bedrooms Bathrooms Pool? Basement? Distance Rating SubDiv
1 480.1 1.72 3985 5 4 1/2 1 1 17.0 6 5
2 397.8 0.77 3564 4 4 1 0 12.6 6 4 subdivision names
3 307.4 0.46 2914 3 3 0 1 8.5 6 3 Burbsville 1
4 413.0 1.56 3413 4 3 1/2 0 0 18.4 4 1 Englewood 2
5 389.3 0.50 3627 4 2 1/2 0 0 17.5 1 4 Briar Hills 3
6 353.3 1.21 3727 3 3 1/2 0 1 17.6 4 2 Lone Tree 4
7 331.0 0.38 2304 4 2 1/2 0 0 16.4 4 4 Stanton 5
8 381.2 0.55 3103 4 3 1/2 1 1 18.4 6 4
9 422.5 1.57 3859 4 5 1 0 17.9 4 5
10 427.3 0.78 4318 4 5 1 1 16.1 7 5
11 380.6 0.47 2931 4 3 1/2 1 1 12.8 2 4
12 439.6 1.43 3926 4 5 0 0 20.0 5 5
13 249.8 0.30 2206 3 1 1/2 1 0 21.2 4 1
14 248.0 0.72 2401 3 2 1/2 0 1 12.1 5 3
15 337.3 0.61 3152 3 4 0 0 5.9 6 3
16 376.5 0.38 2863 4 2 1/2 0 0 19.2 7 4
17 320.4 0.57 2683 3 3 1 0 7.2 6 3 East 2 4 5
18 341.8 0.61 3468 3 4 0 0 8.7 7 3 West 1 3
19 339.3 1.75 3159 3 4 0 0 13.6 5 2
20 455.9 0.81 4390 5 3 1 0 21.6 5 5
21 273.7 0.33 2425 3 2 0 0 16.1 6 2
22 283.8 0.57 2259 3 2 1/2 0 0 13.6 5 2
23 381.4 0.52 2718 4 3 0 0 10.3 3 4
24 382.8 0.50 3032 4 3 1/2 1 1 16.9 2 4
25 419.6 2.17 4447 4 4 1/2 1 1 20.5 5 5
26 275.8 0.31 2100 3 2 1/2 0 1 14.4 2 2
27 336.8 0.52 3294 3 3 1/2 0 1 16.0 5 2
28 339.2 0.94 3393 3 3 1/2 0 0 12.9 3 2
29 391.4 0.99 3376 4 4 1/2 1 1 17.4 2 4
30 387.0 0.44 4391 4 4 0 0 8.5 5 3
31 412.9 0.93 3588 4 4 1 0 16.6 4 4
32 290.7 0.47 2419 3 2 1/2 1 1 12.0 4 2
33 306.8 0.56 2710 3 3 1 0 5.7 6 3
34 343.0 0.76 3312 3 4 1 1 14.9 7 2
35 452.2 1.31 3799 4 4 1/2 1 1 19.0 2 5
36 224.7 0.34 2362 2 2 1/2 0 0 18.5 2 1
37 271.6 0.31 2800 3 2 0 0 17.1 5 2
38 407.4 0.70 3495 4 4 1 0 18.6 6 4
39 278.0 0.29 2239 3 2 1/2 0 1 15.0 3 2
40 350.6 0.77 3757 3 3 1/2 0 0 10.6 6 2
41 328.4 0.66 2617 3 3 0 1 8.4 6 3
42 330.9 0.66 2636 3 2 1/2 1 1 10.3 3 2
43 401.8 0.66 3107 4 4 1 1 15.1 5 4
44 235.0 0.30 2288 3 1 1/2 0 1 20.0 3 1
45 357.9 0.51 2773 4 2 0 0 15.0 4 2
46 353.7 0.49 3043 4 3 1 1 17.0 4 2
47 475.7 1.47 3866 5 4 1 1 20.8 5 5
48 257.7 0.26 2573 3 1 1/2 0 1 17.8 4 1
49 283.0 0.63 2166 3 2 1/2 0 0 23.8 3 1
50 399.2 0.69 3434 4 4 1/2 1 1 18.1 3 4
51 245.0 0.39 2335 3 2 1/2 1 1 17.7 2 4
52 192.9 0.32 2515 2 2 0 0 20.8 2 1
53 258.4 0.77 2156 3 2 0 0 14.6 2 2
54 298.1 0.43 2835 3 2 1/2 1 0 14.1 2 2
55 298.3 0.28 2080 3 2 1 1 8.9 2 2
56 227.0 0.46 2805 2 3 1/2 1 0 22.0 2 1
57 224.1 0.40 2407 2 2 1/2 1 1 19.4 4 1
58 262.0 0.32 2266 2 2 0 0 19.7 3 1
59 433.8 0.83 4637 4 4 1/2 1 0 19.6 3 5
60 333.3 0.53 2945 3 3 1/2 0 0 7.2 5 3
61 346.2 1.76 3894 3 3 1/2 0 0 15.5 2 2
62 300.2 0.34 2484 3 2 1/2 0 0 13.5 5 2
63 347.4 0.58 3053 3 3 1/2 0 1 6.9 6 3
64 299.7 0.41 2138 3 2 1/2 1 0 10.5 1 2
65 407.0 0.76 3429 4 3 1/2 1 0 11.3 7 4
66 272.3 0.71 3160 3 2 1 0 14.6 3 2
67 380.9 0.57 2822 4 2 1/2 0 1 11.9 5 4
68 414.9 1.27 3698 4 4 1 1 18.7 7 5
69 354.6 0.49 3137 3 3 1/2 1 0 15.3 3 2
70 415.1 1.45 3674 4 4 1 0 20.9 3 5
71 381.6 0.68 3221 4 4 1 0 13.1 4 4
72 452.3 0.91 4080 5 4 1 1 19.7 5 5
73 296.7 0.45 2686 3 3 0 1 16.9 3 2
74 451.4 1.16 3766 5 5 1 1 17.0 6 5
75 280.1 0.39 3273 3 2 1/2 1 0 14.4 6 2
76 248.2 0.30 2920 3 2 0 0 14.8 4 2
77 411.4 0.94 3932 4 4 0 1 13.9 2 4
78 314.4 0.50 2771 3 3 0 0 10.5 6 3
79 500.0 1.55 4648 4 5 1 0 19.4 7 5
80 316.8 0.57 2766 3 3 0 0 6.6 7 3
81 406.8 0.69 3470 4 4 1 1 15.9 1 4
82 267.7 0.60 2156 3 3 1 1 14.8 3 2
83 247.5 0.40 2508 3 2 1/2 0 0 15.0 2 4
84 345.5 0.68 3504 3 4 0 1 11.4 3 2
85 207.8 0.56 2500 2 2 1/2 0 0 21.5 3 1
86 338.6 0.58 3176 3 4 1 0 6.6 6 3
87 276.5 0.35 2201 3 2 0 0 9.4 3 2
88 368.6 0.42 3269 4 2 1/2 0 1 12.2 5 3
89 309.7 0.69 2900 3 3 1/2 1 0 7.8 7 3
90 297.7 0.43 2774 3 2 1/2 1 1 16.6 1 2
91 350.7 0.62 3749 3 4 0 0 18.0 6 2
92 511.0 2.18 4756 6 5 1 1 19.0 4 5
93 460.2 0.87 4247 5 5 1 1 18.3 5 5
94 411.7 1.02 3666 4 4 1 1 15.8 5 4
95 383.3 0.49 2938 4 3 1 0 20.2 6 4
96 392.3 0.62 3264 4 4 1/2 1 0 16.6 3 4
97 450.9 0.65 3567 5 4 1 1 18.2 6 5
98 341.6 1.17 3201 3 3 0 1 14.1 2 2
99 379.1 0.56 2716 4 3 0 1 11.7 7 4
100 197.8 0.39 2434 2 2 0 0 20.0 3 1
101 390.3 0.69 3470 4 4 1/2 1 1 18.1 3 4
102 349.6 0.59 3113 3 3 1/2 0 0 6.1 6 3
103 296.2 0.55 2712 3 3 1 0 5.9 6 3
104 390.2 1.01 3430 4 4 1/2 1 1 17.2 2 4
105 348.8 1.16 3626 3 3 1/2 0 1 17.7 4 2
106 386.8 0.47 2968 4 3 1/2 1 1 13.0 2 4
107 475.5 1.47 3809 5 4 1 1 21.6 6 5
108 385.3 0.69 3252 4 4 1 0 12.6 4 4
109 263.6 0.26 2581 3 1 1/2 0 1 18.0 4 1
110 200.5 0.54 2467 2 2 1/2 0 0 21.3 3 1
111 202.5 0.39 2491 2 2 0 0 19.6 3 1
112 341.4 1.18 3128 3 3 1/2 0 1 14.6 2 2
113 452.4 1.43 3872 4 5 0 0 19.8 5 5
114 332.0 0.59 3464 3 4 0 0 8.7 7 3
115 430.8 1.41 3718 4 4 1 0 20.9 3 5
116 421.6 0.79 4320 4 5 1 1 15.5 7 5
117 429.5 0.82 4689 4 4 1/2 1 0 19.2 3 5
118 283.2 0.40 3153 3 2 1/2 1 0 14.0 6 2
119 328.1 0.66 2608 3 3 0 1 8.7 5 3
120 405.6 0.91 3708 4 4 1/2 0 1 16.8 4 4
121 277.0 0.30 2250 3 3 0 1 15.0 3 2
122 456.0 1.17 3847 5 5 1 1 16.7 6 5
123 239.9 0.30 2330 3 1 1/2 0 1 20.5 3 1
124 457.3 0.84 4215 5 5 0 0 18.2 5 5
Specification range for SubDiv variable
Specification range for SubDiv variable showing East vs. West

Variable_Description

No. sequential identification number
Price in thousands
LotSize in acres
SqrFt size of the house
Bedrooms
Bathrooms
Pool? O = no, 1 = yes
Basement? O = no, 1 = yes
Distance distance from center of the city
Rating seven point scale of a person’s rating of how nice a house is after looking at it
SubDiv which subdivsion the house is in; coded 1 - 5

Correlation_Matrix

Correlation Matrix
Price LotSize SqrFt Bedrooms Bathrooms Pool? Basement? Distance Rating SubDiv
Price 1.000 0.664622317568956 0.8321478035025601 0.9011046139469645 0.8202581478565485 0.4096856021176102 0.19028819101490435 0.127811333086359 0.2881367176195742 0.8574688713519764
LotSize .665 1.000 0.6841169448822189 0.5171517340484824 0.6661528683149581 0.22119280945383965 0.10938449743925856 0.2656673191012941 0.11566825787392691 0.509847287127859
SqrFt .832 .684 1.000 0.6780453432395144 0.8185431007906867 0.3239256146601635 0.05500059315426389 0.21764004818251506 0.27553630361045905 0.6929683351915664
Bedrooms .901 .517 .678 1.000 0.6306934532753624 0.4253560621075338 0.25789275454398747 0.20904598321065185 0.22158979699590242 0.8385329280007882
Bathrooms .820 .666 .819 .631 1.000 0.39134052992063795 0.13643218807843585 0.07447961696527348 0.2695936273929283 0.7444844229898983
Pool? .410 .221 .324 .425 .391 1.000 0.1616270459588089 0.15267203403239932 0.03330653273485757 0.46165757706962507
Basement? .190 .109 .055 .258 .136 .162 1.000 0.08128690730639897 -0.09120740693599376 0.15369030100786443
Distance .128 .266 .218 .209 .074 .153 .081 1.000 -0.2874939508021518 0.08976709137566194
Rating .288 .116 .276 .222 .270 .033 -.091 -.287 1.000 0.2826199335839874
SubDiv .857 .510 .693 .839 .744 .462 .154 .090 .283 1.000
124 sample size
± .176 critical value .05 (two-tail)
± .231 critical value .01 (two-tail)

Regression_Output

Regression Analysis
0.937
Adjusted R² 0.933 n 124
R 0.968 k 8
Std. Error of Estimate 19.251 Dep. Var. Price
Regression output confidence interval
variables coefficients std. error t (df=115) p-value 95% lower 95% upper std. coeff. VIF
Intercept a = 31.289 11.68471561230264 2.6777422352079405 0.00849694374551067 8.14349351866829 54.433819484244495 0.000
LotSize b1 = 16.574 6.208 2.670 .0087 4.277 28.871 0.092 2.150
SqrFt b2 = 0.021 0.005 3.978 .0001 0.011 0.032 0.191 4.185
Bedrooms b3 = 56.493 3.343 16.899 6.01E-33 49.871 63.114 0.595 2.259
Bathrooms b4 = 18.073 3.513 5.145 1.11E-06 11.114 25.031 0.235 3.791
Pool? b5 = -0.652 3.956 -0.165 .8695 -8.487 7.184 -0.004 1.309
Basement? b6 = -1.186 3.703 -0.320 .7493 -8.522 6.149 -0.008 1.142
Distance b7 = -1.305 0.463 -2.820 .0057 -2.222 -0.389 -0.076 1.337
Rating b8 = 0.324 1.159 0.280 .7801 -1.972 2.621 0.007 1.292
2.183
mean VIF
ANOVA table
Source SS df MS F p-value
Regression 633,273.642 8 79,159.205 213.59 2.80E-65
Residual 42,620.077 115 370.609
Total 675,893.719 123
Studentized
Studentized Deleted
Observation Price Predicted Total = Residual + Regression Leverage Residual Residual Cook's D
1 480.10 485.99 132.70 -5.89 138.59 0.085 -0.320 -0.319 0.001
2 397.80 402.72 50.40 -4.92 55.32 0.037 -0.260 -0.259 0.000
3 307.40 314.05 -40.00 -6.65 -33.35 0.057 -0.356 -0.355 0.001
4 413.00 396.01 65.60 16.99 48.61 0.089 0.924 0.924 0.009
5 389.30 365.11 41.90 24.19 17.70 0.137 1.353 1.358 0.032
6 353.30 340.23 5.90 13.07 -7.17 0.076 0.706 0.705 0.005
7 331.00 337.48 -16.40 -6.48 -9.93 0.093 -0.353 -0.352 0.001
8 381.20 371.51 33.80 9.69 24.10 0.053 0.517 0.516 0.002
9 422.50 432.74 75.10 -10.24 85.34 0.074 -0.553 -0.551 0.003
10 427.30 431.52 79.90 -4.22 84.11 0.091 -0.230 -0.229 0.001
11 380.60 372.55 33.20 8.05 25.14 0.060 0.431 0.430 0.001
12 439.60 430.08 92.20 9.52 82.67 0.091 0.519 0.517 0.003
13 249.80 252.59 -97.60 -2.79 -94.81 0.096 -0.152 -0.152 0.000
14 248.00 293.43 -99.40 -45.43 -53.98 0.051 -2.423 -2.476 0.035
15 337.30 344.24 -10.10 -6.94 -3.16 0.071 -0.374 -0.373 0.001
16 376.50 346.65 29.10 29.85 -0.76 0.103 1.637 1.649 0.034
17 320.40 313.21 -27.00 7.19 -34.19 0.070 0.387 0.386 0.001
18 341.80 347.61 -5.60 -5.81 0.21 0.065 -0.312 -0.311 0.001
19 339.30 352.91 -8.10 -13.61 5.50 0.135 -0.760 -0.759 0.010
20 455.90 447.24 108.50 8.66 99.84 0.161 0.491 0.489 0.005
21 273.70 274.73 -73.70 -1.03 -72.68 0.054 -0.055 -0.055 0.000
22 283.80 287.16 -63.60 -3.36 -60.24 0.047 -0.179 -0.178 0.000
23 381.40 365.25 34.00 16.15 17.85 0.085 0.877 0.876 0.008
24 382.80 369.83 35.40 12.97 22.43 0.048 0.690 0.689 0.003
25 419.60 441.86 72.20 -22.26 94.46 0.161 -1.262 -1.265 0.034
26 275.80 276.27 -71.60 -0.47 -71.13 0.058 -0.025 -0.025 0.000
27 336.80 322.03 -10.60 14.77 -25.38 0.055 0.789 0.788 0.004
28 339.20 335.67 -8.20 3.53 -11.73 0.045 0.188 0.187 0.000
29 391.40 402.67 44.00 -11.27 55.27 0.056 -0.602 -0.601 0.002
30 387.00 420.47 39.60 -33.47 73.06 0.152 -1.888 -1.909 0.071
31 412.90 400.01 65.50 12.89 52.61 0.030 0.680 0.678 0.002
32 290.70 288.82 -56.70 1.88 -58.58 0.051 0.100 0.100 0.000
33 306.80 315.58 -40.60 -8.78 -31.83 0.081 -0.476 -0.474 0.002
34 343.00 336.86 -4.40 6.14 -10.55 0.084 0.334 0.332 0.001
35 452.20 414.85 104.80 37.35 67.45 0.054 1.994 2.021 0.025
36 224.70 221.67 -122.70 3.03 -125.73 0.062 0.163 0.162 0.000
37 271.60 280.71 -75.80 -9.11 -66.69 0.047 -0.485 -0.483 0.001
38 407.40 392.27 60.00 15.13 44.86 0.049 0.806 0.805 0.004
39 278.00 278.43 -69.40 -0.43 -68.97 0.045 -0.023 -0.023 0.000
40 350.60 344.55 3.20 6.05 -2.86 0.062 0.325 0.323 0.001
41 328.40 311.20 -19.00 17.20 -36.20 0.060 0.921 0.921 0.006
42 330.90 298.46 -16.50 32.44 -48.94 0.071 1.749 1.764 0.026
43 401.80 386.44 54.40 15.36 39.03 0.038 0.814 0.813 0.003
44 235.00 255.04 -112.40 -20.04 -92.37 0.068 -1.078 -1.079 0.009
45 357.90 342.37 10.50 15.53 -5.04 0.077 0.840 0.839 0.007
46 353.70 361.38 6.30 -7.68 13.98 0.036 -0.407 -0.405 0.001
47 475.70 465.00 128.30 10.70 117.60 0.070 0.576 0.574 0.003
48 257.70 263.66 -89.70 -5.96 -83.74 0.073 -0.322 -0.321 0.001
49 283.00 272.22 -64.40 10.78 -75.19 0.105 0.592 0.590 0.005
50 399.20 398.34 51.80 0.86 50.93 0.055 0.046 0.046 0.000
51 245.00 277.62 -102.40 -32.62 -69.78 0.053 -1.741 -1.757 0.019
52 192.90 212.54 -154.50 -19.64 -134.86 0.069 -1.057 -1.058 0.009
53 258.40 276.98 -89.00 -18.58 -70.43 0.073 -1.002 -1.002 0.009
54 298.10 294.77 -49.30 3.33 -52.63 0.059 0.178 0.177 0.000
55 298.30 272.91 -49.10 25.39 -74.49 0.094 1.386 1.391 0.022
56 227.00 245.90 -120.40 -18.90 -101.50 0.133 -1.054 -1.055 0.019
57 224.10 221.25 -123.30 2.85 -126.15 0.110 0.157 0.156 0.000
58 262.00 209.02 -85.40 52.98 -138.38 0.058 2.836 2.928 0.055
59 433.80 425.39 86.40 8.41 77.99 0.109 0.463 0.461 0.003
60 333.30 327.47 -14.10 5.83 -19.94 0.051 0.311 0.310 0.001
61 346.20 356.17 -1.20 -9.97 8.76 0.155 -0.563 -0.562 0.006
62 300.20 288.25 -47.20 11.95 -59.16 0.032 0.631 0.629 0.001
63 347.40 330.12 -0.00 17.28 -17.29 0.067 0.930 0.929 0.007
64 299.70 284.08 -47.70 15.62 -63.32 0.103 0.857 0.856 0.009
65 407.00 392.68 59.60 14.32 45.28 0.054 0.765 0.763 0.004
66 272.30 296.94 -75.10 -24.64 -50.46 0.103 -1.352 -1.357 0.023
67 380.90 356.62 33.50 24.28 9.22 0.061 1.302 1.306 0.012
68 414.90 405.03 67.50 9.87 57.62 0.071 0.532 0.530 0.002
69 354.60 319.00 7.20 35.60 -28.40 0.044 1.892 1.913 0.019
70 415.10 404.52 67.70 10.58 57.11 0.064 0.568 0.567 0.002
71 381.60 392.66 34.20 -11.06 45.25 0.046 -0.588 -0.586 0.002
72 452.30 461.70 104.90 -9.40 114.29 0.059 -0.503 -0.501 0.002
73 296.70 297.12 -50.70 -0.42 -50.29 0.041 -0.022 -0.022 0.000
74 451.40 481.10 104.00 -29.70 133.70 0.065 -1.596 -1.607 0.020
75 280.10 304.30 -67.30 -24.20 -43.10 0.079 -1.310 -1.314 0.016
76 248.20 285.77 -99.20 -37.57 -61.63 0.047 -1.999 -2.026 0.022
77 411.40 409.83 64.00 1.57 62.42 0.087 0.086 0.085 0.000
78 314.40 310.26 -33.00 4.14 -37.14 0.035 0.219 0.218 0.000
79 500.00 448.15 152.60 51.85 100.75 0.092 2.827 2.918 0.090
80 316.80 316.73 -30.60 0.07 -30.67 0.061 0.004 0.004 0.000
81 406.80 392.29 59.40 14.51 44.88 0.069 0.781 0.780 0.005
82 267.70 290.46 -79.70 -22.76 -56.95 0.067 -1.224 -1.226 0.012
83 247.50 286.82 -99.90 -39.32 -60.58 0.042 -2.087 -2.118 0.021
84 345.50 343.52 -1.90 1.98 -3.88 0.076 0.107 0.106 0.000
85 207.80 224.65 -139.60 -16.85 -122.75 0.073 -0.909 -0.909 0.007
86 338.60 342.70 -8.80 -4.10 -4.70 0.075 -0.221 -0.220 0.000
87 276.50 278.08 -70.90 -1.58 -69.32 0.059 -0.085 -0.084 0.000
88 368.60 363.22 21.20 5.38 15.82 0.079 0.291 0.290 0.001
89 309.70 328.38 -37.70 -18.68 -19.02 0.076 -1.009 -1.009 0.009
90 297.70 288.71 -49.70 8.99 -58.70 0.067 0.484 0.482 0.002
91 350.70 341.27 3.30 9.43 -6.14 0.076 0.510 0.508 0.002
92 511.00 572.23 163.60 -61.23 224.83 0.166 -3.482 -3.666 0.268
93 460.20 484.47 112.80 -24.27 137.07 0.064 -1.303 -1.307 0.013
94 411.70 403.34 64.30 8.36 55.94 0.028 0.440 0.439 0.001
95 383.30 356.82 35.90 26.48 9.41 0.076 1.431 1.438 0.019
96 392.30 396.72 44.90 -4.42 49.31 0.080 -0.239 -0.238 0.001
97 450.90 448.79 103.50 2.11 101.39 0.069 0.113 0.113 0.000
98 341.60 323.30 -5.80 18.30 -24.10 0.078 0.990 0.990 0.009
99 379.10 364.15 31.70 14.95 16.75 0.077 0.808 0.807 0.006
100 197.80 213.35 -149.60 -15.55 -134.05 0.059 -0.833 -0.832 0.005
101 390.30 399.10 42.90 -8.80 51.70 0.054 -0.470 -0.468 0.001
102 349.60 333.78 2.20 15.82 -13.62 0.057 0.846 0.845 0.005
103 296.20 315.19 -51.20 -18.99 -32.21 0.079 -1.028 -1.028 0.010
104 390.20 404.41 42.80 -14.21 57.00 0.054 -0.759 -0.757 0.004
105 348.80 337.13 1.40 11.67 -10.27 0.067 0.627 0.626 0.003
106 386.80 373.07 39.40 13.73 25.67 0.059 0.735 0.734 0.004
107 475.50 463.08 128.10 12.42 115.67 0.085 0.675 0.673 0.005
108 385.30 394.13 37.90 -8.83 46.73 0.045 -0.470 -0.468 0.001
109 263.60 263.52 -83.80 0.08 -83.88 0.074 0.004 0.004 0.000
110 200.50 223.88 -146.90 -23.38 -123.52 0.073 -1.261 -1.264 0.014
111 202.50 215.08 -144.90 -12.58 -132.32 0.058 -0.673 -0.672 0.003
112 341.40 330.30 -6.00 11.10 -17.10 0.068 0.597 0.596 0.003
113 452.40 429.19 105.00 23.21 81.79 0.093 1.266 1.269 0.018
114 332.00 347.19 -15.40 -15.19 -0.21 0.066 -0.817 -0.815 0.005
115 430.80 404.79 83.40 26.01 57.38 0.060 1.394 1.400 0.014
116 421.60 432.51 74.20 -10.91 85.10 0.088 -0.593 -0.592 0.004
117 429.50 426.85 82.10 2.65 79.45 0.117 0.146 0.146 0.000
118 283.20 302.45 -64.20 -19.25 -44.96 0.070 -1.037 -1.037 0.009
119 328.10 310.30 -19.30 17.80 -37.11 0.051 0.949 0.949 0.005
120 405.60 410.47 58.20 -4.87 63.06 0.058 -0.260 -0.259 0.000
121 277.00 287.87 -70.40 -10.87 -59.54 0.062 -0.583 -0.581 0.002
122 456.00 483.38 108.60 -27.38 135.98 0.060 -1.467 -1.474 0.015
123 239.90 255.27 -107.50 -15.37 -92.13 0.070 -0.828 -0.827 0.006
124 457.30 485.27 109.90 -27.97 137.86 0.127 -1.555 -1.564 0.039
0.00 0.00 0.00 Sum
675,893.72 42,620.08 633,273.64
SSTotal = SSE + SSR

All_Possible_Regressions

Regression Analysis -- All Possible Regressions
124 observations
Price is the dependent variable
p-values for the coefficients
Nvar LotSize SqrFt Bedrooms Bathrooms Pool? Basement? Distance Rating Adj R² s p-value
5 .0076 .0000 .0000 .0000 .0017 .934 .937 19.025 5.54E-69
6 .0076 .0001 .0000 .0000 .7136 .0019 .934 .937 19.095 1.02E-67
6 .0075 .0001 .0000 .0000 .0047 .7379 .934 .937 19.097 1.03E-67
6 .0087 .0000 .0000 .0000 .8418 .0021 .934 .937 19.103 1.07E-67
7 .0076 .0001 .0000 .0000 .7433 .0050 .7711 .933 .937 19.170 1.74E-66
7 .0087 .0001 .0000 .0000 .8553 .7212 .0023 .933 .937 19.175 1.78E-66
7 .0086 .0001 .0000 .0000 .8593 .0054 .7484 .933 .937 19.177 1.81E-66
8 .0087 .0001 .0000 .0000 .8695 .7493 .0057 .7801 .933 .937 19.251 2.80E-65
4 .0000 .0000 .0000 .0098 .931 .933 19.528 9.08E-69
5 .0000 .0000 .0000 .6323 .0122 .930 .933 19.592 1.76E-67
5 .0000 .0000 .0000 .7848 .0109 .930 .933 19.604 1.90E-67
5 .0000 .0000 .0000 .0199 .8584 .930 .933 19.608 1.94E-67
6 .0000 .0000 .0000 .6415 .8006 .0133 .930 .933 19.670 3.25E-66
6 .0000 .0000 .0000 .6407 .0228 .8809 .930 .933 19.673 3.32E-66
5 .0324 .0006 .0000 .0000 .1630 .930 .932 19.679 2.96E-67
6 .0000 .0000 .0000 .8011 .0207 .8845 .929 .933 19.686 3.58E-66
6 .0374 .0006 .0000 .0000 .6527 .1821 .929 .933 19.745 5.08E-66
6 .0323 .0009 .0000 .0000 .7148 .1843 .929 .932 19.751 5.26E-66
7 .0000 .0000 .0000 .6481 .8141 .0237 .9048 .929 .933 19.753 5.56E-65
4 .0488 .0003 .0000 .0000 .929 .931 19.759 3.66E-68
5 .0560 .0004 .0000 .0000 .5518 .929 .931 19.812 6.57E-67
5 .0469 .0006 .0000 .0000 .5821 .929 .931 19.817 6.74E-67
7 .0372 .0010 .0000 .0000 .6640 .7287 .2031 .929 .933 19.820 8.21E-65
6 .0538 .0007 .0000 .0000 .5722 .6046 .928 .932 19.874 1.08E-65
4 .0000 .0000 .0000 .2681 .927 .930 19.981 1.39E-67
3 .0000 .0000 .0000 .927 .929 20.001 1.03E-68
5 .0000 .0000 .0000 .5202 .2990 .927 .930 20.030 2.38E-66
4 .0000 .0000 .0000 .4561 .927 .929 20.038 1.94E-67
5 .0001 .0000 .0000 .7655 .2936 .927 .930 20.058 2.81E-66
4 .0000 .0000 .0000 .6519 .927 .929 20.068 2.32E-67
5 .0001 .0000 .0000 .4707 .6788 .926 .929 20.108 3.76E-66
6 .0001 .0000 .0000 .5286 .7837 .3235 .926 .930 20.109 4.28E-65
5 .0005 .0000 .0000 .2371 .0187 .925 .928 20.347 1.51E-65
6 .0004 .0000 .0000 .2996 .0511 .3990 .924 .928 20.371 1.94E-64
5 .0004 .0000 .0000 .0538 .3101 .924 .927 20.378 1.81E-65
4 .0004 .0000 .0000 .0171 .924 .927 20.382 1.47E-66
6 .0007 .0000 .0000 .6469 .2511 .0229 .924 .928 20.415 2.49E-64
5 .0006 .0000 .0000 .5960 .0215 .924 .927 20.443 2.64E-65
7 .0006 .0000 .0000 .6901 .3115 .0572 .4179 .924 .928 20.445 2.97E-63
6 .0006 .0000 .0000 .6522 .0606 .3307 .924 .928 20.447 3.00E-64
4 .0017 .0000 .0000 .0846 .923 .925 20.616 5.71E-66
5 .0018 .0000 .0000 .3257 .1206 .923 .926 20.618 7.20E-65
5 .0023 .0000 .0000 .5412 .1009 .922 .925 20.671 9.69E-65
6 .0025 .0000 .0000 .5730 .3413 .1387 .922 .926 20.678 1.11E-63
4 .0031 .0000 .0000 .2179 .922 .924 20.743 1.19E-65
5 .0041 .0000 .0000 .4713 .2380 .921 .925 20.785 1.86E-64
3 .0030 .0000 .0000 .921 .923 20.789 1.06E-66
4 .0041 .0000 .0000 .4249 .921 .924 20.821 1.84E-65
4 .0001 .0000 .0000 .0000 .919 .922 21.085 8.26E-65
5 .0001 .0000 .0000 .3551 .0000 .919 .922 21.097 1.07E-63
5 .0001 .0000 .0000 .0002 .7238 .918 .922 21.163 1.55E-63
5 .0001 .0000 .0000 .8416 .0000 .918 .922 21.170 1.62E-63
6 .0001 .0000 .0000 .3448 .0002 .6812 .918 .922 21.172 1.74E-62
6 .0001 .0000 .0000 .3633 .8919 .0000 .918 .922 21.185 1.88E-62
6 .0001 .0000 .0000 .8079 .0002 .7050 .918 .922 21.248 2.64E-62
7 .0001 .0000 .0000 .3536 .8538 .0002 .6689 .918 .922 21.260 2.73E-61
4 .0000 .0000 .2310 .1606 .917 .920 21.347 3.58E-64
5 .0000 .0000 .3774 .2553 .1862 .917 .920 21.366 4.78E-63
5 .0000 .0000 .2861 .2888 .4537 .917 .920 21.386 5.33E-63
3 .0000 .0000 .1521 .917 .919 21.387 3.18E-65
4 .0000 .0000 .3387 .1789 .917 .919 21.394 4.65E-64
4 .0000 .0000 .3000 .2368 .917 .919 21.398 4.77E-64
4 .0000 .0000 .3028 .3556 .917 .919 21.399 4.80E-64
3 .0000 .0000 .1748 .917 .919 21.406 3.53E-65
6 .0000 .0000 .4056 .3080 .3123 .4904 .917 .921 21.414 6.55E-62
4 .0000 .0000 .3458 .2099 .917 .919 21.415 5.23E-64
5 .0000 .0000 .3732 .3230 .2738 .917 .920 21.416 6.30E-63
5 .0000 .0000 .3750 .3276 .3943 .917 .920 21.418 6.35E-63
3 .0000 .0000 .2187 .916 .918 21.435 4.16E-65
4 .0000 .0000 .3194 .2454 .916 .919 21.435 5.85E-64
3 .0000 .0000 .2830 .916 .918 21.467 4.99E-65
2 .0000 .0000 .916 .917 21.482 3.03E-66
4 .0012 .0000 .0000 .0775 .909 .912 22.333 7.67E-62
3 .0000 .0000 .0007 .909 .911 22.339 5.89E-63
5 .0011 .0000 .0000 .4650 .0694 .909 .913 22.377 1.10E-60
4 .0000 .0000 .4761 .0007 .909 .912 22.385 1.01E-61
4 .0000 .0000 .6652 .0007 .909 .912 22.415 1.18E-61
5 .0013 .0000 .0000 .7913 .0755 .909 .912 22.421 1.39E-60
4 .0000 .0000 .0021 .8979 .908 .911 22.431 1.29E-61
5 .0000 .0000 .4947 .7000 .0007 .908 .912 22.465 1.75E-60
6 .0012 .0000 .0000 .4761 .8266 .0686 .908 .913 22.467 1.78E-59
5 .0000 .0000 .4725 .0019 .8648 .908 .912 22.476 1.86E-60
5 .0000 .0000 .6526 .0021 .8553 .908 .912 22.506 2.18E-60
3 .0023 .0000 .0000 .908 .910 22.534 1.67E-62
6 .0000 .0000 .4900 .6840 .0020 .8281 .907 .912 22.556 2.82E-59
4 .0022 .0000 .0000 .5658 .907 .910 22.597 3.10E-61
4 .0024 .0000 .0000 .9674 .907 .910 22.628 3.65E-61
5 .0024 .0000 .0000 .5684 .9997 .906 .910 22.693 5.74E-60
3 .0000 .0000 .1736 .902 .904 23.251 7.13E-61
4 .0000 .0000 .5675 .1622 .901 .904 23.316 1.28E-59
4 .0000 .0000 .6596 .1609 .901 .904 23.329 1.37E-59
2 .0000 .0000 .901 .903 23.335 6.74E-62
5 .0000 .0000 .5861 .6848 .1520 .900 .904 23.398 2.11E-58
3 .0000 .0000 .6458 .900 .903 23.411 1.62E-60
3 .0000 .0000 .7978 .900 .903 23.425 1.75E-60
4 .0000 .0000 .6591 .8227 .899 .903 23.504 3.32E-59
5 .0000 .0000 .2155 .0102 .0716 .877 .882 25.992 4.95E-53
6 .0000 .0000 .2014 .3993 .0097 .0985 .877 .883 26.023 4.86E-52
4 .0000 .0000 .0123 .0812 .876 .881 26.052 6.75E-54
5 .0000 .0000 .4370 .0119 .1093 .876 .881 26.095 7.88E-53
5 .0000 .0000 .2273 .2711 .0009 .875 .880 26.218 1.37E-52
4 .0000 .0000 .2519 .0008 .875 .879 26.242 1.60E-53
4 .0000 .0000 .3022 .0012 .874 .878 26.270 1.82E-53
3 .0000 .0000 .0010 .874 .877 26.278 1.68E-54
4 .0000 .0000 .2801 .0050 .871 .875 26.619 8.70E-53
3 .0000 .0000 .0061 .871 .874 26.638 8.60E-54
5 .0000 .0000 .2653 .4485 .0079 .871 .876 26.666 1.01E-51
4 .0000 .0000 .4819 .0094 .870 .875 26.694 1.22E-52
3 .0000 .0000 .2701 .864 .867 27.350 2.02E-52
4 .0000 .0000 .3528 .2480 .864 .868 27.364 2.31E-51
2 .0000 .0000 .864 .866 27.375 1.66E-53
3 .0000 .0000 .3893 .863 .867 27.404 2.57E-52
2 .0000 .0202 .817 .820 31.690 8.17E-46
3 .0000 .3590 .0175 .817 .821 31.710 1.01E-44
3 .0000 .4056 .0586 .817 .821 31.730 1.09E-44
4 .0000 .3370 .3792 .0533 .817 .823 31.739 1.01E-43
3 .0000 .4439 .0298 .817 .821 31.744 1.15E-44
4 .0000 .3398 .4172 .0261 .817 .822 31.754 1.07E-43
5 .0000 .3173 .4020 .3662 .0751 .816 .824 31.778 8.94E-43
4 .0000 .4304 .3941 .0812 .816 .822 31.779 1.18E-43
3 .0000 .2859 .1222 .813 .818 32.055 3.69E-44
4 .0000 .3557 .2637 .1085 .813 .819 32.074 3.51E-43
2 .0000 .1150 .813 .816 32.075 3.52E-45
3 .0000 .3897 .1028 .812 .817 32.108 4.50E-44
2 .0000 .2687 .811 .814 32.243 6.63E-45
1 .0000 .810 .812 32.274 4.24E-46
3 .0000 .4196 .2501 .810 .815 32.289 8.81E-44
2 .0000 .4598 .810 .813 32.334 9.31E-45
6 .0684 .0000 .0003 .0355 .0244 .1024 .768 .780 35.682 4.17E-36
7 .0569 .0000 .0007 .0309 .0234 .5297 .1830 .767 .780 35.774 2.98E-35
6 .0670 .0000 .0006 .0346 .0313 .2585 .766 .777 35.895 8.32E-36
5 .1056 .0000 .0001 .0488 .0380 .765 .775 35.939 1.65E-36
5 .0000 .0000 .0516 .0199 .1616 .764 .773 36.040 2.29E-36
6 .0000 .0001 .0507 .0199 .8016 .2225 .762 .773 36.184 2.11E-35
4 .0000 .0000 .0644 .0297 .762 .769 36.189 5.72E-37
5 .1017 .0000 .0000 .0137 .1462 .761 .771 36.211 3.99E-36
5 .0000 .0000 .0548 .0262 .4699 .761 .770 36.261 4.70E-36
5 .0558 .0000 .0001 .0198 .1696 .760 .770 36.311 5.51E-36
6 .0958 .0000 .0001 .0134 .7285 .2125 .760 .771 36.346 3.54E-35
4 .1430 .0000 .0000 .0212 .759 .767 36.384 1.08E-36
6 .0487 .0000 .0003 .0177 .5987 .2654 .759 .770 36.422 4.51E-35
5 .1089 .0000 .0001 .0181 .4144 .758 .768 36.434 8.20E-36
4 .0818 .0000 .0001 .0271 .758 .766 36.449 1.34E-36
5 .0560 .0000 .0002 .0200 .3389 .758 .768 36.461 8.95E-36
4 .0000 .0000 .0116 .2095 .758 .766 36.471 1.44E-36
3 .0000 .0000 .0171 .757 .763 36.561 2.55E-37
5 .0000 .0000 .0121 .9730 .2473 .756 .766 36.626 1.52E-35
4 .0000 .0000 .0159 .6345 .755 .763 36.680 2.82E-36
4 .0000 .0000 .0297 .2652 .755 .763 36.725 3.27E-36
3 .0000 .0000 .0367 .754 .760 36.764 4.95E-37
4 .0000 .0000 .0330 .6050 .753 .761 36.876 5.31E-36
5 .0000 .0000 .0304 .8967 .3216 .753 .763 36.878 3.38E-35
4 .0867 .0000 .0000 .2531 .751 .759 37.004 7.99E-36
3 .1143 .0000 .0000 .750 .756 37.053 1.26E-36
5 .0866 .0000 .0000 .8380 .3183 .749 .759 37.153 8.09E-35
4 .0962 .0000 .0000 .5577 .749 .757 37.154 1.29E-35
2 .0000 .0000 .747 .751 37.286 2.87E-37
3 .0000 .0000 .3562 .747 .753 37.308 2.87E-36
3 .0000 .0000 .8265 .745 .751 37.434 4.29E-36
6 .0036 .0000 .0030 .0094 .1488 .1519 .745 .757 37.441 1.10E-33
4 .0000 .0000 .9017 .3676 .745 .753 37.462 3.43E-35
5 .0044 .0000 .0034 .0132 .0386 .743 .753 37.612 3.40E-34
5 .0062 .0000 .0041 .0101 .0393 .742 .753 37.617 3.46E-34
4 .0115 .0000 .0061 .0182 .735 .744 38.142 2.88E-34
5 .0022 .0000 .0010 .1666 .2342 .732 .743 38.376 3.58E-33
4 .0026 .0000 .0012 .0544 .731 .740 38.445 7.36E-34
4 .0037 .0000 .0014 .0738 .730 .739 38.527 9.46E-34
5 .0000 .0051 .0056 .3063 .2020 .728 .739 38.663 8.57E-33
4 .0000 .0061 .0060 .0780 .728 .737 38.673 1.48E-33
5 .0062 .0000 .0031 .2322 .1830 .727 .738 38.720 1.02E-32
4 .0000 .0056 .0077 .1124 .726 .735 38.768 1.98E-33
4 .0092 .0000 .0034 .0613 .726 .735 38.792 2.13E-33
4 .0073 .0000 .0044 .0758 .725 .734 38.849 2.53E-33
3 .0066 .0000 .0022 .725 .732 38.887 4.10E-34
3 .0000 .0082 .0104 .723 .730 39.019 6.14E-34
3 .0156 .0000 .0063 .720 .727 39.205 1.08E-33
3 .0000 .0020 .1105 .712 .719 39.751 5.67E-33
3 .0000 .0021 .1477 .712 .719 39.757 5.78E-33
4 .0000 .0017 .3504 .3142 .712 .721 39.777 4.13E-32
3 .0000 .0019 .1622 .712 .719 39.781 6.20E-33
5 .0006 .0000 .0330 .1238 .0370 .712 .723 39.797 2.51E-31
4 .0000 .0019 .4178 .2337 .712 .721 39.807 4.52E-32
3 .0000 .0026 .1823 .711 .718 39.879 8.33E-33
6 .0019 .0000 .0438 .1270 .4871 .0286 .711 .725 39.884 1.64E-30
2 .0000 .0028 .710 .714 39.941 1.18E-33
2 .0000 .0035 .709 .713 40.010 1.46E-33
4 .0038 .0000 .2729 .2982 .709 .718 40.015 8.37E-32
3 .0043 .0000 .1160 .708 .715 40.031 1.31E-32
4 .0006 .0000 .0215 .0570 .708 .718 40.031 8.77E-32
3 .0055 .0000 .1253 .708 .715 40.051 1.39E-32
5 .0019 .0000 .0295 .4770 .0432 .707 .719 40.114 6.34E-31
2 .0087 .0000 .705 .710 40.279 3.28E-33
4 .0013 .0000 .0498 .2026 .703 .713 40.370 2.38E-31
4 .0011 .0000 .0790 .0561 .703 .713 40.404 2.62E-31
5 .0040 .0000 .0839 .3332 .0350 .703 .715 40.413 1.51E-30
3 .0011 .0000 .0339 .702 .709 40.478 4.95E-32
5 .0022 .0000 .0542 .2058 .9675 .701 .713 40.540 2.18E-30
4 .0021 .0000 .0384 .9175 .699 .709 40.645 5.31E-31
4 .0042 .0000 .3132 .0567 .698 .708 40.758 7.36E-31
3 .0011 .0000 .0928 .698 .705 40.762 1.15E-31
3 .0021 .0000 .1330 .696 .704 40.859 1.52E-31
4 .0044 .0000 .1413 .7375 .694 .704 41.011 1.53E-30
2 .0019 .0000 .693 .698 41.076 3.51E-32
2 .0000 .2242 .691 .696 41.193 4.95E-32
3 .0045 .0000 .6644 .691 .698 41.215 4.29E-31
2 .0000 .2786 .690 .695 41.245 5.77E-32
1 .0000 .690 .692 41.277 4.98E-33
3 .0000 .4949 .3812 .690 .697 41.284 5.24E-31
5 .0000 .1000 .1287 .1082 .0342 .688 .701 41.387 2.44E-29
4 .0000 .0712 .1040 .0511 .685 .695 41.620 8.72E-30
4 .0000 .0684 .1238 .0888 .684 .694 41.668 1.00E-29
4 .0000 .0911 .0739 .0395 .684 .694 41.690 1.07E-29
3 .0000 .0469 .1302 .680 .688 41.911 3.18E-30
3 .0000 .0890 .1847 .679 .687 42.004 4.14E-30
4 .0000 .1181 .2047 .3238 .679 .689 42.007 2.61E-29
3 .0000 .0679 .0626 .679 .687 42.019 4.33E-30
3 .0000 .0837 .1165 .678 .686 42.079 5.13E-30
3 .0000 .0878 .2902 .677 .685 42.117 5.71E-30
2 .0000 .0625 .677 .682 42.139 7.72E-31
3 .0000 .1499 .2349 .675 .683 42.265 8.69E-30
2 .0000 .1271 .674 .679 42.339 1.37E-30
2 .0000 .1802 .672 .678 42.433 1.79E-30
2 .0000 .1976 .672 .677 42.457 1.92E-30
1 .0000 .670 .673 42.575 2.21E-31
4 .0000 .0001 .0860 .0004 .555 .569 49.451 5.85E-21
5 .0000 .0001 .0871 .8898 .0009 .551 .570 49.656 3.90E-20
3 .0000 .0000 .0007 .548 .559 49.861 3.24E-21
4 .0000 .0000 .8979 .0017 .544 .559 50.067 2.50E-20
4 .0000 .0001 .1841 .1998 .512 .527 51.809 1.39E-18
3 .0000 .0001 .2028 .509 .521 51.951 4.32E-19
3 .0000 .0000 .2205 .508 .520 51.978 4.59E-19
2 .0000 .0000 .506 .514 52.089 1.06E-19
3 .0000 .0292 .0006 .495 .507 52.697 2.36E-18
4 .0000 .0303 .7757 .0009 .491 .507 52.900 1.59E-17
2 .0000 .0014 .478 .487 53.533 2.91E-18
3 .0000 .7449 .0019 .475 .487 53.732 2.39E-17
2 .0000 .0803 .447 .456 55.139 1.04E-16
3 .0000 .0735 .3967 .445 .459 55.202 5.92E-16
1 .0000 .437 .442 55.614 3.88E-17
2 .0000 .4570 .435 .444 55.715 3.66E-16
4 .0000 .0567 .0551 .0001 .265 .289 63.539 2.75E-08
3 .0000 .0506 .0001 .249 .267 64.250 3.72E-08
3 .0000 .0521 .0003 .248 .267 64.263 3.81E-08
2 .0000 .0007 .231 .243 65.015 4.74E-08
2 .0000 .1285 .170 .184 67.528 4.66E-06
3 .0000 .1406 .4761 .167 .187 67.665 1.57E-05
1 .0000 .161 .168 67.899 2.30E-06
2 .0000 .4262 .159 .172 68.000 1.08E-05
3 .0149 .0137 .0000 .153 .173 68.230 4.13E-05
2 .0106 .0001 .117 .131 69.656 .0002
2 .0115 .0004 .116 .130 69.699 .0002
1 .0012 .076 .083 71.275 .0012
2 .0439 .2060 .033 .049 72.888 .0481
1 .0343 .028 .036 73.072 .0343
1 .1572 .008 .016 73.821 .1572

Stepwise_Selection

Regression Analysis -- Stepwise Selection displaying the best model of each size
124 observations
Price is the dependent variable
p-values for the coefficients
Nvar LotSize SqrFt Bedrooms Bathrooms Pool? Basement? Distance Rating Adj R² s p-value
1 .0000 .810 .812 32.274 4.24E-46
2 .0000 .0000 .916 .917 21.482 3.03E-66
3 .0000 .0000 .0000 .927 .929 20.001 1.03E-68
4 .0000 .0000 .0000 .0098 .931 .933 19.528 9.08E-69
5 .0076 .0000 .0000 .0000 .0017 .934 .937 19.025 5.54E-69
6 .0076 .0001 .0000 .0000 .7136 .0019 .934 .937 19.095 1.02E-67
7 .0076 .0001 .0000 .0000 .7433 .0050 .7711 .933 .937 19.170 1.74E-66
8 .0087 .0001 .0000 .0000 .8695 .7493 .0057 .7801 .933 .937 19.251 2.80E-65

Stepwise_Selection

Nvar
Adj R²
Adj R² vs. Number of Independent Variables

Sheet3

Sheet4

Sheet5

Sheet6