EXCEL GRAPHING ECONOMICS DUE IN 12C HOURS

profiledeathstroke582
Forecasting.xlsx

Sheet1

Dominican Republic United States
Year population GDP per Capita RGDP (in millions) Consumption Imports (% of GDP) Exports Gvt Expenditure (% of GDP) RGDP per capita GDP GNI interst rate(%) GDP per Capita population Rgdp per capita RGDP(Billions) Imports(Billions) Gov Exp(billions) Exports(billions) Consumption GDP GNI interest rate (%)
1970 4499722 330.1315059019 16730.005859375 1349326995.9 27.9296661057 2.6407899857 3718.0087701807 1485500000 1476200100.00000 .. 5234.2966662115 205052000 24158 4954.436 58.522 341.397 3.949 839510000000 1073303000000 1074359000000 7.17
1971 4627202 360.152852631 18548.8515625 1530481307 27.7056969697 .. 4008.6539473531 1666500000 1664300000.00000 .. 5609.3825995252 207661000 24640 5117.603 68.285 373.053 0.621 908897000000 1164850000000 1162926000000 4.67
1972 4755464 417.9192608755 20476.94140625 1662631844 24.6432303512 .. 4305.9817940479 1987400000 2027000000.00000 .. 6094.0179898616 209896000 25659 5386.733 65.871 406.888 -3.373 993651000000 1279110000000 1280507000000 4.44
1973 4884460 480.053066255 23117.927734375 1930153083.4 26.9741726373 .. 4732.954663233 2344800000 2350899900.00000 .. 6726.3589559669 211909000 26851 5690.853 77.857 438.671 4.111 1088700000000 1425376000000 1431848000000 8.74
1974 5014187 583.484421303 24505.431640625 2516289090.6 34.9725535769 .. 4887.2193319924 2925700000 2920400000.00000 .. 7225.6913595257 213854000 26463 5660.091 80.916 492.803 -0.815 1195366000000 1545243000000 1553300000000 10.51
1975 5144632 699.6030036745 25778.060546875 2837833453.1 32.2351064125 .. 5010.67142351 3599200000 3597500100.00000 .. 7801.4566635644 215973000 26152 5648.462 88.038 576.370 15.977 1327272000000 1684904000000 1684554000000 5.82
1976 5275767 748.9906207003 27512.443359375 3341664894 29.1757360496 .. 5214.8708158217 3951500000 3945299900.00000 .. 8592.2535372761 218035000 27296 5952.809 96.312 616.563 -1.631 1462173000000 1873412000000 1869603000000 5.05
1977 5407496 848.2854171321 28881.923828125 3918026626.8 28.2774502409 .. 5341.090188162 4587100000 4507500200.00000 .. 9452.5765191451 220239000 28271 6228.077 91.564 665.149 -23.094 1615144000000 2081826000000 2082670000000 5.54
1978 5539596 854.6471619952 29501.349609375 4116448530 29.4660780669 .. 5325.5417198971 4734400000 4771400000.00000 .. 10564.9482220275 222585000 29522 6572.819 102.597 735.193 -25.366 1793022000000 2351599000000 2349856000000 7.94
1979 5671801 969.4980483272 30837.044921875 4640214740 31.7674819961 .. 5436.905300781 5498800000 5551200100.00000 .. 11674.1863100131 225055000 30123 6780.924 110.925 814.372 -22.545 1990125000000 2627334000000 2614202000000 11.20
1980 5803929 1164.9522246051 33295.58203125 6023883259 34.0691852159 .. 5736.7314505829 6761300000 6420500100.00000 .. 12574.7915062163 227225000 29701 6763.514 115.583 935.584 -13.056 2204317000000 2857307000000 2847055000000 13.35
1981 5935895 1273.8264406631 34720.25390625 6403238062.4 29.0016729927 .. 5849.2028424105 7561300000 6973899800.00000 .. 13976.1097504641 229466000 30152 6935.153 121.074 1056.450 -12.520 2440992000000 3207042000000 3201886000000 16.39
1982 6067769 1362.5106690779 35310.390625 7354424940.5 24.6350581803 1.5389100313 5819.336666409 8267400000 7709900300.00000 .. 14433.787727053 231664000 29327 6810.120 133.948 1170.241 -19.974 2625786000000 3343789000000 3371448000000 12.24
1983 6199657 1487.2758283241 36944.5390625 8079307093.5629 24.3630436197 1.4638299942 5959.126297229 9220600000 8324900100.00000 .. 15543.8937174925 233792000 30393 7122.291 135.723 1272.458 -51.642 2876998000000 3634038000000 3614168000000 9.09
1984 6331760 1831.0864593731 37407.4140625 10480846007.2476 30.0100742625 1.3345500231 5907.9014464383 11594000000 9972699700.00000 .. 17121.2254849995 235825000 32309 7637.704 134.813 1368.669 -102.727 3127068000000 4037613000000 4032292000000 10.23
1985 6464229 780.3858657862 36613.4296875 4403887507.74227 30.834095454 1.2101900578 5664.0056668011 5044592944.80499 4725492096.63947 .. 18236.8277265009 237924000 33357 7956.170 150.112 1496.843 -114.018 3403470000000 4338979000000 4310074000000 8.10
1986 6596967 928.0322487635 37902.953125 5141122183.54251 26.4865443993 .. 5745.5120095341 6122198120.02892 5877395034.94818 .. 19071.2271949295 240133000 34201 8231.664 154.159 1597.895 -131.869 3624267000000 4579631000000 4516535000000 6.80
1987 6729930 865.8317544847 41737.73046875 4904138355.83731 32.5309771644 .. 6201.8075178717 5826987099.45901 5527990480.64919 .. 20038.9410992658 242289000 35069 8516.418 162.350 1681.169 -144.770 3853172000000 4855215000000 4828878000000 6.66
1988 6863438 783.0354012705 42637.5859375 4254835463.16646 36.8708071414 .. 6212.2781523633 5374314928.42536 5052914306.74847 .. 21417.0119305191 244499000 36203 8872.154 179.630 1764.459 -109.393 4150467000000 5236438000000 5256093000000 7.57
1989 6997877 955.5173747605 44513.8671875 5507452448.45877 38.8010048829 .. 6361.0531004617 6686593059.93691 6373562712.93375 .. 22857.1544330056 246819000 37181 9197.998 206.325 1896.993 -86.741 4458186000000 5641580000000 5598381000000 9.21
1990 7133491 991.6148411498 42287.328125 5986263362.38169 38.587705766 .. 5927.999085581 7073675544.80847 6758924741.65132 .. 23888.6000088133 249623000 37460 9371.468 221.357 2055.425 -77.855 4757180000000 5963144000000 5902290000000 8.10
1991 7270413 1351.298500241 42611.67578125 8477270016.46005 43.0130958068 .. 5860.9704539825 9824498183.03263 9461132793.67679 -33.3567996091 24342.2589048189 252981000 36924 9361.322 254.345 2166.643 -28.614 4948306000000 6158129000000 6096750000000 5.69
1992 7408339 1566.5296234419 47091.4921875 10220400000 43.6610512256 .. 6356.5520135485 11605382504 11164249000.00000 21.570596557 25418.9907763319 256514000 37719 9691.069 268.837 2339.236 -34.738 5245942000000 6520327000000 6435469000000 3.52
1993 7546467 1733.3995364983 50492.765625 11179856000 41.6135643747 0.7739499807 6690.9145199999 13081042400 12384042400.00000 23.7238942594 26387.2937338171 259919000 38257 9957.746 280.306 2412.752 -65.174 5525024000000 6858559000000 6733768000000 3.02
1994 7683707 1905.9434963905 51655.70703125 12262958911.927 40.9493683539 0.8933699727 6722.7585631844 14644711384.8202 13962617074.06000 16.8374966126 27694.853416234 263126000 39319 10358.923 295.266 2485.781 -92.487 5829066000000 7287236000000 7170251000000 4.21
1995 7819239 2127.7480889331 54493.55078125 13874731934.7319 38.6712377579 1.0333000422 6969.1629557876 16637370839.1608 15868370839.16080 19.1788931964 28690.8757013347 266278000 39900 10636.979 328.493 2601.781 -89.761 6104333000000 7639749000000 7574691000000 5.83
1996 7952766 2293.7543814761 58379.65234375 15106821336.3523 37.7557811442 1.22724998 7340.7984522303 18241691857.3544 17516877243.86060 19.3541822662 29967.7127181749 269394000 40924 11038.266 343.737 2696.964 -96.377 6417484000000 8073122000000 8045907000000 5.30
1997 8084407 2476.0604030492 63052.515625 16351730342.2129 39.0109496254 .. 7799.275274612 20017480054.834 19222030487.15180 10.5575085815 31459.1389804773 272657000 42236 11529.157 335.949 2772.353 -101.971 6757318000000 8577554457000 8589268000000 5.46
1998 8214427 2638.3132701343 67472.9140625 17169209214.3834 41.6014184345 .. 8213.9526058847 21672231760.6491 20780878617.43440 17.968970875 32853.6769523009 275854000 43618 12045.824 298.611 2855.590 -162.711 7144856000000 9062818202000 9135464000000 5.35
1999 8343288 2653.2251238467 72003.921875 17538353205.6788 41.321651174 .. 8630.1613794226 22136621337.0889 21161260672.96520 20.4276191391 34513.5615037271 279040000 45190 12623.361 357.000 2995.354 -259.550 7630960000000 9630664202000 9689215000000 4.97
2000 8471317 2869.1781386102 76076.8984375 19544733182.9558 43.8025679544 1.8882900476 8980.5278727617 24305717541.6371 23264321904.64420 18.2742399975 36334.9087770589 282162411 46522 13138.035 396.027 3141.626 -381.074 8200138000000 10252345464000 10383669000000 6.24
2001 8598599 2977.4345100307 77453.328125 20470834581.511 38.6199477194 814348.992 1.9678299427 9007.668356787 25601765400.5153 24510208597.44770 17.1845223805 37133.2428088526 284968955 46502 13263.417 430.352 3363.233 -376.748 8603027000000 10581821399000 10743701000000 3.88
2002 8724974 3110.3254470274 81936.453125 21796441766.6117 37.9992727473 5229321.737 1.9140100479 9391.0254775544 27137508656.8522 25985430347.29720 17.8958206646 38023.1611144021 287625193 46842 13488.357 437.507 3586.026 -439.745 8987727000000 10936419054000 11054386000000 1.67
2003 8850317 2418.3504215888 81728.828125 17279707184.2016 42.2965050259 5496363.668 1.8446500301 9234.5650585171 21403167848.1444 20001897173.98710 -1.5509142082 39496.4858751381 290107933 47708 13865.519 408.387 3815.512 -521.955 9470095000000 11458243878000 11530051000000 1.13
2004 8974444 2487.3290610569 82801.109375 17507258474.1822 40.2039462963 5938370.49 .. 9226.3219175472 22322395368.0274 20508099190.80000 -8.6329557974 41712.8010675545 292805298 49101 14399.696 419.051 4018.669 -634.141 10065348000000 12213729147000 12314253000000 1.35
2005 9097262 3932.7844065085 90470.7734375 28700126804.6548 33.3224205843 6183383.171 .. 9944.835428231 35777570135.5225 33873701573.17020 17.3262411863 44114.7477810544 295516599 50343 14901.269 413.718 4302.853 -739.903 10709823000000 13036640230000 13167294000000 3.22
2006 9218681 4109.0335914539 100125.046875 30451543543.5435 35.541566366 6079883.885 .. 10861.1033264954 37879869897.8979 36027519171.17120 12.0345137142 46298.7314440927 298379912 51255 15315.943 465.924 4519.635 -786.453 11333686000000 13814611414000 14072268000000 4.97
2007 9338856 4707.7950524572 108610.3046875 35203901326.1224 35.1852086651 6793733.72 2.0467898846 11629.9367596524 43965420072.4107 41782447146.53060 7.6089705012 47975.9676958038 301231207 51786 15623.872 579.346 4833.454 -735.933 11905251000000 14451858656000 14543492000000 5.02
2008 9458079 5087.9832127843 112096.15625 40208725746.7549 37.4853165972 6421633.807 .. 11851.8946870712 48122547177.1881 46374331821.57810 8.6540143567 48382.5584490552 304093966 51367 15642.962 616.942 5261.859 -740.870 12328725000000 14712844084000 14684902000000 1.92
2009 9576736 5039.4031221299 113156.7578125 41010750780.4703 29.5813545047 4374407.643 .. 11815.7958841614 48261033298.2133 46539816384.45570 14.1429457947 47099.9804711343 306771529 49590 15236.262 669.563 5637.123 -419.153 12272811000000 14448933025000 14400953000000 0.16
2010 9695117 5555.3920139382 122593.640625 45387143577.223 33.3241838655 4766733.677 1.9004600048 12644.8851132998 53860175555.9961 51932177372.87930 6.3477206786 48466.6576026922 309327143 50517 15648.991 709.354 5834.437 -532.309 12695979000000 14992052727000 15127772000000 0.18
2011 9813219 5913.4266488549 126435.015625 49667350224.22 34.80269059 6112524.2 1.9002399445 12884.1530618037 58029750745.6495 55774581987.31350 6.9305871616 49882.5581321495 311583481 50932 15891.534 737.218 5871.728 -579.617 13152863000000 15542581104000 15835775000000 0.10
2012 9930916 6110.3665760338 129870.71875 51534750355.4144 33.8054960193 7168472.222 2.4975199699 13077.4158949688 60681537195.7996 58281926478.18050 9.8805881342 51602.9310457907 313877662 51730 16253.970 769.683 5841.901 -551.617 13522794000000 16197007349000 16669124000000 0.14
2013 10048226 6238.1323665836 136202.1875 52417189871.8731 31.5145973901 7960984.484 3.4805400372 13554.8491345637 62682163837.347 59708978487.60000 8.4997055837 53106.5367672165 316059947 52324 16553.348 797.215 5853.881 -479.394 13849216000000 16784849196000 17172525000000 0.11
2014 10165182 6608.8255013007 145805.078125 55141745334.6406 30.345032691 9927795.974 3.9637699127 14343.5777268917 67179914026.9623 63931917485.08030 9.1843296415 55049.9883272312 318386329 53139 16932.052 796.023 6001.639 -510.037 14388171000000 17527163695000 18054959000000 0.09
2015 10281675 6921.5205943278 155905.03125 57789942862.2171 28.4094954178 8384108.4 3.8162400723 15163.3883827295 71164825256.6849 68227916795.24040 12.1055454101 56863.3714957652 320738994 54189 17390.295 851.822 6160.906 -526.199 14905109000000 18238300569000 18696014000000 0.13
2016 10397738 7280.8836104123 166287.046875 61165645216.2625 27.6765917337 8744920.007 3.8505001068 15992.6175169061 75704720189.5607 72450765680.22160 12.8346073984 58021.4004997125 323071755 54706 17680.274 925.477 6378.499 -506.250 15430817000000 18745075687000 19069313000000 0.39
2017 10513111 7609.3532753402 174047.171875 64309500963.5127 26.5429400822 8855644.90237 3.9202699661 16555.2491431889 79997975621.8654 76203984074.69120 10.7819575518 60109.6557260477 325122128 55590 18079.084 1035.870 6598.185 -539.932 16083058000000 19542979183000 19966722000000 1.00
2018 10627147 8050.6440762342 186200.078125 67723440933.1448 28.5045350822 9395611.28139059 3.9284899235 17521.1727216157 85555378042.8196 81863297764.08810 .. 63064.4184096731 326838199 56910 18606.787 1118.749 6929.975 -596.186 16884571000000 20611860934000 20954575000000 1.83
2019 10738957 195607.203125 27.9418628797 4.0427699089 65279.5290260953 17539657000000 21433224697000 .. 21690015000000 328329953 57933 19032.672 1216.041 7286.800 -596.263 2.16
2020 10847904 ... 25.9979593929 .. 63543.577788724 .. 20936600000000 .. 433800329244 329484123 55685 18384.687 1379.809 9139.814 -651.187 0.37
ERROR:#N/A 0.08

