Убираем из модели незначимые переменные
. reg priceperm totsp kitsp dist metrdist walk brick tel bal floor new floors nfloor floor1 floor2 sw w nw
note: floor1 omitted because of collinearity
note: nw omitted because of collinearity
Source |
SS |
df MS |
Number of obs |
= 763 |
|
|
|
|
F( 15, 747) |
= 48.08 |
|
|
|
Model |
280904435 |
15 18726962.3 |
Prob > F |
= 0.0000 |
|
|
Residual |
290954244 |
747 389496.98 |
R-squared |
= 0.4912 |
|
|
|
|
Adj R-squared |
= 0.4810 |
|
|
|
Total |
571858679 |
762 750470.708 |
Root MSE |
= 624.1 |
|
|
|
|
|
|
|
|
|
priceperm |
Coef. |
Std. Err. t |
P>t |
[95% Conf. |
Interval] |
|
|
|
|
|
|
|
|
totsp |
-22.63279 |
5.308048 -4.26 |
0.000 |
-33.05325 |
-12.21232 |
|
kitsp |
119.9648 |
21.76058 5.51 |
0.000 |
77.24564 |
162.684 |
|
dist |
-114.3706 |
6.92851 -16.51 |
0.000 |
-127.9723 |
-100.7689 |
|
metrdist |
-31.74165 |
5.461896 -5.81 |
0.000 |
-42.46414 |
-21.01916 |
|
walk |
512.3406 |
50.0621 10.23 |
0.000 |
414.0614 |
610.6197 |
|
brick |
240.2024 |
56.11963 4.28 |
0.000 |
130.0314 |
350.3733 |
|
tel |
131.0143 |
64.67614 2.03 |
0.043 |
4.045638 |
257.9829 |
|
bal |
-58.17913 |
68.38367 -0.85 |
0.395 |
-192.4262 |
76.06792 |
|
floor |
503.1923 |
88.85308 5.66 |
0.000 |
328.7609 |
677.6238 |
|
new |
-385.053 |
156.4761 -2.46 |
0.014 |
-692.2383 |
-77.86774 |
|
floors |
43.03555 |
6.543687 6.58 |
0.000 |
30.18934 |
55.88175 |
|
nfloor |
21.04038 |
6.856964 3.07 |
0.002 |
7.579171 |
34.5016 |
|
floor1 |
(omitted) |
|
|
|
|
|
floor2 |
193.2616 |
121.0813 1.60 |
0.111 |
-44.43857 |
430.9617 |
|
sw |
220.4665 |
69.46448 3.17 |
0.002 |
84.09768 |
356.8353 |
|
w |
-15.43383 |
69.14281 -0.22 |
0.823 |
-151.1712 |
120.3035 |
|
nw |
(omitted) |
|
|
|
|
|
_cons |
5708.533 |
215.5608 26.48 |
0.000 |
5285.356 |
6131.71 |
|
|
|
|
|
|
|
. reg priceperm totsp kitsp dist metrdist walk brick tel bal floor new floors nfloor floor2 sw
Source |
SS |
df MS |
Number of obs |
= 763 |
|
|
|
|
F( 14, 748) |
= 51.58 |
|
|
|
Model |
280885028 |
14 20063216.3 |
Prob > F |
= 0.0000 |
|
|
Residual |
290973651 |
748 389002.207 |
R-squared |
= 0.4912 |
|
|
|
|
Adj R-squared |
= 0.4817 |
|
|
|
Total |
571858679 |
762 750470.708 |
Root MSE |
= 623.7 |
|
|
|
|
|
|
|
|
|
priceperm |
Coef. |
Std. Err. t |
P>t |
[95% Conf. |
Interval] |
|
|
|
|
|
|
|
|
totsp |
-22.64478 |
5.304404 -4.27 |
0.000 |
-33.05807 |
-12.23149 |
|
kitsp |
120.0053 |
21.746 5.52 |
0.000 |
77.31483 |
162.6958 |
|
dist |
-113.9993 |
6.721552 -16.96 |
0.000 |
-127.1946 |
-100.8039 |
|
metrdist |
-31.794 |
5.453392 -5.83 |
0.000 |
-42.49977 |
-21.08823 |
|
walk |
512.5497 |
50.02153 10.25 |
0.000 |
414.3504 |
610.749 |
|
brick |
241.6689 |
55.69832 4.34 |
0.000 |
132.3253 |
351.0125 |
|
tel |
131.0826 |
64.63432 2.03 |
0.043 |
4.196389 |
257.9689 |
|
bal |
-58.05207 |
68.33786 -0.85 |
0.396 |
-192.2089 |
76.10474 |
|
floor |
501.937 |
88.6186 5.66 |
0.000 |
327.9663 |
675.9078 |
|
new |
-384.8134 |
156.373 -2.46 |
0.014 |
-691.7956 |
-77.83121 |
|
floors |
42.86903 |
6.496896 6.60 |
0.000 |
30.11471 |
55.62335 |
|
nfloor |
21.0565 |
6.852228 3.07 |
0.002 |
7.604613 |
34.50839 |
|
floor2 |
192.429 |
120.9469 1.59 |
0.112 |
-45.00689 |
429.8648 |
|
sw |
231.6783 |
47.95305 4.83 |
0.000 |
137.5397 |
325.8169 |
|
_cons |
5695.598 |
207.4935 27.45 |
0.000 |
5288.259 |
6102.937 |
|
|
|
|
|
|
|
. reg priceperm totsp kitsp dist metrdist walk brick tel floor new floors nfloor floor2 sw
Source |
SS |
df MS |
Number of obs |
= 763 |
|
|
|
|
F( 13, 749) |
= 55.51 |
|
|
|
Model |
280604314 |
13 21584947.2 |
Prob > F |
= 0.0000 |
|
|
Residual |
291254366 |
749 388857.631 |
R-squared |
= 0.4907 |
|
|
|
|
Adj R-squared |
= 0.4818 |
|
|
|
Total |
571858679 |
762 750470.708 |
Root MSE |
= 623.58 |
|
|
|
|
|
|
|
|
|
priceperm |
Coef. |
Std. Err. t |
P>t |
[95% Conf. |
Interval] |
|
|
|
|
|
|
|
|
totsp |
-22.59862 |
5.30314 -4.26 |
0.000 |
-33.0094 |
-12.18783 |
|
kitsp |
119.6491 |
21.73792 5.50 |
0.000 |
76.97455 |
162.3235 |
|
dist |
-113.8151 |
6.716805 -16.94 |
0.000 |
-127.0011 |
-100.6291 |
|
metrdist |
-31.72283 |
5.451735 -5.82 |
0.000 |
-42.42532 |
-21.02033 |
|
walk |
513.9156 |
49.98639 10.28 |
0.000 |
415.7855 |
612.0457 |
|
brick |
241.5738 |
55.68785 4.34 |
0.000 |
132.251 |
350.8967 |
|
tel |
129.9915 |
64.60955 2.01 |
0.045 |
3.154135 |
256.8288 |
|
floor |
462.8857 |
75.74849 6.11 |
0.000 |
314.1811 |
611.5903 |
|
new |
-391.6494 |
156.1368 -2.51 |
0.012 |
-698.1672 |
-85.13158 |
|
floors |
42.22122 |
6.450787 6.55 |
0.000 |
29.55745 |
54.88499 |
|
nfloor |
20.87844 |
6.847748 3.05 |
0.002 |
7.435375 |
34.3215 |
|
floor2 |
149.2331 |
109.7179 1.36 |
0.174 |
-66.15818 |
364.6243 |
|
sw |
231.8342 |
47.94379 4.84 |
0.000 |
137.714 |
325.9544 |
|
_cons |
5691.661 |
207.4032 27.44 |
0.000 |
5284.5 |
6098.822 |
. reg priceperm totsp kitsp dist metrdist walk brick tel floor new floors nfloor sw
Source |
SS |
df MS |
Number of obs |
= 763 |
|
|
|
|
F( 12, 750) |
= 59.91 |
|
|
|
Model |
279884922 |
12 23323743.5 |
Prob > F |
= 0.0000 |
|
|
Residual |
291973758 |
750 389298.343 |
R-squared |
= 0.4894 |
|
|
|
|
Adj R-squared |
= 0.4813 |
|
|
|
Total |
571858679 |
762 750470.708 |
Root MSE |
= 623.94 |
|
|
|
|
|
|
|
|
|
priceperm |
Coef. |
Std. Err. t |
P>t |
[95% Conf. |
Interval] |
|
|
|
|
|
|
|
|
totsp |
-22.14878 |
5.295816 -4.18 |
0.000 |
-32.54517 |
-11.7524 |
|
kitsp |
117.0832 |
21.66818 5.40 |
0.000 |
74.54572 |
159.6207 |
|
dist |
-112.9848 |
6.692801 -16.88 |
0.000 |
-126.1237 |
-99.84598 |
|
metrdist |
-31.68811 |
5.454763 -5.81 |
0.000 |
-42.39653 |
-20.97969 |
|
walk |
512.5983 |
50.00532 10.25 |
0.000 |
414.4313 |
610.7654 |
|
brick |
244.0884 |
55.68869 4.38 |
0.000 |
134.7642 |
353.4127 |
|
tel |
131.2453 |
64.63957 2.03 |
0.043 |
4.349287 |
258.1413 |
|
floor |
391.6417 |
54.75053 7.15 |
0.000 |
284.1592 |
499.1242 |
|
new |
-403.7455 |
155.9716 -2.59 |
0.010 |
-709.9384 |
-97.55256 |
|
floors |
40.00396 |
6.244949 6.41 |
0.000 |
27.7443 |
52.26362 |
|
nfloor |
25.84808 |
5.794812 4.46 |
0.000 |
14.4721 |
37.22406 |
|
sw |
234.2453 |
47.93815 4.89 |
0.000 |
140.1364 |
328.3543 |
|
_cons |
5744.119 |
203.9011 28.17 |
0.000 |
5343.834 |
6144.404 |
|
|
|
|
|
|
|