House Price Regression Analysis
House Price Regression Analysis
Regression Statistics
Multiple R 0.728132202349633
R Square 0.530176504098526
Adjusted R Square 0.52577190882445
Standard Error 7.31108673766477
Observations 324
ANOVA
df SS MS
Regression 3 19301.8793237 6433.9597746
Residual 320 17104.6365714 53.451989286
Total 323 36406.5158951
RESIDUAL OUTPUT
Residuals
0
-20 0 5 10 15 20 25
-40
house age
F Significance F
120.36894904 3.3766692E-52
Residuals
20
2.449733E-31 -0.0109718014 -0.008088579 -0.0109718014 -0.008088579 0
7.207121E-07 0.5792138625 1.3170267121 0.5792138625 1.3170267121 -20 0 500 1000 1500 20
-40
distance to the nearest MR
number of convenie
stores Residual Pl
40
20
Residuals
0
-20 0 2 4 6 8
-40
number of convenience st
use age Residual Plot
5 10 15 20 25 30 35 40 45
house age
mber of convenience
tores Residual Plot
2 4 6 8 10 12
Regression Statistics
Multiple R 0.701639682183894
R Square 0.492298243615116
Adjusted R Square 0.489134992796518
Standard Error 7.58824555504543
Observations 324
ANOVA
df SS MS
Regression 2 17922.8638313 8961.4319156
Residual 321 18483.6520638 57.581470604
Total 323 36406.5158951
RESIDUAL OUTPUT
Residuals
0
-20 0 500 1000 1500 200
-40
distance to the nearest MRT
F Significance F
155.63048011 5.6258852E-48
number of convenie
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% stores Residual P
2.628107E-99 39.28758344 44.570654719 39.28758344 44.570654719 40
1.932963E-27 -0.0104608707 -0.00750114 -0.0104608707 -0.00750114
Residuals
20
1.040336E-05 0.4872574745 1.2503719062 0.4872574745 1.2503719062 0
-20 0 2 4 6
-40
number of convenience st
ance to the nearest MRT
tation Residual Plot
umber of convenience
stores Residual Plot
2 4 6 8 10 12
Regression Statistics
Multiple R 0.754417100643688
R Square 0.569145161743629
Adjusted R Square 0.562370714601233
Standard Error 7.02330431591694
Observations 324
ANOVA
df SS MS
Regression 5 20720.5923776 4144.1184755
Residual 318 15685.9235174 49.326803514
Total 323 36406.5158951
RESIDUAL OUTPUT
Residuals
0 numbe
-20 0 5 40 10 15 20 25 3
store
Residuals
20
-40 0 40
-20 0 house age
500 1000
Residuals
20
F Significance F -40
0
84.013521662 4.7653798E-56 distance
-20 0 to the
2 n
-40
nu
20
-40
0 20
longitude Residual Plot
Residuals
distance
-20 0 to the
2 nearest MRT station
4 40 6 8 10 12
-40 0
-2024.94 24.95
20 24.96 24.97 24.98 24.99 25
Residuals
Regression Statistics
Multiple R 0.754210695712564
R Square 0.568833773527229
Adjusted R Square 0.56342730046801
Standard Error 7.01482087024866
Observations 324
ANOVA
df SS MS
Regression 4 20709.2558176 5177.3139544
Residual 319 15697.2600775 49.207711842
Total 323 36406.5158951
RESIDUAL OUTPUT
Residuals
0 numb
-20 0 5 40 10 15 20 25
stor
Residuals
20
-40 0 40
-20 0 house age
500 1000
20
Residuals
F Significance F -40
0
105.21346676 4.8791236E-57 distance
-20 0 to the
2
-40
n
-40
0 20
Residuals
distance
-20 0 to the
2 nearest
4 MRT station
6 8 10 12
-40 0
-2024.94 24.95 24.96 24.97 24.98 24.99
number of convenience stores
25
-40
latitude
house price of unit area house age distance to the nearest MRT station
20.7 31.3 1758.406
20.8 18.9 1009.235
20.9 18.1 1783.18
20.9 15 1828.319
21.3 11 1931.207
21.4 12.8 1449.722
21.5 31.4 1447.286
21.7 4.8 1559.827
21.8 20.6 2469.645
21.8 14.1 2615.465
21.8 18.2 2179.59
22.1 17.9 1783.18
22.3 19 1009.235
22.3 5.2 2408.993
22.8 30 1013.341
22.8 20.2 2185.128
22.9 14.7 1935.009
23 17.6 837.7233
23 14.7 1717.193
23.1 9.9 2102.427
23.1 21.7 1055.067
23.2 16.5 2288.011
23.5 8.4 1962.628
23.5 33.5 1978.671
23.6 13.5 2147.376
23.6 15.9 1497.713
23.7 17.8 1783.18
23.8 20.4 2469.645
23.8 21.7 1157.988
23.9 8 2216.612
24.4 16.2 2288.011
24.5 17.5 395.6747
24.6 14.7 1360.139
24.7 16.4 1643.499
24.7 5.6 2408.993
24.8 14.2 1801.544
25 29.6 769.4034
25.3 12 1360.139
25.3 17.5 995.7554
25.5 17.4 995.7554
25.6 20.5 2185.128
25.6 2 1455.798
25.6 16.2 2103.555
25.7 20.9 2185.128
25.7 18.4 2674.961
25.9 30.4 1735.595
26.2 11.5 1360.139
26.5 18 1414.837
26.5 14.6 339.2289
26.5 17.7 451.6419
26.6 12.2 1360.139
26.6 18 1414.837
26.9 34.6 272.6783
27 29.3 1487.868
27 32.1 1438.579
27 1.8 1455.798
27.3 15.6 1756.411
27.3 10.4 2251.938
27.7 17.2 2175.877
27.7 21.2 2185.128
27.7 7.6 2175.03
28.1 18.5 2175.744
28.4 4 2147.376
28.4 11.9 1360.139
28.5 34.9 567.0349
28.5 12.7 187.4823
28.6 4 2180.245
28.8 11 1712.632
28.8 17.7 837.7233
28.9 5.1 1559.827
28.9 12 1360.139
29.3 4.5 2275.877
29.3 13.2 170.1289
29.4 20 1626.083
29.5 12.3 1360.139
29.5 17.3 2261.432
29.7 18.1 837.7233
29.8 38.2 552.4371
30 39.2 424.7132
30.1 12.2 1360.139
30.5 32.7 392.4459
30.5 14.7 1717.193
30.6 25.3 1583.722
30.6 13.7 1236.564
30.7 4 2147.376
30.7 17 1485.097
30.8 13.2 1712.632
30.9 31.3 600.8604
31.1 17.6 1805.665
31.1 2.6 1554.25
31.3 13.3 492.2313
31.3 12.4 1712.632
31.3 4.1 2147.376
31.3 6.2 1939.749
31.5 38.3 642.6985
31.6 18.2 451.6419
31.7 3.9 2147.376
31.9 37.1 918.6357
32.1 7.1 2175.03
32.2 13.1 1164.838
32.4 39.7 333.3679
32.5 31.5 414.9476
32.9 12.7 170.1289
32.9 19.2 461.1016
33.1 12.9 187.4823
33.1 35.3 614.1394
33.4 4 2147.376
33.4 2 2077.39
33.6 10.4 276.449
34 19.1 461.1016
34.1 34.4 512.7871
34.1 31.4 592.5006
34.1 12.5 1144.436
34.2 37.9 488.5727
34.2 38.5 665.0636
34.3 13.2 1164.838
34.4 15 383.2805
34.6 28.4 617.4424
34.6 15.2 461.1016
34.7 36.1 519.4617
35.1 41.3 401.8807
35.3 42.7 443.802
35.5 26.8 482.7581
35.6 16.1 815.9314
35.6 5.1 1867.233
35.7 38 461.7848
36.2 30.4 464.223
36.3 32.5 424.5442
36.3 31.5 258.186
36.5 30.2 472.1745
36.5 27.3 337.6016
36.6 22.8 707.9067
36.7 13.1 1144.436
36.7 3.5 757.3377
36.8 35.9 616.4004
36.8 30.8 377.7956
36.9 2.5 156.2442
37 37.7 490.3446
37 13 750.0704
37.2 23 130.9945
37.3 12.7 170.1289
37.4 17.7 350.8515
37.4 15.5 815.9314
37.4 27.6 515.1122
37.4 37.3 587.8877
37.5 29.6 535.527
37.5 26.6 482.7581
37.5 19.8 640.6071
37.5 15.6 752.7669
37.7 16.9 964.7496
37.8 13.2 750.0704
38.1 15.7 815.9314
38.1 26.4 335.5273
38.1 36.6 488.8193
38.2 17.5 964.7496
38.3 36.6 488.8193
38.4 38.3 439.7105
38.4 7.8 104.8101
38.5 9 1402.016
38.6 32.8 377.8302
38.8 39.6 480.6977
38.9 13.3 492.2313
39 13 732.8528
39.1 34 157.6052
39.3 13 492.2313
39.3 12.9 250.631
39.4 33.3 196.6172
39.4 11.6 390.5684
39.5 18 373.3937
39.6 19.2 616.4004
39.6 39.8 617.7134
39.7 34.9 179.4538
39.7 37.8 590.9292
39.7 30.9 161.942
40 17.1 967.4
40.1 13.6 492.2313
40.1 17.2 390.5684
40.2 29.3 529.7771
40.2 32.4 265.0609
40.3 34.5 623.4731
40.3 11.8 533.4762
40.3 29.1 506.1144
40.3 16.9 967.4
40.5 13 492.2313
40.5 1.9 372.1386
40.6 12.8 732.8528
40.6 16.4 389.8219
40.6 32.6 493.657
40.6 18.8 390.9696
40.8 35.5 640.7391
40.8 28 372.6242
40.8 7.5 639.6198
40.9 6.5 376.1709
40.9 34.8 175.6294
41 40.9 167.5989
41 38.5 216.8329
41 27.5 394.0173
41.1 34.7 482.7581
41.2 16.4 289.3248
41.4 34.8 405.2134
41.4 13.7 250.631
41.5 33.9 157.6052
41.6 3.7 577.9615
41.9 33.6 371.2495
42 21.7 463.9623
42 12.5 561.9845
42 33 181.0766
42 13.3 250.631
42.1 15.9 289.3248
42.2 19.5 306.5947
42.2 33.4 186.9686
42.2 21.3 537.7971
42.3 16.9 368.1363
42.3 35.3 616.5735
42.3 9.1 1402.016
42.3 13.2 492.2313
42.4 13.3 336.0532
42.5 12.9 492.2313
42.5 12.6 383.2805
42.5 28.6 197.1338
42.5 21.2 512.5487
42.6 14 438.8513
42.8 8.3 104.8101
42.9 33.6 270.8895
43.1 5 390.5684
43.1 18.2 350.8515
43.2 9.1 1402.016
43.2 3.2 489.8821
43.4 28.2 330.0854
43.5 10 942.4664
43.7 15.1 383.2805
43.8 13.6 492.2313
43.9 17.3 444.1334
44 22.2 379.5575
44.2 21.7 512.5487
44.3 40.1 123.7429
44.3 34.8 190.0392
44.5 13.9 289.3248
44.7 4.9 387.7721
44.8 4.7 387.7721
45.1 1.1 193.5845
45.2 4.3 432.0385
45.3 10.3 211.4473
45.4 2.3 184.3302
45.5 2.1 451.2438
45.9 13.1 561.9845
46 34.5 324.9419
46.1 15.6 289.3248
46.1 33.2 121.7262
46.2 16.2 289.3248
46.4 20.6 737.9161
46.6 33.5 563.2854
46.7 20.3 287.6025
46.8 11.4 390.5684
47 19.2 557.478
47 7.8 104.8101
47.1 17.2 189.5181
47.3 13.3 561.9845
47.3 8 132.5469
47.4 13.6 319.0708
47.7 3.1 577.9615
47.9 10.1 279.1726
48 8.9 1406.43
48 13.6 492.2313
48 32.3 109.9455
48.1 13.2 150.9347
48.1 19.2 383.7129
48.2 34.4 126.7286
48.2 32.8 204.1705
48.5 35.8 170.7311
48.5 30.6 431.1114
48.6 1.1 193.5845
49 1.1 193.5845
49.3 16.5 323.655
49.3 9.7 421.479
49.5 5.4 390.5684
49.8 7.1 379.5575
50.2 14.4 169.9803
50.4 1.7 329.9747
50.5 35.7 579.2083
50.7 1 193.5845
51 16.4 289.3248
51 16.6 323.6912
51.4 16.2 289.3248
51.6 10.5 279.1726
51.6 8.1 104.8101
51.7 16.1 289.3248
51.7 4.1 312.8963
51.8 8 104.8101
51.8 1.1 329.9747
52.2 5.2 390.5684
52.5 8.1 104.8101
53 15.9 289.3248
53 16.4 289.3248
53.3 30.6 143.8383
53.3 14.1 289.3248
53.7 4.6 259.6607
53.9 2.7 533.4762
54.4 6.8 379.5575
54.4 1.1 193.5845
54.8 13.3 561.9845
55 2.6 533.4762
55 3.8 383.8624
55 16.2 289.3248
55.1 15.4 205.367
55.3 30.1 718.2937
55.5 8.5 104.8101
55.9 11.6 201.8939
56.2 3.1 383.8624
56.8 8.5 104.8101
57.1 7.1 451.2438
57.4 9.9 279.1726
58.8 3.6 383.8624
59.6 16.6 289.3248
60.7 41.3 124.9912
60.7 3.8 383.8624
61.5 35.9 640.7391
61.9 3.6 373.8389
62.9 38.6 804.6897
63.2 5.3 259.6607
63.3 41.4 281.205
67.7 40.9 122.3619
78 35.4 318.5292
78.3 37.2 186.5101
-0.022350923 -0.678643934916106
number of convenience stores latitude longitude
1 24.95402 121.55282
0 24.96357 121.54951
3 24.96731 121.51486
2 24.96464 121.51531
2 24.96365 121.51471
3 24.97289 121.51728
3 24.97285 121.5173
3 24.97213 121.51627
4 24.96108 121.51046
0 24.95495 121.56174
3 24.96299 121.51252
3 24.96731 121.51486
0 24.96357 121.54951
0 24.95505 121.55964
5 24.99006 121.5346
3 24.96322 121.51237
2 24.96386 121.51458
0 24.96334 121.54767
2 24.96447 121.51649
3 24.96044 121.51462
0 24.96211 121.54928
3 24.95885 121.51359
1 24.95468 121.55481
2 24.98674 121.51844
3 24.96299 121.51284
3 24.97003 121.51696
3 24.96731 121.51486
4 24.96108 121.51046
0 24.96165 121.55011
4 24.96007 121.51361
3 24.95885 121.51359
5 24.95674 121.534
1 24.95204 121.54842
2 24.95394 121.55174
0 24.95505 121.55964
1 24.95153 121.55254
7 24.98281 121.53408
1 24.95204 121.54842
0 24.96305 121.54915
0 24.96305 121.54915
3 24.96322 121.51237
1 24.9512 121.549
3 24.96042 121.51462
3 24.96322 121.51237
3 24.96143 121.50827
2 24.96464 121.51623
1 24.95204 121.54842
1 24.95182 121.54887
1 24.97519 121.53151
8 24.96945 121.5449
1 24.95204 121.54842
1 24.95182 121.54887
5 24.95562 121.53872
2 24.97542 121.51726
3 24.97419 121.5175
1 24.9512 121.549
2 24.9832 121.51812
4 24.95957 121.51353
3 24.96303 121.51254
3 24.96322 121.51237
3 24.96305 121.51254
3 24.9633 121.51243
3 24.96299 121.51284
1 24.95204 121.54842
4 24.97003 121.5458
1 24.97388 121.52981
3 24.96324 121.51241
2 24.96412 121.5167
0 24.96334 121.54767
3 24.97213 121.51627
1 24.95204 121.54842
3 24.96314 121.51151
1 24.97371 121.52984
3 24.96622 121.51668
1 24.95204 121.54842
4 24.96182 121.51222
0 24.96334 121.54767
2 24.97598 121.53381
7 24.97429 121.53917
1 24.95204 121.54842
6 24.96398 121.5425
2 24.96447 121.51649
3 24.96622 121.51709
1 24.97694 121.55391
3 24.96299 121.51284
4 24.97073 121.517
2 24.96412 121.5167
5 24.96871 121.54651
2 24.98672 121.52091
3 24.97026 121.51642
5 24.96515 121.53737
2 24.96412 121.5167
3 24.96299 121.51284
1 24.95155 121.55387
3 24.97559 121.53713
8 24.96945 121.5449
3 24.96299 121.51284
1 24.97198 121.55063
3 24.96305 121.51254
4 24.99156 121.53406
9 24.98016 121.53932
4 24.98199 121.54464
1 24.97371 121.52984
5 24.95425 121.5399
1 24.97388 121.52981
7 24.97913 121.53666
3 24.96299 121.51284
3 24.96357 121.51329
5 24.95593 121.53913
5 24.95425 121.5399
6 24.98748 121.54301
2 24.9726 121.53561
4 24.99176 121.53456
1 24.97349 121.53451
3 24.97503 121.53692
4 24.99156 121.53406
7 24.96735 121.54464
3 24.97746 121.53299
5 24.95425 121.5399
5 24.96305 121.53758
4 24.98326 121.5446
6 24.97927 121.53874
5 24.97433 121.53863
4 24.97886 121.53464
2 24.98407 121.51748
0 24.97229 121.53445
6 24.97964 121.53805
8 24.97587 121.53913
9 24.96867 121.54331
3 24.97005 121.53758
6 24.96431 121.54063
2 24.981 121.54713
4 24.99176 121.53456
3 24.97538 121.54971
3 24.97723 121.53767
6 24.96427 121.53964
4 24.96696 121.53992
0 24.97217 121.53471
2 24.97371 121.54951
6 24.95663 121.53765
1 24.97371 121.52984
1 24.97544 121.53119
4 24.97886 121.53464
5 24.96299 121.5432
8 24.97077 121.54634
8 24.98092 121.53653
5 24.97433 121.53863
5 24.97017 121.54647
2 24.97795 121.53451
4 24.98872 121.53411
2 24.97371 121.54951
4 24.97886 121.53464
6 24.9796 121.5414
8 24.97015 121.54494
4 24.98872 121.53411
8 24.97015 121.54494
0 24.97161 121.53423
5 24.96674 121.54067
0 24.98569 121.5276
9 24.97151 121.5435
4 24.97353 121.53885
5 24.96515 121.53737
0 24.97668 121.52518
7 24.96628 121.54196
5 24.96515 121.53737
7 24.96606 121.54297
7 24.97701 121.54224
5 24.97937 121.54245
8 24.9866 121.54082
3 24.97723 121.53767
2 24.97577 121.53475
8 24.97349 121.54245
1 24.97153 121.53559
9 24.98353 121.53966
4 24.98872 121.53408
5 24.96515 121.53737
5 24.97937 121.54245
8 24.98102 121.53655
8 24.98059 121.53986
7 24.97933 121.53642
4 24.97445 121.54765
4 24.97845 121.53889
4 24.98872 121.53408
5 24.96515 121.53737
7 24.97293 121.54026
0 24.97668 121.52518
6 24.96412 121.54273
7 24.96968 121.54522
7 24.97923 121.53986
3 24.97563 121.53715
6 24.97838 121.54119
5 24.97258 121.54814
6 24.95418 121.53713
8 24.97347 121.54271
5 24.9663 121.54026
7 24.98086 121.54162
7 24.97305 121.53994
5 24.97433 121.53863
5 24.98203 121.54348
1 24.97349 121.53372
7 24.96606 121.54297
7 24.96628 121.54196
6 24.97201 121.54722
8 24.97254 121.54059
9 24.9703 121.54458
5 24.98746 121.54391
9 24.97697 121.54262
7 24.96606 121.54297
5 24.98203 121.54348
9 24.98034 121.53951
6 24.96604 121.54211
4 24.97425 121.53814
8 24.9675 121.54451
8 24.97945 121.53642
0 24.98569 121.5276
5 24.96515 121.53737
5 24.95776 121.53438
5 24.96515 121.53737
7 24.96735 121.54464
6 24.97631 121.54436
4 24.974 121.53842
1 24.97493 121.5273
5 24.96674 121.54067
0 24.97281 121.53265
5 24.97937 121.54245
1 24.97544 121.53119
0 24.98569 121.5276
8 24.97017 121.54494
8 24.97408 121.54011
0 24.97843 121.52406
7 24.96735 121.54464
5 24.96515 121.53737
1 24.97501 121.5273
10 24.98343 121.53762
4 24.974 121.53842
8 24.97635 121.54329
8 24.97707 121.54312
5 24.98203 121.54348
9 24.98118 121.53788
9 24.98118 121.53788
6 24.96571 121.54089
7 24.9805 121.53778
1 24.97417 121.52999
6 24.96581 121.54086
5 24.97563 121.54694
5 24.98746 121.54391
6 24.97814 121.5417
5 24.98203 121.54348
10 24.98178 121.54059
5 24.98203 121.54348
2 24.98092 121.54739
8 24.98223 121.53597
6 24.98042 121.54228
5 24.97937 121.54245
4 24.97419 121.53797
5 24.96674 121.54067
8 24.97707 121.54308
5 24.98746 121.54391
9 24.98298 121.53981
6 24.96495 121.54277
6 24.97201 121.54722
7 24.97528 121.54541
0 24.98573 121.52758
5 24.96515 121.53737
10 24.98182 121.54086
7 24.96725 121.54252
8 24.972 121.54477
8 24.96881 121.54089
8 24.98236 121.53923
7 24.96719 121.54269
10 24.98123 121.53743
6 24.96571 121.54089
6 24.96571 121.54089
6 24.97841 121.54281
5 24.98246 121.54477
5 24.97937 121.54245
10 24.98343 121.53762
1 24.97369 121.52979
5 24.98254 121.54395
2 24.9824 121.54619
6 24.96571 121.54089
5 24.98203 121.54348
6 24.97841 121.5428
5 24.98203 121.54348
7 24.97528 121.54541
5 24.96674 121.54067
5 24.98203 121.54348
5 24.95591 121.53956
5 24.96674 121.54067
5 24.98254 121.54395
5 24.97937 121.54245
5 24.96674 121.54067
5 24.98203 121.54348
5 24.98203 121.54348
8 24.98155 121.54142
5 24.98203 121.54348
6 24.97585 121.54516
4 24.97445 121.54765
10 24.98343 121.53762
6 24.96571 121.54089
5 24.98746 121.54391
4 24.97445 121.54765
5 24.98085 121.54391
5 24.98203 121.54348
7 24.98419 121.54243
3 24.97509 121.53644
5 24.96674 121.54067
8 24.98489 121.54121
5 24.98085 121.54391
5 24.96674 121.54067
5 24.97563 121.54694
7 24.97528 121.54541
5 24.98085 121.54391
5 24.98203 121.54348
6 24.96674 121.54039
5 24.98085 121.54391
3 24.97563 121.53715
10 24.98322 121.53765
4 24.97838 121.53477
6 24.97585 121.54516
8 24.97345 121.54093
8 24.96756 121.5423
9 24.97071 121.54069
9 24.97703 121.54265