To calculate the dependent variable (house price) based on the independent variables V1,V2..V16. In order to do so, first we will select the 4 parameters on which the variable ‘Target’ depends the most and then predicting the values.
We import the training and the validation dataset.
df<-read.csv(paste("D1 - Training Dataset.csv",sep=""))
testdf=read.csv(paste("D2 - Validation Dataset.csv",sep=""))
cor(df$Target,df$V1)## [1] 0.02412196Now we find the correlation of all variables with the dependent variable.
cor(df$Target,df$V1)## [1] 0.02412196cor(df$Target,df$V2)## [1] 0.08047787cor(df$Target,df$V3)## [1] 0.3854707cor(df$Target,df$V4)## [1] 0.4156129cor(df$Target,df$V5)## [1] 0.3270402cor(df$Target,df$V6)## [1] 0.249855cor(df$Target,df$V7)## [1] -0.02538486cor(df$Target,df$V8)## [1] 0.1031846cor(df$Target,df$V9)## [1] 0.1013004cor(df$Target,df$V10)## [1] 0.1218751cor(df$Target,df$V11)## [1] -0.0271112cor(df$Target,df$V12)## [1] -0.005258905cor(df$Target,df$V13)## [1] -0.01806987cor(df$Target,df$V14)## [1] -0.01202274cor(df$Target,df$V15)## [1] -0.01500774cor(df$Target,df$V16)## [1] 0.07177757It is clear from the tests that variables V3,V4,V5,V6 have the highest correlation with the dependent variable and are hence the most important.
We now build the model with these 4 variables on the training dataset.
fit<-lm(Target~V3+V4+V5+V6,data=df)
summary(fit)##
## Call:
## lm(formula = Target ~ V3 + V4 + V5 + V6, data = df)
##
## Residuals:
## Min 1Q Median 3Q Max
## -730534 -115655 21453 83453 342453
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 4.075e+05 4.376e+03 93.141 < 2e-16 ***
## V3 5.134e+04 6.880e+03 7.463 1.25e-13 ***
## V4 1.483e-02 1.672e-03 8.867 < 2e-16 ***
## V5 8.100e+04 7.683e+03 10.543 < 2e-16 ***
## V6 -2.953e-03 2.140e-03 -1.380 0.168
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 158400 on 2048 degrees of freedom
## Multiple R-squared: 0.2534, Adjusted R-squared: 0.2519
## F-statistic: 173.8 on 4 and 2048 DF, p-value: < 2.2e-16As the R-squared and Adjusted R-squared are pretty high and the p-value is lesser than 2.2e-16, it can be assumed safely that the model is significant to some extent.
We now predict the values on the test data set using the model.
predicteddf <- predict(fit,testdf)
predicteddf## 1 2 3 4 5 6 7
## 407546.7 485891.6 407546.7 407546.7 407546.7 407546.7 407546.7
## 8 9 10 11 12 13 14
## 407546.7 472482.4 466326.1 407546.7 523876.6 407546.7 467159.9
## 15 16 17 18 19 20 21
## 407546.7 407546.7 407546.7 407546.7 473785.1 407546.7 407546.7
## 22 23 24 25 26 27 28
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 29 30 31 32 33 34 35
## 407546.7 407546.7 407546.7 407546.7 407546.7 465743.5 407546.7
## 36 37 38 39 40 41 42
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 43 44 45 46 47 48 49
## 407546.7 407546.7 524553.2 552998.7 407546.7 407546.7 407546.7
## 50 51 52 53 54 55 56
## 407546.7 407546.7 473713.0 407546.7 473713.0 407546.7 407546.7
## 57 58 59 60 61 62 63
## 473713.0 473713.0 485596.4 473713.0 473713.0 485596.4 407546.7
## 64 65 66 67 68 69 70
## 471542.9 407546.7 407546.7 407546.7 407546.7 467500.9 407546.7
## 71 72 73 74 75 76 77
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 78 79 80 81 82 83 84
## 407546.7 407546.7 474104.3 407546.7 472971.7 407546.7 407546.7
## 85 86 87 88 89 90 91
## 407546.7 407546.7 407546.7 473626.7 485475.0 474424.6 407546.7
## 92 93 94 95 96 97 98
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 99 100 101 102 103 104 105
## 407546.7 474899.1 471367.8 407546.7 407546.7 407546.7 407546.7
## 106 107 108 109 110 111 112
## 407546.7 543011.6 475195.6 473943.8 407546.7 485891.6 407546.7
## 113 114 115 116 117 118 119
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 120 121 122 123 124 125 126
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 127 128 129 130 131 132 133
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 485596.4
## 134 135 136 137 138 139 140
## 407546.7 407546.7 485565.4 476089.6 407546.7 407546.7 407546.7
## 141 142 143 144 145 146 147
## 407546.7 407546.7 476423.1 552481.3 476598.3 476678.2 476678.2
## 148 149 150 151 152 153 154
## 473713.0 476678.2 407546.7 407546.7 407546.7 467782.6 407546.7
## 155 156 157 158 159 160 161
## 476900.6 474123.3 407546.7 407546.7 486689.3 407546.7 477263.9
## 162 163 164 165 166 167 168
## 485348.4 407546.7 407546.7 477434.3 466300.0 407546.7 407546.7
## 169 170 171 172 173 174 175
## 477699.3 407546.7 407546.7 407546.7 485891.6 407546.7 477896.5
## 176 177 178 179 180 181 182
## 407546.7 407546.7 485510.5 407546.7 407546.7 474160.0 407546.7
## 183 184 185 186 187 188 189
## 478160.8 407546.7 407546.7 407546.7 478160.8 407546.7 485596.4
## 190 191 192 193 194 195 196
## 488253.9 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 197 198 199 200 201 202 203
## 407546.7 407546.7 478498.1 478605.6 407546.7 407546.7 407546.7
## 204 205 206 207 208 209 210
## 484589.5 478902.1 484562.9 486777.5 478950.2 479050.3 407546.7
## 211 212 213 214 215 216 217
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 218 219 220 221 222 223 224
## 407546.7 530823.6 479554.4 407546.7 479643.4 478531.4 407546.7
## 225 226 227 228 229 230 231
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 232 233 234 235 236 237 238
## 407546.7 407546.7 479981.1 407546.7 407546.7 407546.7 479936.2
## 239 240 241 242 243 244 245
## 407546.7 407546.7 407546.7 407546.7 407546.7 471354.1 480236.4
## 246 247 248 249 250 251 252
## 480458.8 407546.7 407546.7 480384.7 484237.2 473045.8 407546.7
## 253 254 255 256 257 258 259
## 407546.7 407546.7 407546.7 407546.7 407546.7 480933.2 407546.7
## 260 261 262 263 264 265 266
## 481015.2 407546.7 481126.0 484120.0 481126.0 481126.0 481126.0
## 267 268 269 270 271 272 273
## 407546.7 476678.2 407546.7 481126.0 407546.7 481126.0 407546.7
## 274 275 276 277 278 279 280
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 281 282 283 284 285 286 287
## 484070.2 407546.7 477023.9 407546.7 407546.7 479643.4 481861.6
## 288 289 290 291 292 293 294
## 533257.2 407546.7 482034.8 407546.7 476678.2 407546.7 407546.7
## 295 296 297 298 299 300 301
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 483824.7
## 302 303 304 305 306 307 308
## 407546.7 501378.2 407546.7 407546.7 597150.0 483824.7 407546.7
## 309 310 311 312 313 314 315
## 482608.6 407546.7 407546.7 407546.7 482920.8 407546.7 486799.3
## 316 317 318 319 320 321 322
## 407546.7 469265.2 483349.9 483313.5 407546.7 407546.7 475195.6
## 323 324 325 326 327 328 329
## 407546.7 407546.7 407546.7 407546.7 483913.2 407546.7 483667.5
## 330 331 332 333 334 335 336
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 337 338 339 340 341 342 343
## 484091.2 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 344 345 346 347 348 349 350
## 407546.7 623853.6 483479.9 481406.0 407546.7 484425.7 484562.9
## 351 352 353 354 355 356 357
## 473713.0 407546.7 612807.8 699591.2 407546.7 407546.7 484832.4
## 358 359 360 361 362 363 364
## 483378.0 477953.2 407546.7 476678.2 485979.4 465478.6 485232.2
## 365 366 367 368 369 370 371
## 481126.0 407546.7 407546.7 478803.9 485520.3 473416.5 485573.7
## 372 373 374 375 376 377 378
## 407546.7 485558.9 485573.7 407546.7 485664.8 407546.7 407546.7
## 379 380 381 382 383 384 385
## 407546.7 484005.8 407546.7 537246.7 486016.7 611075.8 407546.7
## 386 387 388 389 390 391 392
## 486107.5 407546.7 407546.7 474798.3 407546.7 407546.7 407546.7
## 393 394 395 396 397 398 399
## 477419.5 569531.1 407546.7 467782.6 486482.2 482608.6 407546.7
## 400 401 402 403 404 405 406
## 485573.7 407546.7 407546.7 474067.2 477356.1 407546.7 407546.7
## 407 408 409 410 411 412 413
## 487056.3 564236.5 538396.7 407546.7 484636.7 487135.6 487249.1
## 414 415 416 417 418 419 420
## 407546.7 407546.7 478986.9 487376.3 550724.8 407546.7 407546.7
## 421 422 423 424 425 426 427
## 478544.1 407546.7 482791.2 561573.9 407546.7 476678.2 407546.7
## 428 429 430 431 432 433 434
## 407546.7 407546.7 479643.4 482752.8 407546.7 407546.7 407546.7
## 435 436 437 438 439 440 441
## 407546.7 488538.9 407546.7 407546.7 488538.9 407546.7 488538.9
## 442 443 444 445 446 447 448
## 407546.7 488538.9 407546.7 482643.6 488538.9 482643.6 488538.9
## 449 450 451 452 453 454 455
## 488538.9 562429.9 482615.8 407546.7 407546.7 407546.7 407546.7
## 456 457 458 459 460 461 462
## 407546.7 407546.7 407546.7 407546.7 407546.7 473713.0 488464.8
## 463 464 465 466 467 468 469
## 407546.7 407546.7 489132.0 565417.7 469497.4 407546.7 487056.3
## 470 471 472 473 474 475 476
## 489406.5 478766.1 481126.0 482450.9 540903.7 407546.7 407546.7
## 477 478 479 480 481 482 483
## 407546.7 481851.6 489540.4 407546.7 407546.7 536004.9 407546.7
## 484 485 486 487 488 489 490
## 407546.7 490021.5 490021.5 490021.5 485573.7 407546.7 490146.1
## 491 492 493 494 495 496 497
## 407546.7 407546.7 482279.8 407546.7 554001.8 533557.2 407546.7
## 498 499 500 501 502 503 504
## 490646.5 476678.2 643284.7 407546.7 484469.7 481232.6 483972.6
## 505 506 507 508 509 510 511
## 486315.0 633091.1 491059.3 484091.2 483220.3 473713.0 569256.3
## 512 513 514 515 516 517 518
## 566008.2 532762.8 563793.6 485632.6 469265.2 482643.6 491657.2
## 519 520 521 522 523 524 525
## 407546.7 407546.7 492031.9 407546.7 407546.7 407546.7 492245.4
## 526 527 528 529 530 531 532
## 492245.4 481126.0 492330.1 407546.7 407546.7 481882.1 407546.7
## 533 534 535 536 537 538 539
## 481856.2 492469.7 489574.5 492938.8 407546.7 536172.8 407546.7
## 540 541 542 543 544 545 546
## 407546.7 407546.7 480903.6 492831.0 407546.7 483550.9 481757.7
## 547 548 549 550 551 552 553
## 486315.0 483677.0 493283.2 407546.7 487929.8 487797.6 407546.7
## 554 555 556 557 558 559 560
## 407546.7 491504.1 553482.6 563144.7 407546.7 481126.0 407546.7
## 561 562 563 564 565 566 567
## 407546.7 407546.7 494321.0 407546.7 479643.4 494469.3 494469.3
## 568 569 570 571 572 573 574
## 488538.9 485573.7 407546.7 494776.4 407546.7 562612.5 481970.3
## 575 576 577 578 579 580 581
## 407546.7 407546.7 484120.0 560918.2 495103.1 407546.7 481314.8
## 582 583 584 585 586 587 588
## 481126.0 407546.7 407546.7 407546.7 407546.7 485573.7 488538.9
## 589 590 591 592 593 594 595
## 407546.7 407546.7 495670.2 495781.4 474572.9 540620.6 495951.9
## 596 597 598 599 600 601 602
## 495951.9 407546.7 495951.9 495951.9 559175.6 495951.9 407546.7
## 603 604 605 606 607 608 609
## 481167.2 483995.0 495951.9 576954.3 488538.9 407546.7 407546.7
## 610 611 612 613 614 615 616
## 407546.7 407546.7 496248.4 472230.4 488538.9 407546.7 407546.7
## 617 618 619 620 621 622 623
## 556843.3 407546.7 407546.7 481034.1 496693.2 407546.7 496693.2
## 624 625 626 627 628 629 630
## 548181.8 488538.9 480955.0 407546.7 407546.7 407546.7 489397.7
## 631 632 633 634 635 636 637
## 407546.7 480901.4 488538.9 491477.9 469632.7 407546.7 497499.3
## 638 639 640 641 642 643 644
## 542306.7 407546.7 593712.9 407546.7 407546.7 798852.2 407546.7
## 645 646 647 648 649 650 651
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 652 653 654 655 656 657 658
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 659 660 661 662 663 664 665
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 666 667 668 669 670 671 672
## 407546.7 407546.7 407546.7 407546.7 505821.2 407546.7 407546.7
## 673 674 675 676 677 678 679
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 680 681 682 683 684 685 686
## 407546.7 407546.7 407546.7 498175.8 407546.7 407546.7 407546.7
## 687 688 689 690 691 692 693
## 481126.0 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 694 695 696 697 698 699 700
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 701 702 703 704 705 706 707
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 708 709 710 711 712 713 714
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 715 716 717 718 719 720 721
## 684451.6 407546.7 407546.7 488538.9 407546.7 407546.7 407546.7
## 722 723 724 725 726 727 728
## 407546.7 407546.7 407546.7 407546.7 480328.6 407546.7 407546.7
## 729 730 731 732 733 734 735
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 736 737 738 739 740 741 742
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 743 744 745 746 747 748 749
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 750 751 752 753 754 755 756
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 757 758 759 760 761 762 763
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 764 765 766 767 768 769 770
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 771 772 773 774 775 776 777
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 778 779 780 781 782 783 784
## 407546.7 407546.7 407546.7 407546.7 407546.7 504105.1 407546.7
## 785 786 787 788 789 790 791
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 792 793 794 795 796 797 798
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 799 800 801 802 803 804 805
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 806 807 808 809 810 811 812
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 813 814 815 816 817 818 819
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 820 821 822 823 824 825 826
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 827 828 829 830 831 832 833
## 407546.7 476678.2 407546.7 407546.7 407546.7 407546.7 407546.7
## 834 835 836 837 838 839 840
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 841 842 843 844 845 846 847
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 848 849 850 851 852 853 854
## 407546.7 407546.7 821572.0 407546.7 407546.7 407546.7 407546.7
## 855 856 857 858 859 860 861
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 862 863 864 865 866 867 868
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 869 870 871 872 873 874 875
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 876 877 878 879 880 881 882
## 407546.7 407546.7 547842.7 407546.7 407546.7 407546.7 407546.7
## 883 884 885 886 887 888 889
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 890 891 892 893 894 895 896
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 897 898 899 900 901 902 903
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 904 905 906 907 908 909 910
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 911 912 913 914 915 916 917
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 918 919 920 921 922 923 924
## 407546.7 407546.7 407546.7 407546.7 1316874.5 407546.7 407546.7
## 925 926 927 928 929 930 931
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 932 933 934 935 936 937 938
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 939 940 941 942 943 944 945
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 946 947 948 949 950 951 952
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 498309.4
## 953 954 955 956 957 958 959
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 960 961 962 963 964 965 966
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 967 968 969 970 971 972 973
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 974 975 976 977 978 979 980
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 981 982 983 984 985 986 987
## 407546.7 407546.7 407546.7 481126.0 407546.7 407546.7 407546.7
## 988 989 990 991 992 993 994
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 995 996 997 998 999 1000 1001
## 407546.7 407546.7 478902.1 407546.7 407546.7 407546.7 407546.7
## 1002 1003 1004 1005 1006 1007 1008
## 407546.7 407546.7 407546.7 407546.7 475195.6 407546.7 407546.7
## 1009 1010 1011 1012 1013 1014 1015
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1016 1017 1018 1019 1020 1021 1022
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1023 1024 1025 1026 1027 1028 1029
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1030 1031 1032 1033 1034 1035 1036
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1037 1038 1039 1040 1041 1042 1043
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1044 1045 1046 1047 1048 1049 1050
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1051 1052 1053 1054 1055 1056 1057
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1058 1059 1060 1061 1062 1063 1064
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1065 1066 1067 1068 1069 1070 1071
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1072 1073 1074 1075 1076 1077 1078
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1079 1080 1081 1082 1083 1084 1085
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1086 1087 1088 1089 1090 1091 1092
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1093 1094 1095 1096 1097 1098 1099
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1100 1101 1102 1103 1104 1105 1106
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1107 1108 1109 1110 1111 1112 1113
## 407546.7 473713.0 407546.7 407546.7 407546.7 407546.7 407546.7
## 1114 1115 1116 1117 1118 1119 1120
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1121 1122 1123 1124 1125 1126 1127
## 407546.7 407546.7 407546.7 485793.0 407546.7 407546.7 407546.7
## 1128 1129 1130 1131 1132 1133 1134
## 407546.7 407546.7 481181.9 407546.7 407546.7 407546.7 407546.7
## 1135 1136 1137 1138 1139 1140 1141
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1142 1143 1144 1145 1146 1147 1148
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1149 1150 1151 1152 1153 1154 1155
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1156 1157 1158 1159 1160 1161 1162
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1163 1164 1165 1166 1167 1168 1169
## 407546.7 407546.7 497812.1 407546.7 407546.7 407546.7 407546.7
## 1170 1171 1172 1173 1174 1175 1176
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1177 1178 1179 1180 1181 1182 1183
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1184 1185 1186 1187 1188 1189 1190
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1191 1192 1193 1194 1195 1196 1197
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1198 1199 1200 1201 1202 1203 1204
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1205 1206 1207 1208 1209 1210 1211
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1212 1213 1214 1215 1216 1217 1218
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1219 1220 1221 1222 1223 1224 1225
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1226 1227 1228 1229 1230 1231 1232
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1233 1234 1235 1236 1237 1238 1239
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1240 1241 1242 1243 1244 1245 1246
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1247 1248 1249 1250 1251 1252 1253
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1254 1255 1256 1257 1258 1259 1260
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1261 1262 1263 1264 1265 1266 1267
## 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7 407546.7
## 1268 1269 1270 1271 1272 1273 1274
## 407546.7 407546.7 407546.7 407546.7 407546.7 484120.0 481757.7
## 1275 1276 1277 1278 1279 1280 1281
## 407546.7 498098.7 480744.5 498175.8 483693.9 488538.9 407546.7
## 1282 1283 1284 1285 1286 1287 1288
## 489297.7 407546.7 483483.3 494469.3 498620.6 494469.3 498768.8
## 1289 1290 1291 1292 1293 1294 1295
## 479210.7 407546.7 555944.3 573835.8 495951.9 407546.7 499040.4
## 1296 1297 1298 1299 1300 1301 1302
## 407546.7 499067.7 488538.9 494720.8 407546.7 407546.7 482643.6
## 1303 1304 1305 1306 1307 1308 1309
## 491180.0 407546.7 497500.0 551762.6 569839.1 407546.7 488898.3
## 1310 1311 1312 1313 1314 1315 1316
## 407546.7 500399.7 500399.7 407546.7 480281.3 500399.7 500399.7
## 1317 1318 1319 1320 1321 1322 1323
## 494024.5 482053.0 598073.6 481377.9 778179.8 500761.0 407546.7
## 1324 1325 1326 1327 1328 1329 1330
## 407546.7 407546.7 499719.1 472230.4 407546.7 543289.2 501303.6
## 1331 1332 1333 1334 1335 1336 1337
## 478605.6 407546.7 539838.1 493138.4 532507.5 501585.8 501734.0
## 1338 1339 1340 1341 1342 1343 1344
## 487850.8 480429.0 483944.8 407546.7 479986.1 495951.9 501882.3
## 1345 1346 1347 1348 1349 1350 1351
## 481985.1 500399.7 407546.7 502301.3 488390.7 565063.3 407546.7
## 1352 1353 1354 1355 1356 1357 1358
## 494469.3 576826.2 407546.7 502771.8 407546.7 556348.8 483311.1
## 1359 1360 1361 1362 1363 1364 1365
## 482562.0 481167.2 472230.4 483085.5 479050.3 407546.7 493794.7
## 1366 1367 1368 1369 1370 1371 1372
## 407546.7 503364.9 503364.9 554705.2 503364.9 503364.9 552937.2
## 1373 1374 1375 1376 1377 1378 1379
## 407546.7 503364.9 503364.9 481905.4 481229.5 407546.7 407546.7
## 1380 1381 1382 1383 1384 1385 1386
## 407546.7 407546.7 481388.6 488538.9 407546.7 479543.1 407546.7
## 1387 1388 1389 1390 1391 1392 1393
## 482351.6 484626.7 407546.7 480576.6 482804.4 407546.7 476678.2
## 1394 1395 1396 1397 1398 1399 1400
## 556135.8 479394.5 505037.2 407546.7 407546.7 479331.0 407546.7
## 1401 1402 1403 1404 1405 1406 1407
## 488538.9 407546.7 492006.2 469943.3 505559.1 502387.0 503364.9
## 1408 1409 1410 1411 1412 1413 1414
## 488390.7 492403.3 481859.8 505974.2 506108.5 490762.8 479100.2
## 1415 1416 1417 1418 1419 1420 1421
## 407546.7 644924.2 489621.2 506330.1 486444.8 495842.2 407546.7
## 1422 1423 1424 1425 1426 1427 1428
## 573191.8 407546.7 407546.7 491459.6 407546.7 478952.6 490021.5
## 1429 1430 1431 1432 1433 1434 1435
## 566837.8 498027.5 407546.7 504926.9 476678.2 507597.0 407546.7
## 1436 1437 1438 1439 1440 1441 1442
## 562169.6 507664.4 507812.6 564236.5 499510.1 550958.4 569202.2
## 1443 1444 1445 1446 1447 1448 1449
## 482643.6 505957.0 407546.7 407546.7 501882.3 484120.0 497434.5
## 1450 1451 1452 1453 1454 1455 1456
## 508924.6 503364.9 407546.7 407546.7 407546.7 407546.7 569996.7
## 1457 1458 1459 1460 1461 1462 1463
## 407546.7 498505.3 487056.3 407546.7 498917.1 565122.4 674090.3
## 1464 1465 1466 1467 1468 1469 1470
## 633417.2 498692.3 407546.7 503364.9 407546.7 560862.5 407546.7
## 1471 1472 1473 1474 1475 1476 1477
## 495700.6 503197.7 407546.7 483107.7 478220.3 510777.8 407546.7
## 1478 1479 1480 1481 1482 1483 1484
## 494649.6 407546.7 407546.7 500459.7 555266.3 407546.7 503364.9
## 1485 1486 1487 1488 1489 1490 1491
## 407546.7 490666.5 503364.9 503351.7 407546.7 481314.8 564762.1
## 1492 1493 1494 1495 1496 1497 1498
## 483012.7 508553.9 563600.8 503986.6 479729.4 407546.7 568222.8
## 1499 1500 1501 1502 1503 1504 1505
## 634067.4 407546.7 407546.7 482830.9 491504.1 564486.8 504847.5
## 1506 1507 1508 1509 1510 1511 1512
## 407546.7 407546.7 407546.7 513313.1 485573.7 495581.3 502757.0
## 1513 1514 1515 1516 1517 1518 1519
## 505499.8 492986.7 565437.0 407546.7 479690.8 536309.5 407546.7
## 1520 1521 1522 1523 1524 1525 1526
## 488538.9 578846.0 407546.7 495951.9 514811.1 491504.1 515075.4
## 1527 1528 1529 1530 1531 1532 1533
## 503364.9 515225.6 596228.0 503446.7 618049.2 479336.4 515631.1
## 1534 1535 1536 1537 1538 1539 1540
## 477245.8 567113.0 581901.7 407546.7 478783.5 564179.3 477092.3
## 1541 1542 1543 1544 1545 1546 1547
## 496960.5 500095.7 561164.6 516708.2 501882.3 497404.8 407546.7
## 1548 1549 1550 1551 1552 1553 1554
## 407546.7 503305.6 568406.7 496609.8 583481.5 563582.3 569234.6
## 1555 1556 1557 1558 1559 1560 1561
## 407546.7 518112.8 561411.9 518190.8 407546.7 518190.8 476737.9
## 1562 1563 1564 1565 1566 1567 1568
## 569531.1 518339.1 494469.3 407546.7 509295.2 407546.7 407546.7
## 1569 1570 1571 1572 1573 1574 1575
## 476643.5 480172.0 509167.7 485596.4 407546.7 407546.7 567921.0
## 1576 1577 1578 1579 1580 1581 1582
## 495951.9 407546.7 488538.9 407546.7 495951.9 560380.2 407546.7
## 1583 1584 1585 1586 1587 1588 1589
## 520427.8 646768.5 520500.9 497434.5 513001.7 480429.0 572348.1
## 1590 1591 1592 1593 1594 1595 1596
## 476678.2 578068.2 563045.2 407546.7 561673.4 505089.3 482884.6
## 1597 1598 1599 1600 1601 1602 1603
## 511222.6 554469.4 407546.7 573734.6 508522.8 484832.4 489861.6
## 1604 1605 1606 1607 1608 1609 1610
## 611730.4 510777.8 499658.4 407546.7 407546.7 407546.7 407546.7
## 1611 1612 1613 1614 1615 1616 1617
## 584157.3 571469.5 407546.7 407546.7 523583.0 481126.0 566010.4
## 1618 1619 1620 1621 1622 1623 1624
## 524121.2 501882.3 567645.9 407546.7 478214.3 534249.0 642797.6
## 1625 1626 1627 1628 1629 1630 1631
## 510777.8 488538.9 407546.7 503364.9 407546.7 495030.1 525603.8
## 1632 1633 1634 1635 1636 1637 1638
## 525603.8 566539.9 481126.0 479934.2 493270.1 570038.7 570124.2
## 1639 1640 1641 1642 1643 1644 1645
## 577834.0 407546.7 657522.5 407546.7 503364.9 517091.9 578965.3
## 1646 1647 1648 1649 1650 1651 1652
## 563380.8 582874.5 512260.4 584328.5 582548.8 535460.1 558715.7
## 1653 1654 1655 1656 1657 1658 1659
## 407546.7 407546.7 579495.2 623723.3 609258.0 755181.4 658076.9
## 1660 1661 1662 1663 1664 1665 1666
## 569224.9 644153.3 698736.1 518190.8 580963.1 511601.5 573963.3
## 1667 1668 1669 1670 1671 1672 1673
## 407546.7 474966.3 479643.4 574481.6 516930.6 602741.2 548584.0
## 1674 1675 1676 1677 1678 1679 1680
## 729300.4 530051.6 494935.0 768573.8 407546.7 549541.5 1190397.7
## 1681 1682 1683 1684 1685 1686 1687
## 476276.8 599183.0 533832.2 513802.3 563996.1 407546.7 598250.8
## 1688 1689 1690 1691 1692 1693 1694
## 480399.5 557892.8 407546.7 664053.7 603047.2 692806.5 675606.0
## 1695 1696 1697 1698 1699 1700 1701
## 618230.5 527086.4 518190.8 407546.7 651559.4 518190.8 725753.9
## 1702 1703 1704 1705 1706 1707 1708
## 547306.8 699020.4 506808.4 675954.2 593349.5 865305.3 487056.3
## 1709 1710 1711 1712 1713 1714 1715
## 579909.3 605065.8 579950.5 597481.9 407546.7 643656.4 589731.9
## 1716 1717 1718 1719 1720 1721 1722
## 407546.7 552565.6 599123.7 655972.0 547405.6 748290.7 479113.5
## 1723 1724 1725 1726 1727 1728 1729
## 631483.5 562668.6 836398.0 510777.8 407546.7 750980.9 407546.7
## 1730 1731 1732 1733 1734 1735 1736
## 480294.3 563646.0 741997.9 407546.7 407546.7 407546.7 527679.4
## 1737 1738 1739 1740 1741 1742 1743
## 407546.7 713105.9 473713.0 562664.2 862556.2 407546.7 454591.9
## 1744 1745 1746 1747 1748 1749 1750
## 585874.7 575638.2 407546.7 628680.7 554063.6 407546.7 546730.7
## 1751 1752 1753 1754 1755 1756 1757
## 749857.1 407546.7 587573.3 482643.6 823601.9 771838.7 513743.0
## 1758 1759 1760 1761 1762 1763 1764
## 488538.9 637872.4 524388.0 470832.3 484120.0 664945.2 618613.6
## 1765 1766 1767 1768 1769 1770 1771
## 1066750.4 636415.8 407546.7 482643.6 601681.7 407546.7 407546.7
## 1772 1773 1774 1775 1776 1777 1778
## 687644.3 769153.4 470747.8 407546.7 407546.7 510777.8 641695.6
## 1779 1780 1781 1782 1783 1784 1785
## 503364.9 483529.4 645262.9 1036377.9 596018.1 503364.9 407546.7
## 1786 1787 1788 1789 1790 1791 1792
## 653817.5 475311.7 407546.7 407546.7 1008836.1 407546.7 564229.4
## 1793 1794 1795 1796 1797 1798 1799
## 501511.6 407546.7 529755.0 509234.1 542532.1 670792.6 533016.7
## 1800 1801 1802 1803 1804 1805 1806
## 641548.6 407546.7 488538.9 583580.5 626546.8 746988.7 525408.5
## 1807 1808 1809 1810 1811 1812 1813
## 620798.0 407546.7 689710.2 522342.1 495951.9 513772.7 604198.4
## 1814 1815 1816 1817 1818 1819 1820
## 447209.9 542844.4 407546.7 577025.3 573411.0 686252.5 407546.7
## 1821 1822 1823 1824 1825 1826 1827
## 545964.7 810863.0 473785.1 407546.7 654732.2 407546.7 538048.6
## 1828 1829 1830 1831 1832 1833 1834
## 466403.1 578426.7 515670.4 519221.6 407546.7 689473.9 639835.5
## 1835 1836 1837 1838 1839 1840 1841
## 407546.7 407546.7 605251.5 781795.0 407546.7 521142.0 561620.7
## 1842 1843 1844 1845 1846 1847 1848
## 725224.5 407546.7 578813.6 980322.3 630134.2 596979.5 518181.4
## 1849 1850 1851 1852 1853 1854 1855
## 407546.7 629381.5 407546.7 479525.1 697019.0 722089.1 481322.7
## 1856 1857 1858 1859 1860 1861 1862
## 829535.4 594604.6 554787.6 407546.7 633282.7 407546.7 407546.7
## 1863 1864 1865 1866 1867 1868 1869
## 575269.3 464631.4 501141.0 562668.6 664766.5 481167.2 583424.9
## 1870 1871 1872 1873 1874 1875 1876
## 525259.5 606596.0 593282.7 584357.1 612526.3 615360.2 560473.2
## 1877 1878 1879 1880 1881 1882 1883
## 587036.4 643489.3 832592.4 592306.3 822671.7 533016.7 509591.8
## 1884 1885 1886 1887 1888 1889 1890
## 646064.2 407546.7 668663.7 495907.4 407546.7 603151.1 600281.7
## 1891 1892 1893 1894 1895 1896 1897
## 597693.3 737744.4 510777.8 642123.8 497434.5 717986.4 560630.5
## 1898 1899 1900 1901 1902 1903 1904
## 555255.6 599391.1 509147.0 499658.4 595285.7 503216.6 519657.1
## 1905 1906 1907 1908 1909 1910 1911
## 529256.5 672730.7 746296.7 585162.7 713521.3 736477.1 489248.8
## 1912 1913 1914 1915 1916 1917 1918
## 617320.5 535981.9 850527.4 709302.0 717766.4 547918.7 642327.4
## 1919 1920 1921 1922 1923 1924 1925
## 407546.7 579439.1 685884.5 561682.6 758299.1 407546.7 407546.7
## 1926 1927 1928 1929 1930 1931 1932
## 618177.9 628834.9 687805.2 913171.8 605895.9 810457.5 561539.3
## 1933 1934 1935 1936 1937 1938 1939
## 503364.9 483786.6 595328.3 586344.2 407546.7 477239.9 473785.1
## 1940 1941 1942 1943 1944 1945 1946
## 698378.2 580672.2 719054.9 703442.4 742848.5 669062.4 407546.7
## 1947 1948 1949 1950 1951 1952 1953
## 592435.2 673002.6 686297.5 678773.9 407546.7 495803.6 559110.4
## 1954 1955 1956 1957 1958 1959 1960
## 653929.9 645265.9 407546.7 533016.7 407546.7 502727.4 715565.2
## 1961 1962 1963 1964 1965 1966 1967
## 582874.5 877230.5 616598.6 545248.1 509369.1 565859.0 522638.6
## 1968 1969 1970 1971 1972 1973 1974
## 531156.8 746151.2 407546.7 488074.2 579909.7 556330.9 599183.0
## 1975 1976 1977 1978 1979 1980 1981
## 536575.0 621231.0 1024380.4 663443.7 606184.9 523379.9 503364.9
## 1982 1983 1984 1985 1986 1987 1988
## 407546.7 488538.9 483367.4 680451.1 617462.0 632584.3 705929.7
## 1989 1990 1991 1992 1993 1994 1995
## 740837.2 470861.9 407546.7 568935.4 580279.9 1067499.5 599183.0
## 1996 1997 1998 1999 2000 2001 2002
## 531311.3 481258.0 477771.4 681276.1 675508.3 667294.9 529916.9
## 2003 2004 2005 2006 2007 2008 2009
## 576944.1 407546.7 407546.7 626455.1 482410.4 481126.0 573033.7
## 2010 2011 2012 2013 2014 2015 2016
## 739468.6 477472.7 929221.3 525519.7 407546.7 507751.8 652556.4
## 2017 2018 2019 2020 2021 2022 2023
## 482348.3 407546.7 584362.4 643660.8 638714.0 582874.5 668680.5
## 2024 2025 2026 2027 2028 2029 2030
## 497434.5 631649.6 530855.4 533016.7 563972.3 712184.4 633282.7
## 2031 2032 2033 2034 2035 2036 2037
## 574307.5 678775.0 547842.7 698026.1 730835.9 567960.0 588663.2
## 2038 2039 2040 2041 2042 2043 2044
## 561478.6 513743.0 407546.7 482053.0 407546.7 506775.6 477123.0
## 2045 2046 2047 2048 2049 2050 2051
## 503364.9 569008.8 995965.2 407546.7 619007.2 407546.7 407546.7
## 2052
## 510777.8actaul.pred<-data.frame(cbind(actuals=testdf$Target,predicteds=predicteddf))
cor(actaul.pred)## actuals predicteds
## actuals 1.0000000 0.5164176
## predicteds 0.5164176 1.0000000This gives a 51.6% accuracy.
However, if we try to predict the values by considering all the parameters, we will get a better accuracy.
fit2<-lm(Target~.,data=testdf)
summary(fit)##
## Call:
## lm(formula = Target ~ V3 + V4 + V5 + V6, data = df)
##
## Residuals:
## Min 1Q Median 3Q Max
## -730534 -115655 21453 83453 342453
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 4.075e+05 4.376e+03 93.141 < 2e-16 ***
## V3 5.134e+04 6.880e+03 7.463 1.25e-13 ***
## V4 1.483e-02 1.672e-03 8.867 < 2e-16 ***
## V5 8.100e+04 7.683e+03 10.543 < 2e-16 ***
## V6 -2.953e-03 2.140e-03 -1.380 0.168
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 158400 on 2048 degrees of freedom
## Multiple R-squared: 0.2534, Adjusted R-squared: 0.2519
## F-statistic: 173.8 on 4 and 2048 DF, p-value: < 2.2e-16predicteddf2 <- predict(fit2,testdf)
predicteddf2## 1 2 3 4 5 6 7 8
## 173024.2 182715.0 173444.6 166014.6 171255.5 167143.6 175219.4 166991.8
## 9 10 11 12 13 14 15 16
## 178961.7 179637.8 171484.0 194246.6 169201.7 183263.1 166742.9 184191.5
## 17 18 19 20 21 22 23 24
## 169476.7 173474.1 229863.4 182569.1 183905.7 179176.4 183396.9 184350.7
## 25 26 27 28 29 30 31 32
## 176895.2 183694.2 183171.2 179692.2 178076.3 182759.0 199466.5 172453.4
## 33 34 35 36 37 38 39 40
## 178752.4 187159.3 175087.8 182969.5 187660.2 186195.2 184948.3 182389.5
## 41 42 43 44 45 46 47 48
## 186262.3 179065.9 181897.0 191629.7 210995.2 206423.4 189381.7 181246.9
## 49 50 51 52 53 54 55 56
## 182841.9 188859.3 178851.8 194432.7 191151.3 199633.3 186700.3 199310.4
## 57 58 59 60 61 62 63 64
## 197991.9 193626.2 199834.7 197103.0 193455.3 192750.6 198953.6 203897.1
## 65 66 67 68 69 70 71 72
## 186215.9 192626.1 195870.8 182214.7 202505.9 182350.9 183366.3 185310.7
## 73 74 75 76 77 78 79 80
## 189157.5 191614.2 184812.8 199870.7 197691.7 192905.1 194156.3 201539.1
## 81 82 83 84 85 86 87 88
## 190959.4 203797.3 195240.8 190986.5 196473.6 192734.0 185517.1 200631.3
## 89 90 91 92 93 94 95 96
## 201267.9 206135.9 190253.5 201103.7 200597.0 198394.0 193259.6 195327.7
## 97 98 99 100 101 102 103 104
## 200047.4 192144.0 190497.0 212981.3 203696.8 200922.6 201310.7 200932.0
## 105 106 107 108 109 110 111 112
## 194475.2 202465.8 217837.8 212182.3 215780.0 207243.1 206531.0 199417.2
## 113 114 115 116 117 118 119 120
## 200059.0 210841.9 214640.2 196784.8 206551.2 206454.1 198830.2 220904.5
## 121 122 123 124 125 126 127 128
## 198362.8 201981.7 200384.9 213024.9 200052.0 203181.6 219289.2 215404.6
## 129 130 131 132 133 134 135 136
## 209324.6 206075.2 214247.2 219379.0 211848.2 212247.2 210524.8 214441.6
## 137 138 139 140 141 142 143 144
## 217798.9 218149.2 207165.6 211342.6 210304.6 204434.0 219323.9 233677.3
## 145 146 147 148 149 150 151 152
## 222973.2 220398.4 227657.5 223532.5 224343.2 212230.6 206694.9 218828.6
## 153 154 155 156 157 158 159 160
## 220234.9 208827.2 221992.7 223937.0 227487.2 208080.2 230370.8 222017.0
## 161 162 163 164 165 166 167 168
## 222342.2 225503.6 225235.7 224819.1 235716.1 233304.5 221495.8 232017.6
## 169 170 171 172 173 174 175 176
## 228452.6 227130.8 225522.9 213117.9 225853.7 219633.9 226756.2 218400.1
## 177 178 179 180 181 182 183 184
## 229550.0 227488.7 222164.6 226211.4 232820.8 212791.9 230938.6 241207.6
## 185 186 187 188 189 190 191 192
## 231301.5 217049.9 233949.4 221730.1 230577.9 235182.1 228914.5 221641.2
## 193 194 195 196 197 198 199 200
## 221024.9 221667.4 225878.5 230551.4 233595.5 222475.7 238107.2 243568.9
## 201 202 203 204 205 206 207 208
## 232765.0 233354.7 222195.3 233711.8 234659.3 231123.5 243351.0 239005.7
## 209 210 211 212 213 214 215 216
## 242110.4 229770.6 224098.5 234942.3 235471.2 231864.9 249173.6 237929.5
## 217 218 219 220 221 222 223 224
## 245915.9 226593.5 256729.2 240610.7 234202.7 244253.2 241073.5 244948.7
## 225 226 227 228 229 230 231 232
## 245388.4 247756.6 251065.4 247370.0 235903.1 227542.2 232605.8 254113.4
## 233 234 235 236 237 238 239 240
## 234493.0 249025.8 236503.0 236812.0 235030.5 244875.4 240568.3 249534.5
## 241 242 243 244 245 246 247 248
## 248973.7 238943.1 239509.8 251523.1 248803.8 250257.0 239856.8 231239.8
## 249 250 251 252 253 254 255 256
## 250269.9 246377.4 248672.7 249047.4 240608.4 243826.4 236912.7 255080.9
## 257 258 259 260 261 262 263 264
## 247124.5 256054.4 249158.1 256626.7 235958.9 258615.7 252812.2 255078.1
## 265 266 267 268 269 270 271 272
## 257379.3 254302.4 249543.0 254156.1 236435.5 257225.9 248967.1 255837.0
## 273 274 275 276 277 278 279 280
## 252057.9 248818.6 242509.7 245894.3 248604.9 255411.6 245598.8 256564.6
## 281 282 283 284 285 286 287 288
## 257990.0 251061.9 267548.1 256353.6 261272.9 261656.8 259237.4 271824.4
## 289 290 291 292 293 294 295 296
## 250736.3 264191.7 262054.5 261429.1 252537.9 257601.5 253069.0 258601.6
## 297 298 299 300 301 302 303 304
## 261314.6 253462.7 249745.7 275647.6 264302.0 266615.4 275705.6 264708.0
## 305 306 307 308 309 310 311 312
## 282498.9 296419.1 259481.3 250473.4 273844.7 266777.4 262758.5 249782.4
## 313 314 315 316 317 318 319 320
## 267630.7 259598.6 276249.6 268294.3 278497.9 270507.4 270577.6 271988.6
## 321 322 323 324 325 326 327 328
## 269688.3 271318.6 272024.3 255108.9 275755.0 260816.5 276418.0 281175.4
## 329 330 331 332 333 334 335 336
## 267631.7 262771.5 275016.8 267725.2 264772.6 273573.3 280610.0 269906.3
## 337 338 339 340 341 342 343 344
## 281769.9 262658.4 273763.6 259237.3 274713.2 268417.0 287482.3 260556.4
## 345 346 347 348 349 350 351 352
## 294206.0 273404.8 279156.3 279269.5 278291.9 281750.3 275788.9 270556.0
## 353 354 355 356 357 358 359 360
## 305934.7 308978.1 270449.3 266333.5 283780.7 276036.7 286624.6 290509.1
## 361 362 363 364 365 366 367 368
## 287411.9 284829.0 290687.6 283446.5 281916.1 273511.2 289238.6 279736.7
## 369 370 371 372 373 374 375 376
## 285277.7 293327.2 286311.8 282231.6 289623.8 289935.4 271064.6 289088.8
## 377 378 379 380 381 382 383 384
## 270853.1 285603.1 268920.7 284590.4 274848.8 298806.3 291622.1 311258.4
## 385 386 387 388 389 390 391 392
## 283648.3 296825.2 278215.8 296725.6 286866.9 277282.1 274153.0 288970.0
## 393 394 395 396 397 398 399 400
## 290816.9 312933.8 284747.0 293877.0 295346.5 294456.2 297849.1 292919.5
## 401 402 403 404 405 406 407 408
## 298640.1 279416.0 300639.3 302991.2 285808.7 293286.5 297404.2 304016.0
## 409 410 411 412 413 414 415 416
## 315608.9 297463.5 297230.5 295601.8 299259.8 301470.1 288976.1 298190.9
## 417 418 419 420 421 422 423 424
## 307012.6 307006.8 297867.2 297680.6 301040.8 301150.5 298729.8 309308.6
## 425 426 427 428 429 430 431 432
## 281751.4 305531.3 291056.8 288776.5 285837.1 311445.7 296985.7 290779.6
## 433 434 435 436 437 438 439 440
## 299196.0 287750.7 293394.2 302769.8 287757.2 294666.0 302434.9 293438.3
## 441 442 443 444 445 446 447 448
## 304791.1 301820.9 310288.1 291506.0 303283.1 310357.9 303590.4 303800.5
## 449 450 451 452 453 454 455 456
## 308139.9 316579.1 306565.6 314876.7 302420.2 316398.2 304379.6 320651.0
## 457 458 459 460 461 462 463 464
## 318610.0 296481.5 316771.8 307238.4 320229.2 309974.4 297867.9 299594.3
## 465 466 467 468 469 470 471 472
## 314138.6 328514.4 310516.4 296597.0 313899.3 318082.3 313706.6 319325.7
## 473 474 475 476 477 478 479 480
## 310310.4 324984.1 314286.8 314568.9 325387.7 315728.7 315871.1 325061.2
## 481 482 483 484 485 486 487 488
## 307846.3 331564.2 302612.8 320266.7 317669.7 323702.9 314652.1 324497.5
## 489 490 491 492 493 494 495 496
## 302901.5 321469.6 325559.8 317660.9 314280.0 303041.5 342082.1 339191.5
## 497 498 499 500 501 502 503 504
## 301786.1 328609.7 322279.1 343022.8 321007.6 312549.0 326767.5 317433.1
## 505 506 507 508 509 510 511 512
## 323647.8 337081.4 329456.2 330806.3 325874.5 340875.9 325289.4 331227.8
## 513 514 515 516 517 518 519 520
## 339790.0 334056.6 328138.6 341663.7 321923.3 327556.7 335873.4 319982.6
## 521 522 523 524 525 526 527 528
## 331663.1 317442.9 321873.8 312143.9 331010.9 332194.1 347006.5 331121.5
## 529 530 531 532 533 534 535 536
## 317206.3 315423.6 327343.2 334204.5 325182.3 332205.4 338092.2 332744.4
## 537 538 539 540 541 542 543 544
## 337679.1 346118.1 338884.7 328537.4 318849.5 338299.0 335849.5 317252.6
## 545 546 547 548 549 550 551 552
## 331716.8 334751.9 331615.1 338746.7 334051.5 351214.3 335803.4 341683.6
## 553 554 555 556 557 558 559 560
## 327098.4 337109.2 338454.9 357737.5 348827.8 331520.2 335398.2 346976.8
## 561 562 563 564 565 566 567 568
## 335055.6 332343.9 349883.4 320843.3 337423.3 340928.8 338299.6 342430.5
## 569 570 571 572 573 574 575 576
## 349168.0 326418.1 339822.5 346913.4 347008.6 337685.0 343899.0 352542.2
## 577 578 579 580 581 582 583 584
## 344715.3 358177.0 347028.6 337897.5 348142.5 349367.6 353128.7 329420.5
## 585 586 587 588 589 590 591 592
## 331807.5 340789.1 344257.2 356829.9 335668.7 330847.6 346672.7 347187.2
## 593 594 595 596 597 598 599 600
## 355112.1 365686.9 348158.5 351174.3 331086.7 358349.4 354218.5 360819.0
## 601 602 603 604 605 606 607 608
## 352555.0 333127.4 347380.5 356465.7 350868.0 368202.2 355883.4 349726.1
## 609 610 611 612 613 614 615 616
## 359292.6 350866.6 368782.4 354102.0 359541.4 356411.0 335193.8 350287.3
## 617 618 619 620 621 622 623 624
## 369781.3 341789.0 339684.6 353152.5 356240.1 369294.6 356799.4 369861.7
## 625 626 627 628 629 630 631 632
## 359230.0 351969.7 358922.2 351379.9 361141.7 362607.8 374094.4 355094.3
## 633 634 635 636 637 638 639 640
## 358117.8 363320.3 371325.7 368447.4 366158.9 369229.4 365891.8 398756.0
## 641 642 643 644 645 646 647 648
## 385131.4 343008.4 421296.6 342473.9 346275.1 343169.6 346261.5 347051.8
## 649 650 651 652 653 654 655 656
## 344935.0 344870.7 350632.3 347244.3 342769.1 343599.8 349639.0 345254.4
## 657 658 659 660 661 662 663 664
## 345890.2 347849.5 355943.6 349143.2 346839.6 347889.7 351356.9 348863.8
## 665 666 667 668 669 670 671 672
## 348360.5 348858.3 348574.0 348926.2 352805.5 378027.5 372600.8 349326.7
## 673 674 675 676 677 678 679 680
## 349425.3 350375.8 350124.0 353718.6 352096.5 352499.0 353633.3 353649.4
## 681 682 683 684 685 686 687 688
## 352110.7 353978.4 373772.4 355594.2 354506.3 354058.8 375662.4 353985.7
## 689 690 691 692 693 694 695 696
## 353197.3 354183.0 356787.0 357272.8 361441.6 357616.5 356915.8 360496.7
## 697 698 699 700 701 702 703 704
## 356739.0 359561.2 359514.2 365446.4 360071.5 365838.5 358527.5 365043.3
## 705 706 707 708 709 710 711 712
## 361752.9 361860.5 370269.0 364735.0 364352.6 369087.9 366163.2 362807.4
## 713 714 715 716 717 718 719 720
## 365386.0 361678.3 429000.0 364800.2 367765.1 387360.1 369591.7 374781.1
## 721 722 723 724 725 726 727 728
## 368841.8 365664.9 372463.9 369875.8 370391.0 429000.0 366501.5 369074.9
## 729 730 731 732 733 734 735 736
## 369208.9 368769.2 371735.5 375497.7 371121.5 378777.8 376436.6 376592.5
## 737 738 739 740 741 742 743 744
## 374847.8 376282.1 374319.9 387420.4 367053.8 370521.9 373926.3 369162.4
## 745 746 747 748 749 750 751 752
## 376899.7 369368.1 371770.2 372929.4 373763.0 374003.4 372616.5 374648.2
## 753 754 755 756 757 758 759 760
## 372673.5 378490.6 372681.8 376686.1 376188.6 374882.8 375544.3 376576.0
## 761 762 763 764 765 766 767 768
## 378699.1 378971.9 377900.5 376108.7 380632.8 378336.3 380251.2 383481.3
## 769 770 771 772 773 774 775 776
## 379442.5 378604.4 381204.7 378880.8 377078.1 386602.3 380073.2 379883.0
## 777 778 779 780 781 782 783 784
## 380713.7 383916.5 380328.0 385854.6 380597.6 381851.4 401685.3 391006.1
## 785 786 787 788 789 790 791 792
## 382417.7 383077.0 381381.4 384345.2 385420.9 384030.4 385764.5 383111.8
## 793 794 795 796 797 798 799 800
## 383823.9 387283.3 385290.2 386352.4 385691.1 385746.0 384529.6 392796.0
## 801 802 803 804 805 806 807 808
## 391388.9 388959.4 390498.7 390320.1 394517.9 392076.4 393111.4 389058.6
## 809 810 811 812 813 814 815 816
## 390326.6 391136.0 393576.1 390289.2 391023.1 392618.6 391601.2 397821.8
## 817 818 819 820 821 822 823 824
## 389806.0 392227.6 393674.3 390367.4 393132.5 393835.1 396673.9 396061.0
## 825 826 827 828 829 830 831 832
## 394526.5 392447.0 394294.2 408957.4 395154.9 397984.6 397683.0 404120.6
## 833 834 835 836 837 838 839 840
## 403965.4 405689.3 395508.1 404246.5 402821.6 402209.0 405278.3 406761.2
## 841 842 843 844 845 846 847 848
## 407605.0 408791.1 401778.2 400788.1 408135.0 409416.7 408067.7 411445.8
## 849 850 851 852 853 854 855 856
## 396519.3 498992.3 407440.9 409395.4 403661.0 403691.1 406019.8 410310.8
## 857 858 859 860 861 862 863 864
## 405854.7 410297.7 407575.2 406450.3 412411.9 407387.1 414380.4 411344.8
## 865 866 867 868 869 870 871 872
## 407995.9 410193.4 410280.1 406119.1 412891.6 411288.4 415196.8 413944.1
## 873 874 875 876 877 878 879 880
## 413331.1 407186.4 413995.6 413207.6 416414.4 445033.4 411781.3 416389.8
## 881 882 883 884 885 886 887 888
## 415628.0 417738.5 420403.5 412349.7 411163.2 421248.3 414002.5 419524.3
## 889 890 891 892 893 894 895 896
## 420997.2 418104.3 414273.6 414597.0 416142.2 419699.6 440388.7 418660.1
## 897 898 899 900 901 902 903 904
## 424144.4 419348.3 421341.7 424636.9 422118.0 421141.8 419234.0 419688.3
## 905 906 907 908 909 910 911 912
## 421125.6 419811.7 422558.2 421476.1 422999.7 419384.2 422273.7 425848.4
## 913 914 915 916 917 918 919 920
## 424376.6 423941.1 423193.9 426305.9 422161.0 426787.1 425437.6 428692.0
## 921 922 923 924 925 926 927 928
## 427262.6 439437.4 425068.9 427312.6 421125.4 427967.6 428648.8 430791.3
## 929 930 931 932 933 934 935 936
## 425522.5 426886.6 434792.5 425520.7 429052.5 438089.2 425473.3 436153.9
## 937 938 939 940 941 942 943 944
## 428127.0 430920.6 427761.1 431868.5 430612.9 431343.4 433792.0 435691.0
## 945 946 947 948 949 950 951 952
## 430509.8 435187.5 432899.8 433460.1 437739.2 432078.3 429439.9 452127.0
## 953 954 955 956 957 958 959 960
## 432179.0 434014.3 431211.7 432764.9 434341.3 433125.2 436902.0 435868.5
## 961 962 963 964 965 966 967 968
## 439745.4 434708.5 434189.1 438755.3 438099.4 435890.0 439793.3 442923.0
## 969 970 971 972 973 974 975 976
## 432216.9 439076.7 449583.0 439652.3 441876.2 438405.4 437301.4 438918.0
## 977 978 979 980 981 982 983 984
## 435999.2 442272.0 445850.1 442632.9 442069.2 447007.2 442328.7 400729.8
## 985 986 987 988 989 990 991 992
## 443121.7 441521.8 442421.4 449067.4 446123.4 442047.5 441468.8 443844.2
## 993 994 995 996 997 998 999 1000
## 439826.4 448557.5 443850.7 448614.5 466556.7 442196.4 441610.3 441994.9
## 1001 1002 1003 1004 1005 1006 1007 1008
## 450191.6 443767.8 445087.6 448467.6 445556.1 461000.4 449550.4 453053.3
## 1009 1010 1011 1012 1013 1014 1015 1016
## 454283.1 446476.6 447128.6 446421.3 447428.0 451594.7 456487.0 454337.9
## 1017 1018 1019 1020 1021 1022 1023 1024
## 456714.2 454166.6 449737.8 450385.2 456687.0 452942.8 446995.5 456359.1
## 1025 1026 1027 1028 1029 1030 1031 1032
## 453424.1 448676.7 456383.7 453128.6 454212.8 451429.5 449056.9 453586.6
## 1033 1034 1035 1036 1037 1038 1039 1040
## 455443.5 451832.4 455098.7 452323.7 453639.1 458779.3 454381.2 459609.0
## 1041 1042 1043 1044 1045 1046 1047 1048
## 456242.2 455049.9 456151.1 457241.7 454499.5 462217.6 456725.9 462038.1
## 1049 1050 1051 1052 1053 1054 1055 1056
## 461105.6 457888.1 462992.1 458807.6 460459.9 464221.1 456333.5 459263.6
## 1057 1058 1059 1060 1061 1062 1063 1064
## 462057.9 460404.2 466992.1 459840.9 457994.5 461191.3 462522.9 463206.3
## 1065 1066 1067 1068 1069 1070 1071 1072
## 461468.5 462268.1 471749.0 465739.7 467826.8 469828.6 465729.6 464707.0
## 1073 1074 1075 1076 1077 1078 1079 1080
## 461691.2 472736.8 467422.5 467491.0 463750.8 474937.6 468324.5 473111.4
## 1081 1082 1083 1084 1085 1086 1087 1088
## 467325.8 469634.3 468259.9 467640.6 468341.3 475339.1 467857.2 474895.2
## 1089 1090 1091 1092 1093 1094 1095 1096
## 468018.1 472489.0 470363.3 475421.6 474721.1 470890.9 470943.1 474997.5
## 1097 1098 1099 1100 1101 1102 1103 1104
## 469130.5 471643.3 470334.5 474679.4 470581.8 472772.6 475011.8 471570.5
## 1105 1106 1107 1108 1109 1110 1111 1112
## 472849.0 471883.0 480435.0 493373.5 475568.9 472058.7 477397.2 476298.6
## 1113 1114 1115 1116 1117 1118 1119 1120
## 476732.4 474380.3 474466.3 476381.5 481501.4 475344.7 475633.8 478360.0
## 1121 1122 1123 1124 1125 1126 1127 1128
## 479301.7 476452.8 474866.4 488006.3 477175.0 481355.1 484364.5 484334.4
## 1129 1130 1131 1132 1133 1134 1135 1136
## 478427.7 498358.5 479984.9 478235.6 479333.8 486594.3 480771.9 482415.8
## 1137 1138 1139 1140 1141 1142 1143 1144
## 482608.8 481633.8 488069.8 481873.3 482577.2 484035.0 485503.2 485188.2
## 1145 1146 1147 1148 1149 1150 1151 1152
## 486688.6 483541.4 485584.9 486498.1 487529.1 485952.1 488929.2 487971.5
## 1153 1154 1155 1156 1157 1158 1159 1160
## 494460.0 485419.5 487854.6 486708.6 485474.5 488605.5 486953.3 485793.2
## 1161 1162 1163 1164 1165 1166 1167 1168
## 489390.5 488182.5 488926.2 489269.5 508629.2 492113.3 488845.3 497826.4
## 1169 1170 1171 1172 1173 1174 1175 1176
## 488670.8 490736.5 494484.3 492071.2 491065.5 493911.6 494481.5 496670.7
## 1177 1178 1179 1180 1181 1182 1183 1184
## 494935.9 494918.8 495225.7 495154.5 493615.0 493550.7 497628.2 494420.2
## 1185 1186 1187 1188 1189 1190 1191 1192
## 495255.0 496716.6 498373.2 496229.0 510921.5 501834.7 496388.9 496729.4
## 1193 1194 1195 1196 1197 1198 1199 1200
## 496796.4 499911.2 503265.6 501909.7 498868.0 500334.0 500779.7 497419.1
## 1201 1202 1203 1204 1205 1206 1207 1208
## 496470.8 499052.9 502510.8 505935.4 500923.2 501404.2 503114.3 501831.5
## 1209 1210 1211 1212 1213 1214 1215 1216
## 504062.0 501357.2 502381.5 505109.1 501046.5 504478.5 503030.4 502225.6
## 1217 1218 1219 1220 1221 1222 1223 1224
## 504498.2 503207.3 502548.7 504680.4 505493.9 534243.0 505186.5 507509.7
## 1225 1226 1227 1228 1229 1230 1231 1232
## 514165.8 505394.6 505312.8 505493.5 507055.1 507241.7 508119.8 509810.6
## 1233 1234 1235 1236 1237 1238 1239 1240
## 508065.9 515662.0 507612.3 507221.9 509095.1 511372.1 509272.6 512353.6
## 1241 1242 1243 1244 1245 1246 1247 1248
## 516189.9 512038.3 512255.7 512811.6 512321.1 512332.1 512027.2 510619.7
## 1249 1250 1251 1252 1253 1254 1255 1256
## 514289.8 512568.1 514821.2 530815.1 514208.9 517985.5 513900.1 516404.0
## 1257 1258 1259 1260 1261 1262 1263 1264
## 514207.9 515163.2 516381.7 514674.3 519559.1 517270.6 516924.3 515675.8
## 1265 1266 1267 1268 1269 1270 1271 1272
## 519216.7 522649.6 519770.6 516492.9 517532.5 521471.6 517851.1 518890.3
## 1273 1274 1275 1276 1277 1278 1279 1280
## 544430.9 533924.8 535303.8 540282.2 538625.2 546401.2 545928.2 545894.4
## 1281 1282 1283 1284 1285 1286 1287 1288
## 541323.0 549865.3 524993.8 540580.3 542783.8 545267.3 543171.3 542813.5
## 1289 1290 1291 1292 1293 1294 1295 1296
## 553555.8 525740.0 559978.0 559606.5 548410.4 548138.1 547909.6 537840.6
## 1297 1298 1299 1300 1301 1302 1303 1304
## 545543.7 551736.4 543593.9 550068.6 539133.4 543495.2 545883.4 556800.8
## 1305 1306 1307 1308 1309 1310 1311 1312
## 547862.3 569184.7 558405.4 545082.1 548784.3 547292.8 551676.5 550203.1
## 1313 1314 1315 1316 1317 1318 1319 1320
## 561755.8 547808.7 551109.5 551169.7 559228.2 553525.3 582053.0 561972.6
## 1321 1322 1323 1324 1325 1326 1327 1328
## 615391.2 555139.0 538126.7 554014.1 536452.4 552018.6 569662.4 545080.3
## 1329 1330 1331 1332 1333 1334 1335 1336
## 566116.9 555395.5 570636.1 549680.6 567268.1 568195.6 562890.2 556987.3
## 1337 1338 1339 1340 1341 1342 1343 1344
## 557036.2 563858.8 555241.4 558137.7 553351.9 555086.4 561820.3 560397.3
## 1345 1346 1347 1348 1349 1350 1351 1352
## 551812.4 564816.3 543119.7 560742.2 577625.5 572720.1 570242.5 568157.1
## 1353 1354 1355 1356 1357 1358 1359 1360
## 573537.5 549140.3 566117.0 590895.5 569406.8 564395.2 568144.4 562202.5
## 1361 1362 1363 1364 1365 1366 1367 1368
## 573896.6 572591.4 562291.8 559115.0 570512.3 551205.6 566246.1 569856.0
## 1369 1370 1371 1372 1373 1374 1375 1376
## 581414.6 566097.6 568742.6 580774.1 551950.2 568793.7 571980.2 562094.0
## 1377 1378 1379 1380 1381 1382 1383 1384
## 563825.4 550703.7 568254.6 568007.4 556500.3 566080.5 585869.3 554690.0
## 1385 1386 1387 1388 1389 1390 1391 1392
## 569133.7 567844.3 571042.1 568436.2 576057.1 567152.7 566543.9 569120.2
## 1393 1394 1395 1396 1397 1398 1399 1400
## 586805.4 580036.1 568218.2 575618.4 577542.1 554826.6 570047.0 589699.1
## 1401 1402 1403 1404 1405 1406 1407 1408
## 581052.1 582815.3 588772.4 584507.9 583255.1 577708.7 584407.0 582732.1
## 1409 1410 1411 1412 1413 1414 1415 1416
## 587112.4 586470.5 582172.5 580760.8 585725.8 574103.3 574764.0 599869.3
## 1417 1418 1419 1420 1421 1422 1423 1424
## 586744.2 581990.3 594674.2 579308.3 571760.4 597648.3 584514.2 583622.0
## 1425 1426 1427 1428 1429 1430 1431 1432
## 592837.1 590898.0 578698.9 591182.5 603399.1 586625.6 580070.1 582918.3
## 1433 1434 1435 1436 1437 1438 1439 1440
## 597494.0 589116.8 587613.0 588912.2 584691.2 587853.9 592571.4 589140.4
## 1441 1442 1443 1444 1445 1446 1447 1448
## 614189.6 597959.4 584912.5 588277.0 597856.2 568017.2 591637.7 590161.2
## 1449 1450 1451 1452 1453 1454 1455 1456
## 590827.1 590634.9 593193.1 600379.3 586934.3 577400.6 588233.0 606022.1
## 1457 1458 1459 1460 1461 1462 1463 1464
## 582402.5 591852.1 602838.5 602205.0 590637.3 609674.8 625384.7 610434.8
## 1465 1466 1467 1468 1469 1470 1471 1472
## 602287.8 575139.8 592287.3 603741.3 607256.0 584352.0 606011.1 596008.6
## 1473 1474 1475 1476 1477 1478 1479 1480
## 593605.7 589114.3 597084.9 597112.9 592101.7 608994.9 597907.6 604987.0
## 1481 1482 1483 1484 1485 1486 1487 1488
## 606788.4 607169.1 616138.0 598299.9 606683.3 602491.7 600210.8 600209.8
## 1489 1490 1491 1492 1493 1494 1495 1496
## 602251.6 600954.3 610996.4 600178.2 622380.0 617539.8 607777.0 608832.7
## 1497 1498 1499 1500 1501 1502 1503 1504
## 609394.0 630483.1 630537.9 601028.2 634027.1 629470.8 604260.7 615822.6
## 1505 1506 1507 1508 1509 1510 1511 1512
## 605470.5 587680.7 593567.0 605584.8 609354.8 601832.3 622257.1 610414.5
## 1513 1514 1515 1516 1517 1518 1519 1520
## 613002.9 614624.6 621227.6 619497.1 603191.1 633931.6 589355.6 610040.2
## 1521 1522 1523 1524 1525 1526 1527 1528
## 631405.5 615960.0 607868.8 613307.2 620552.5 611063.9 611623.2 612496.3
## 1529 1530 1531 1532 1533 1534 1535 1536
## 622295.9 613807.0 642029.5 605230.8 618010.0 608883.7 627504.5 626725.5
## 1537 1538 1539 1540 1541 1542 1543 1544
## 634183.1 623775.6 621908.2 619427.8 613842.0 622683.8 634498.8 623665.7
## 1545 1546 1547 1548 1549 1550 1551 1552
## 625845.5 633147.2 608210.6 618336.4 617482.9 626895.9 616746.7 633127.7
## 1553 1554 1555 1556 1557 1558 1559 1560
## 638206.9 633160.4 610290.5 623739.6 632171.7 626347.9 603025.0 629381.3
## 1561 1562 1563 1564 1565 1566 1567 1568
## 623885.8 638362.1 631086.0 619350.5 607953.9 622494.3 601706.8 653537.7
## 1569 1570 1571 1572 1573 1574 1575 1576
## 622290.9 618018.0 623885.2 637953.6 642676.2 611848.2 640308.1 646345.0
## 1577 1578 1579 1580 1581 1582 1583 1584
## 621908.3 641887.6 623493.2 626712.4 649732.3 642210.4 628777.6 638946.8
## 1585 1586 1587 1588 1589 1590 1591 1592
## 632344.9 635717.9 632469.3 638007.0 642298.0 643374.6 642808.9 639264.5
## 1593 1594 1595 1596 1597 1598 1599 1600
## 613245.4 646243.2 636984.7 628048.3 632274.3 637186.9 619860.5 647701.8
## 1601 1602 1603 1604 1605 1606 1607 1608
## 636774.0 631390.2 635569.5 667619.0 633706.0 631494.5 632656.7 647473.2
## 1609 1610 1611 1612 1613 1614 1615 1616
## 628726.8 650532.6 664085.4 650272.4 620384.0 647233.6 639585.2 646766.5
## 1617 1618 1619 1620 1621 1622 1623 1624
## 649954.1 638785.9 650006.8 651228.7 638871.2 635791.0 651331.8 657805.4
## 1625 1626 1627 1628 1629 1630 1631 1632
## 653273.7 635993.8 637273.7 645827.7 630988.1 655347.6 644681.9 643221.2
## 1633 1634 1635 1636 1637 1638 1639 1640
## 658768.9 656690.2 634888.8 656299.3 657542.5 663169.6 659817.5 625723.6
## 1641 1642 1643 1644 1645 1646 1647 1648
## 674251.6 634028.8 652763.7 653447.4 657325.7 660480.8 671127.7 647074.6
## 1649 1650 1651 1652 1653 1654 1655 1656
## 673072.8 664484.8 662620.0 650375.6 682720.0 670079.3 657570.5 682707.2
## 1657 1658 1659 1660 1661 1662 1663 1664
## 666631.8 700362.7 676534.7 659850.9 670822.5 680907.1 666165.7 671759.0
## 1665 1666 1667 1668 1669 1670 1671 1672
## 679177.4 667054.3 660587.2 647963.7 689129.3 670983.6 677115.9 671024.4
## 1673 1674 1675 1676 1677 1678 1679 1680
## 663778.7 708087.7 671442.7 672463.7 712811.1 653163.8 679869.2 792612.8
## 1681 1682 1683 1684 1685 1686 1687 1688
## 670260.8 677275.6 666520.8 656832.1 666572.1 637757.6 669838.7 649889.0
## 1689 1690 1691 1692 1693 1694 1695 1696
## 679974.0 656537.2 690848.4 692248.1 721034.8 694534.0 704705.7 690365.4
## 1697 1698 1699 1700 1701 1702 1703 1704
## 673576.9 639057.0 696821.4 694133.7 697761.6 664698.8 700159.6 669822.1
## 1705 1706 1707 1708 1709 1710 1711 1712
## 688978.9 683799.9 732518.3 675253.1 692095.0 701853.9 673755.1 690483.2
## 1713 1714 1715 1716 1717 1718 1719 1720
## 651770.7 691425.6 700243.9 676656.2 687471.3 683680.9 694042.9 678971.3
## 1721 1722 1723 1724 1725 1726 1727 1728
## 718066.2 677459.5 719778.4 680277.9 750795.6 717728.2 655078.6 726645.3
## 1729 1730 1731 1732 1733 1734 1735 1736
## 654181.2 678995.8 671368.9 754779.6 674044.9 668308.5 654179.3 687547.6
## 1737 1738 1739 1740 1741 1742 1743 1744
## 658631.3 712138.7 719155.0 698963.8 774468.9 695660.9 682496.7 691383.5
## 1745 1746 1747 1748 1749 1750 1751 1752
## 739784.5 720283.4 703616.2 687033.5 690955.4 686319.1 727910.2 661675.5
## 1753 1754 1755 1756 1757 1758 1759 1760
## 699265.3 698210.7 753523.2 727956.6 680142.6 685570.1 715638.5 702241.2
## 1761 1762 1763 1764 1765 1766 1767 1768
## 694090.1 699256.8 724558.5 720403.4 780214.0 740510.6 720785.6 683025.0
## 1769 1770 1771 1772 1773 1774 1775 1776
## 695917.7 661080.8 667082.3 720283.2 752710.6 698031.4 663808.7 665415.2
## 1777 1778 1779 1780 1781 1782 1783 1784
## 685555.7 697648.9 708431.4 711825.4 731618.4 770851.1 697161.5 712647.1
## 1785 1786 1787 1788 1789 1790 1791 1792
## 748222.3 711135.8 681941.1 738010.4 693832.9 769992.3 669137.6 704240.2
## 1793 1794 1795 1796 1797 1798 1799 1800
## 709544.6 671701.7 704021.7 707366.5 706245.3 739901.3 694767.1 706423.6
## 1801 1802 1803 1804 1805 1806 1807 1808
## 674918.0 716586.8 706743.4 714932.1 768252.4 693882.3 726680.6 671969.6
## 1809 1810 1811 1812 1813 1814 1815 1816
## 740770.5 711290.6 707520.5 709893.8 717910.4 712186.0 720910.5 673642.0
## 1817 1818 1819 1820 1821 1822 1823 1824
## 715019.3 705323.5 731037.3 720310.3 708109.8 754190.0 748160.3 742421.6
## 1825 1826 1827 1828 1829 1830 1831 1832
## 722342.8 690225.3 706106.8 701897.8 734780.2 710969.2 713153.0 680344.3
## 1833 1834 1835 1836 1837 1838 1839 1840
## 732498.4 729338.5 676688.3 768292.6 711740.6 756906.9 683507.3 706625.4
## 1841 1842 1843 1844 1845 1846 1847 1848
## 714822.0 743705.6 682242.7 722222.4 908106.1 729877.4 749150.7 704300.5
## 1849 1850 1851 1852 1853 1854 1855 1856
## 698663.1 735936.4 720142.2 725982.2 743961.1 752417.1 702865.3 807723.0
## 1857 1858 1859 1860 1861 1862 1863 1864
## 742104.6 710915.7 732538.0 735253.6 714137.3 710265.8 720938.6 711736.6
## 1865 1866 1867 1868 1869 1870 1871 1872
## 720999.2 715812.5 731990.5 738301.8 728451.0 754044.7 732578.6 723433.4
## 1873 1874 1875 1876 1877 1878 1879 1880
## 725301.1 732728.9 745164.4 711398.3 723807.5 730000.3 778446.6 729020.9
## 1881 1882 1883 1884 1885 1886 1887 1888
## 777735.4 725067.4 712162.1 734186.4 715706.8 748782.6 735138.3 697409.1
## 1889 1890 1891 1892 1893 1894 1895 1896
## 732826.2 733246.3 736479.8 753738.4 715507.5 726247.5 713022.0 783530.8
## 1897 1898 1899 1900 1901 1902 1903 1904
## 720509.0 721984.0 739048.5 734768.9 765148.9 732315.1 746514.4 726656.2
## 1905 1906 1907 1908 1909 1910 1911 1912
## 730020.0 753490.4 758121.6 735613.6 760982.6 770802.9 718067.4 749642.1
## 1913 1914 1915 1916 1917 1918 1919 1920
## 744086.9 794738.7 749061.5 754665.8 775753.2 767236.6 706523.6 738450.4
## 1921 1922 1923 1924 1925 1926 1927 1928
## 754707.3 733647.3 785089.7 731554.1 703798.7 744889.1 752638.9 761556.7
## 1929 1930 1931 1932 1933 1934 1935 1936
## 791371.5 754196.5 779790.9 737341.3 728443.5 716742.5 744008.8 747031.1
## 1937 1938 1939 1940 1941 1942 1943 1944
## 711022.9 721826.9 731124.2 777290.1 768187.7 760849.4 769652.2 774828.4
## 1945 1946 1947 1948 1949 1950 1951 1952
## 761550.6 710966.1 746669.5 766895.2 768410.3 764663.5 735705.1 731397.9
## 1953 1954 1955 1956 1957 1958 1959 1960
## 747549.0 853710.1 745575.0 745194.0 735055.7 711631.0 731352.8 773024.0
## 1961 1962 1963 1964 1965 1966 1967 1968
## 751345.0 802837.8 761202.1 749183.0 734731.6 746385.4 737457.0 744985.6
## 1969 1970 1971 1972 1973 1974 1975 1976
## 780718.5 771426.3 725560.1 751237.5 752332.8 759363.9 744327.5 759337.9
## 1977 1978 1979 1980 1981 1982 1983 1984
## 855387.2 772931.6 758813.3 745861.5 746070.1 716753.1 736794.5 747943.2
## 1985 1986 1987 1988 1989 1990 1991 1992
## 774537.9 752821.0 766711.9 777213.2 773462.1 739235.5 721399.8 760644.1
## 1993 1994 1995 1996 1997 1998 1999 2000
## 769429.0 841781.6 770444.8 749967.1 743085.8 750748.0 779484.6 772414.9
## 2001 2002 2003 2004 2005 2006 2007 2008
## 775325.2 755940.2 758869.5 723494.9 738296.6 773950.5 736640.2 743733.7
## 2009 2010 2011 2012 2013 2014 2015 2016
## 776676.5 793713.9 753545.8 815039.5 750437.7 771569.4 748449.5 777661.3
## 2017 2018 2019 2020 2021 2022 2023 2024
## 745457.8 751439.6 763991.2 784920.4 771001.3 766101.6 778846.0 767346.5
## 2025 2026 2027 2028 2029 2030 2031 2032
## 779376.5 757557.1 757520.2 763971.6 792982.0 779676.6 767701.4 781883.4
## 2033 2034 2035 2036 2037 2038 2039 2040
## 758061.4 792944.3 783004.4 766004.2 771775.2 782096.6 757718.2 748036.1
## 2041 2042 2043 2044 2045 2046 2047 2048
## 751271.8 735890.5 803643.5 784010.5 771323.7 768278.5 847625.6 744093.2
## 2049 2050 2051 2052
## 815845.2 776364.4 753139.9 756706.4actaul.pred2<-data.frame(cbind(actuals=testdf$Target,predicteds=predicteddf2))
cor(actaul.pred2)## actuals predicteds
## actuals 1.000000 0.964452
## predicteds 0.964452 1.000000This gives a 96.4% accuracy.