Forecasting

Dominican Republic United States Dominican Republic United States
Year GDP per Capita Consumption GDP GNI GDP per Capita Consumption GDP GNI Savings Rate: 0.1337281081 Savings Rate: 0.1891862124
1970 330.1315059019 1349326995.9 1485500000 1476200100.00000 5234.2966662115 839510000000 1073303000000 1074359000000 n = 0.4710896982 n = 0.290872
1971 360.152852631 1530481307 1666500000 1664300000.00000 5609.3825995252 908897000000 1164850000000 1162926000000 depreciation = 0.05 depreciation = 0.05
1972 417.9192608755 1662631844 1987400000 2027000000.00000 6094.0179898616 993651000000 1279110000000 1280507000000 Law of Motion of Capital: k + s*y - (delta*k)
1973 480.053066255 1930153083.4 2344800000 2350899900.00000 6726.3589559669 1088700000000 1425376000000 1431848000000
1974 583.484421303 2516289090.6 2925700000 2920400000.00000 7225.6913595257 1195366000000 1545243000000 1553300000000 Steady State level of income per worker: 0.9309172199 steady state income per worker: 0.9776147976
1975 699.6030036745 2837833453.1 3599200000 3597500100.00000 7801.4566635644 1327272000000 1684904000000 1684554000000 How long will it take to double? 24.3460340168 How long to double 19.9290692571
1976 748.9906207003 3341664894 3951500000 3945299900.00000 8592.2535372761 1462173000000 1873412000000 1869603000000
1977 848.2854171321 3918026626.8 4587100000 4507500200.00000 9452.5765191451 1615144000000 2081826000000 2082670000000
1978 854.6471619952 4116448530 4734400000 4771400000.00000 10564.9482220275 1793022000000 2351599000000 2349856000000
1979 969.4980483272 4640214740 5498800000 5551200100.00000 11674.1863100131 1990125000000 2627334000000 2614202000000
1980 1164.9522246051 6023883259 6761300000 6420500100.00000 12574.7915062163 2204317000000 2857307000000 2847055000000
1981 1273.8264406631 6403238062.4 7561300000 6973899800.00000 13976.1097504641 2440992000000 3207042000000 3201886000000
1982 1362.5106690779 7354424940.5 8267400000 7709900300.00000 14433.787727053 2625786000000 3343789000000 3371448000000
1983 1487.2758283241 8079307093.5629 9220600000 8324900100.00000 15543.8937174925 2876998000000 3634038000000 3614168000000
1984 1831.0864593731 10480846007.2476 11594000000 9972699700.00000 17121.2254849995 3127068000000 4037613000000 4032292000000
1985 780.3858657862 4403887507.74227 5044592944.80499 4725492096.63947 18236.8277265009 3403470000000 4338979000000 4310074000000
1986 928.0322487635 5141122183.54251 6122198120.02892 5877395034.94818 19071.2271949295 3624267000000 4579631000000 4516535000000
1987 865.8317544847 4904138355.83731 5826987099.45901 5527990480.64919 20038.9410992658 3853172000000 4855215000000 4828878000000
1988 783.0354012705 4254835463.16646 5374314928.42536 5052914306.74847 21417.0119305191 4150467000000 5236438000000 5256093000000
1989 955.5173747605 5507452448.45877 6686593059.93691 6373562712.93375 22857.1544330056 4458186000000 5641580000000 5598381000000
1990 991.6148411498 5986263362.38169 7073675544.80847 6758924741.65132 23888.6000088133 4757180000000 5963144000000 5902290000000
1991 1351.298500241 8477270016.46005 9824498183.03263 9461132793.67679 24342.2589048189 4948306000000 6158129000000 6096750000000
1992 1566.5296234419 10220400000 11605382504 11164249000.00000 25418.9907763319 5245942000000 6520327000000 6435469000000
1993 1733.3995364983 11179856000 13081042400 12384042400.00000 26387.2937338171 5525024000000 6858559000000 6733768000000
1994 1905.9434963905 12262958911.927 14644711384.8202 13962617074.06000 27694.853416234 5829066000000 7287236000000 7170251000000
1995 2127.7480889331 13874731934.7319 16637370839.1608 15868370839.16080 28690.8757013347 6104333000000 7639749000000 7574691000000
1996 2293.7543814761 15106821336.3523 18241691857.3544 17516877243.86060 29967.7127181749 6417484000000 8073122000000 8045907000000
1997 2476.0604030492 16351730342.2129 20017480054.834 19222030487.15180 31459.1389804773 6757318000000 8577554457000 8589268000000
1998 2638.3132701343 17169209214.3834 21672231760.6491 20780878617.43440 32853.6769523009 7144856000000 9062818202000 9135464000000
1999 2653.2251238467 17538353205.6788 22136621337.0889 21161260672.96520 34513.5615037271 7630960000000 9630664202000 9689215000000
2000 2869.1781386102 19544733182.9558 24305717541.6371 23264321904.64420 36334.9087770589 8200138000000 10252345464000 10383669000000
2001 2977.4345100307 20470834581.511 25601765400.5153 24510208597.44770 37133.2428088526 8603027000000 10581821399000 10743701000000
2002 3110.3254470274 21796441766.6117 27137508656.8522 25985430347.29720 38023.1611144021 8987727000000 10936419054000 11054386000000
2003 2418.3504215888 17279707184.2016 21403167848.1444 20001897173.98710 39496.4858751381 9470095000000 11458243878000 11530051000000
2004 2487.3290610569 17507258474.1822 22322395368.0274 20508099190.80000 41712.8010675545 10065348000000 12213729147000 12314253000000
2005 3932.7844065085 28700126804.6548 35777570135.5225 33873701573.17020 44114.7477810544 10709823000000 13036640230000 13167294000000
2006 4109.0335914539 30451543543.5435 37879869897.8979 36027519171.17120 46298.7314440927 11333686000000 13814611414000 14072268000000
2007 4707.7950524572 35203901326.1224 43965420072.4107 41782447146.53060 47975.9676958038 11905251000000 14451858656000 14543492000000
2008 5087.9832127843 40208725746.7549 48122547177.1881 46374331821.57810 48382.5584490552 12328725000000 14712844084000 14684902000000
2009 5039.4031221299 41010750780.4703 48261033298.2133 46539816384.45570 47099.9804711343 12272811000000 14448933025000 14400953000000
2010 5555.3920139382 45387143577.223 53860175555.9961 51932177372.87930 48466.6576026922 12695979000000 14992052727000 15127772000000
2011 5913.4266488549 49667350224.22 58029750745.6495 55774581987.31350 49882.5581321495 13152863000000 15542581104000 15835775000000
2012 6110.3665760338 51534750355.4144 60681537195.7996 58281926478.18050 51602.9310457907 13522794000000 16197007349000 16669124000000
2013 6238.1323665836 52417189871.8731 62682163837.347 59708978487.60000 53106.5367672165 13849216000000 16784849196000 17172525000000
2014 6608.8255013007 55141745334.6406 67179914026.9623 63931917485.08030 55049.9883272312 14388171000000 17527163695000 18054959000000
2015 6921.5205943278 57789942862.2171 71164825256.6849 68227916795.24040 56863.3714957652 14905109000000 18238300569000 18696014000000
2016 7280.8836104123 61165645216.2625 75704720189.5607 72450765680.22160 58021.4004997125 15430817000000 18745075687000 19069313000000
2017 7609.3532753402 64309500963.5127 79997975621.8654 76203984074.69120 60109.6557260477 16083058000000 19542979183000 19966722000000
2018 8050.6440762342 67723440933.1448 85555378042.8196 81863297764.08810 63064.4184096731 16884571000000 20611860934000 20954575000000
2019 8282.1171305092 70147197128.7594 88941299733.5018 84871455782.15380 65279.5290260953 17539657000000 21433224697000 21690015000000
2020 7268.1969096591 64905431757.9103 78844702329.0785 74984131332.43110 63543.577788724 .. 20936600000000 8883709420000
Mean 2941.9918148609 22175042388.7563 27011653528.4329 25787259712.8008 31196.5943606831 7173358360000 9040569281431.37 8883709420000
Savings Rate 0.1337281081 Savings Rate = 0.1891862124
growth rate GDP per capita 0.0287521162 2.8752116239 0.0351245706 3.5124570594