EXCEL GRAPHING ECONOMICS DUE IN 12C HOURS

Forecasting2.pdf

Home >Business & Finance homework help >Economics homework help >EXCEL GRAPHING ECONOMICS DUE IN 12C HOURS

Dominican Republic Year popula1on GDP per Capita RGDP (in millions) Consump1on

1970 4499722 330.13150590192 16730.005859375 1349326995.9 1971 4627202 360.152852631028 18548.8515625 1530481307 1972 4755464 417.91926087549 20476.94140625 1662631844 1973 4884460 480.053066255021 23117.927734375 1930153083.4 1974 5014187 583.484421302995 24505.431640625 2516289090.6 1975 5144632 699.60300367451 25778.060546875 2837833453.1 1976 5275767 748.99062070027 27512.443359375 3341664894 1977 5407496 848.28541713207 28881.923828125 3918026626.8 1978 5539596 854.647161995207 29501.349609375 4116448530 1979 5671801 969.498048327154 30837.044921875 4640214740 1980 5803929 1164.95222460509 33295.58203125 6023883259 1981 5935895 1273.82644066312 34720.25390625 6403238062.4 1982 6067769 1362.51066907788 35310.390625 7354424940.5 1983 6199657 1487.27582832405 36944.5390625 8079307093.5629 1984 6331760 1831.08645937307 37407.4140625 10480846007.2476 1985 6464229 780.385865786157 36613.4296875 4403887507.74227 1986 6596967 928.032248763549 37902.953125 5141122183.54251 1987 6729930 865.831754484669 41737.73046875 4904138355.83731 1988 6863438 783.035401270523 42637.5859375 4254835463.16646 1989 6997877 955.517374760504 44513.8671875 5507452448.45877 1990 7133491 991.614841149791 42287.328125 5986263362.38169 1991 7270413 1351.29850024099 42611.67578125 8477270016.46005 1992 7408339 1566.52962344191 47091.4921875 10220400000 1993 7546467 1733.39953649834 50492.765625 11179856000 1994 7683707 1905.94349639051 51655.70703125 12262958911.927 1995 7819239 2127.74808893306 54493.55078125 13874731934.7319 1996 7952766 2293.75438147613 58379.65234375 15106821336.3523 1997 8084407 2476.06040304923 63052.515625 16351730342.2129 1998 8214427 2638.31327013425 67472.9140625 17169209214.3834 1999 8343288 2653.22512384672 72003.921875 17538353205.6788 2000 8471317 2869.17813861021 76076.8984375 19544733182.9558 2001 8598599 2977.43451003068 77453.328125 20470834581.511 2002 8724974 3110.32544702737 81936.453125 21796441766.6117 2003 8850317 2418.35042158878 81728.828125 17279707184.2016 2004 8974444 2487.32906105687 82801.109375 17507258474.1822 2005 9097262 3932.78440650852 90470.7734375 28700126804.6548 2006 9218681 4109.03359145391 100125.046875 30451543543.5435 2007 9338856 4707.79505245725 108610.3046875 35203901326.1224 2008 9458079 5087.98321278434 112096.15625 40208725746.7549 2009 9576736 5039.40312212985 113156.7578125 41010750780.4703 2010 9695117 5555.39201393816 122593.640625 45387143577.223 2011 9813219 5913.42664885493 126435.015625 49667350224.22 2012 9930916 6110.36657603383 129870.71875 51534750355.4144 2013 10048226 6238.13236658362 136202.1875 52417189871.8731 2014 10165182 6608.82550130065 145805.078125 55141745334.6406 2015 10281675 6921.52059432776 155905.03125 57789942862.2171 2016 10397738 7280.88361041225 166287.046875 61165645216.2625 2017 10513111 7609.35327534023 174047.171875 64309500963.5127

2018 10627147 8050.64407623416 186200.078125 67723440933.1448 2019 10738957 195607.203125 27.9418628796634 2020 10847904 ... 25.9979593928743

Imports (% of GDP) Exports Gvt Expenditure (% of GDP) 27.9296661056883 2.64078998565674

27.705696969697 .. 24.6432303512126 .. 26.9741726373251 .. 34.9725535769218 .. 32.2351064125361 .. 29.1757360496014 .. 28.2774502408929 .. 29.4660780669145 .. 31.7674819960719 .. 34.0691852158609 .. 29.0016729927393 .. 24.6350581803227 1.53891003131866 24.3630436197211 1.46382999420166 30.0100742625496 1.33455002307892 30.8340954540244 1.21019005775452 26.4865443992644 .. 32.5309771643843 .. 36.8708071414438 .. 38.8010048828816 .. 38.5877057660046 .. 43.0130958068007 ..

43.661051225615 .. 41.6135643746557 0.773949980735779 40.9493683538865 0.893369972705841

38.671237757911 1.0333000421524 37.755781144158 1.22724997997284

39.0109496254079 .. 41.6014184344939 .. 41.3216511739672 .. 43.8025679543791 1.88829004764557 38.6199477193794 814348.992 1.96782994270325 37.9992727472887 5229321.737 1.9140100479126 42.2965050258884 5496363.668 1.84465003013611 40.2039462963058 5938370.49 .. 33.3224205843488 6183383.171 .. 35.5415663659558 6079883.885 .. 35.1852086651157 6793733.72 2.04678988456726 37.4853165972225 6421633.807 .. 29.5813545046849 4374407.643 .. 33.3241838654991 4766733.677 1.90046000480652 34.8026905899502 6112524.2 1.90023994445801 33.8054960193236 7168472.222 2.49751996994019 31.5145973901069 7960984.484 3.48054003715515 30.3450326909749 9927795.974 3.96376991271973

28.409495417775 8384108.4 3.81624007225037 27.6765917337038 8744920.007 3.85050010681152 26.5429400821881 8855644.90237 3.92026996612549

28.5045350822178 9395611.28139059 3.92848992347717 4.04276990890503 65279.5290260953

.. 63543.577788724

RGDP per capita GDP GNI interst rate(%) 3718.00877018069 1485500000 1476200100.00000 .. 4008.65394735307 1666500000 1664300000.00000 .. 4305.98179404786 1987400000 2027000000.00000 .. 4732.95466323299 2344800000 2350899900.00000 ..

4887.2193319924 2925700000 2920400000.00000 .. 5010.67142350998 3599200000 3597500100.00000 .. 5214.87081582166 3951500000 3945299900.00000 .. 5341.09018816195 4587100000 4507500200.00000 .. 5325.54171989708 4734400000 4771400000.00000 ..

5436.905300781 5498800000 5551200100.00000 .. 5736.73145058287 6761300000 6420500100.00000 .. 5849.20284241045 7561300000 6973899800.00000 .. 5819.33666640902 8267400000 7709900300.00000 .. 5959.12629722902 9220600000 8324900100.00000 .. 5907.90144643827 11594000000 9972699700.00000 ..

5664.0056668011 5044592944.80499 4725492096.63947 .. 5745.51200953408 6122198120.02892 5877395034.94818 .. 6201.80751787166 5826987099.45901 5527990480.64919 .. 6212.27815236329 5374314928.42536 5052914306.74847 .. 6361.05310046175 6686593059.93691 6373562712.93375 .. 5927.99908558096 7073675544.80847 6758924741.65132 .. 5860.97045398246 9824498183.03263 9461132793.67679 -33.356799609093 6356.55201354852 11605382504 11164249000.00000 21.5705965570283 6690.91451999989 13081042400 12384042400.00000 23.7238942594425 6722.75856318441 14644711384.8202 13962617074.06000 16.8374966126071 6969.16295578764 16637370839.1608 15868370839.16080 19.1788931963517 7340.79845223033 18241691857.3544 17516877243.86060 19.3541822661529 7799.27527461198 20017480054.834 19222030487.15180 10.5575085815306 8213.95260588474 21672231760.6491 20780878617.43440 17.9689708749836

8630.1613794226 22136621337.0889 21161260672.96520 20.4276191390512 8980.5278727617 24305717541.6371 23264321904.64420 18.2742399974908

9007.66835678696 25601765400.5153 24510208597.44770 17.184522380505 9391.02547755443 27137508656.8522 25985430347.29720 17.8958206645937 9234.56505851711 21403167848.1444 20001897173.98710 -1.55091420822536

9226.3219175472 22322395368.0274 20508099190.80000 -8.63295579738247 9944.83542823104 35777570135.5225 33873701573.17020 17.3262411862842 10861.1033264954 37879869897.8979 36027519171.17120 12.0345137141633 11629.9367596524 43965420072.4107 41782447146.53060 7.60897050122327 11851.8946870712 48122547177.1881 46374331821.57810 8.65401435672139 11815.7958841614 48261033298.2133 46539816384.45570 14.1429457947122 12644.8851132998 53860175555.9961 51932177372.87930 6.34772067859711 12884.1530618037 58029750745.6495 55774581987.31350 6.93058716155887 13077.4158949688 60681537195.7996 58281926478.18050 9.88058813419776 13554.8491345637 62682163837.347 59708978487.60000 8.4997055837097 14343.5777268917 67179914026.9623 63931917485.08030 9.18432964152428 15163.3883827295 71164825256.6849 68227916795.24040 12.105545410125 15992.6175169061 75704720189.5607 72450765680.22160 12.834607398428 16555.2491431889 79997975621.8654 76203984074.69120 10.7819575518065

17521.1727216157 85555378042.8196 81863297764.08810 .. 17539657000000 21433224697000 ..

.. 20936600000000 ..

United States GDP per Capita popula1on Rgdp per capita RGDP(Billions)

5234.2966662115 205052000 24158 4954.436 5609.38259952519 207661000 24640 5117.603 6094.01798986165 209896000 25659 5386.733 6726.35895596695 211909000 26851 5690.853 7225.69135952566 213854000 26463 5660.091 7801.45666356443 215973000 26152 5648.462 8592.25353727612 218035000 27296 5952.809 9452.57651914511 220239000 28271 6228.077 10564.9482220275 222585000 29522 6572.819 11674.1863100131 225055000 30123 6780.924 12574.7915062163 227225000 29701 6763.514 13976.1097504641 229466000 30152 6935.153

14433.787727053 231664000 29327 6810.120 15543.8937174925 233792000 30393 7122.291 17121.2254849995 235825000 32309 7637.704 18236.8277265009 237924000 33357 7956.170 19071.2271949295 240133000 34201 8231.664 20038.9410992658 242289000 35069 8516.418 21417.0119305191 244499000 36203 8872.154 22857.1544330056 246819000 37181 9197.998 23888.6000088133 249623000 37460 9371.468 24342.2589048189 252981000 36924 9361.322 25418.9907763319 256514000 37719 9691.069 26387.2937338171 259919000 38257 9957.746

27694.853416234 263126000 39319 10358.923 28690.8757013347 266278000 39900 10636.979 29967.7127181749 269394000 40924 11038.266 31459.1389804773 272657000 42236 11529.157 32853.6769523009 275854000 43618 12045.824 34513.5615037271 279040000 45190 12623.361 36334.9087770589 282162411 46522 13138.035 37133.2428088526 284968955 46502 13263.417 38023.1611144021 287625193 46842 13488.357 39496.4858751381 290107933 47708 13865.519 41712.8010675545 292805298 49101 14399.696 44114.7477810544 295516599 50343 14901.269 46298.7314440927 298379912 51255 15315.943 47975.9676958038 301231207 51786 15623.872 48382.5584490552 304093966 51367 15642.962 47099.9804711343 306771529 49590 15236.262 48466.6576026922 309327143 50517 15648.991 49882.5581321495 311583481 50932 15891.534 51602.9310457907 313877662 51730 16253.970 53106.5367672165 316059947 52324 16553.348 55049.9883272312 318386329 53139 16932.052 56863.3714957652 320738994 54189 17390.295 58021.4004997125 323071755 54706 17680.274 60109.6557260477 325122128 55590 18079.084

63064.4184096731 326838199 56910 18606.787 21690015000000 328329953 57933 19032.672

433800329244 329484123 55685 18384.687

Imports(Billions) Gov Exp(billions) Exports(billions) Consump1on 58.522 341.397 3.949 839510000000 68.285 373.053 0.621 908897000000 65.871 406.888 -3.373 993651000000 77.857 438.671 4.111 1088700000000 80.916 492.803 -0.815 1195366000000 88.038 576.370 15.977 1327272000000 96.312 616.563 -1.631 1462173000000 91.564 665.149 -23.094 1615144000000

102.597 735.193 -25.366 1793022000000 110.925 814.372 -22.545 1990125000000 115.583 935.584 -13.056 2204317000000 121.074 1056.450 -12.520 2440992000000 133.948 1170.241 -19.974 2625786000000 135.723 1272.458 -51.642 2876998000000 134.813 1368.669 -102.727 3127068000000 150.112 1496.843 -114.018 3403470000000 154.159 1597.895 -131.869 3624267000000 162.350 1681.169 -144.770 3853172000000 179.630 1764.459 -109.393 4150467000000 206.325 1896.993 -86.741 4458186000000 221.357 2055.425 -77.855 4757180000000 254.345 2166.643 -28.614 4948306000000 268.837 2339.236 -34.738 5245942000000 280.306 2412.752 -65.174 5525024000000 295.266 2485.781 -92.487 5829066000000 328.493 2601.781 -89.761 6104333000000 343.737 2696.964 -96.377 6417484000000 335.949 2772.353 -101.971 6757318000000 298.611 2855.590 -162.711 7144856000000 357.000 2995.354 -259.550 7630960000000 396.027 3141.626 -381.074 8200138000000 430.352 3363.233 -376.748 8603027000000 437.507 3586.026 -439.745 8987727000000 408.387 3815.512 -521.955 9470095000000 419.051 4018.669 -634.141 10065348000000 413.718 4302.853 -739.903 10709823000000 465.924 4519.635 -786.453 11333686000000 579.346 4833.454 -735.933 11905251000000 616.942 5261.859 -740.870 12328725000000 669.563 5637.123 -419.153 12272811000000 709.354 5834.437 -532.309 12695979000000 737.218 5871.728 -579.617 13152863000000 769.683 5841.901 -551.617 13522794000000 797.215 5853.881 -479.394 13849216000000 796.023 6001.639 -510.037 14388171000000 851.822 6160.906 -526.199 14905109000000 925.477 6378.499 -506.250 15430817000000

1035.870 6598.185 -539.932 16083058000000

1118.749 6929.975 -596.186 16884571000000 1216.041 7286.800 -596.263 1379.809 9139.814 -651.187

GDP GNI interest rate (%) 1073303000000 1074359000000 7.17 1164850000000 1162926000000 4.67 1279110000000 1280507000000 4.44 1425376000000 1431848000000 8.74 1545243000000 1553300000000 10.51 1684904000000 1684554000000 5.82 1873412000000 1869603000000 5.05 2081826000000 2082670000000 5.54 2351599000000 2349856000000 7.94 2627334000000 2614202000000 11.20 2857307000000 2847055000000 13.35 3207042000000 3201886000000 16.39 3343789000000 3371448000000 12.24 3634038000000 3614168000000 9.09 4037613000000 4032292000000 10.23 4338979000000 4310074000000 8.10 4579631000000 4516535000000 6.80 4855215000000 4828878000000 6.66 5236438000000 5256093000000 7.57 5641580000000 5598381000000 9.21 5963144000000 5902290000000 8.10 6158129000000 6096750000000 5.69 6520327000000 6435469000000 3.52 6858559000000 6733768000000 3.02 7287236000000 7170251000000 4.21 7639749000000 7574691000000 5.83 8073122000000 8045907000000 5.30 8577554457000 8589268000000 5.46 9062818202000 9135464000000 5.35 9630664202000 9689215000000 4.97 1025234546400010383669000000 6.24 1058182139900010743701000000 3.88 1093641905400011054386000000 1.67 1145824387800011530051000000 1.13 1221372914700012314253000000 1.35 1303664023000013167294000000 3.22 1381461141400014072268000000 4.97 1445185865600014543492000000 5.02 1471284408400014684902000000 1.92 1444893302500014400953000000 0.16 1499205272700015127772000000 0.18 1554258110400015835775000000 0.10 1619700734900016669124000000 0.14 1678484919600017172525000000 0.11 1752716369500018054959000000 0.09 1823830056900018696014000000 0.13 1874507568700019069313000000 0.39 1954297918300019966722000000 1.00

2061186093400020954575000000 1.83 2.16 0.37 0.08

Dominican Republic Year GDP per Capita Consump1on GDP GNI

1970 330.13150590192 1349326995.9 1485500000 1476200100.00000 1971 360.152852631028 1530481307 1666500000 1664300000.00000 1972 417.91926087549 1662631844 1987400000 2027000000.00000 1973 480.053066255021 1930153083.4 2344800000 2350899900.00000 1974 583.484421302995 2516289090.6 2925700000 2920400000.00000 1975 699.60300367451 2837833453.1 3599200000 3597500100.00000 1976 748.99062070027 3341664894 3951500000 3945299900.00000 1977 848.28541713207 3918026626.8 4587100000 4507500200.00000 1978 854.647161995207 4116448530 4734400000 4771400000.00000 1979 969.498048327154 4640214740 5498800000 5551200100.00000 1980 1164.95222460509 6023883259 6761300000 6420500100.00000 1981 1273.82644066312 6403238062.4 7561300000 6973899800.00000 1982 1362.51066907788 7354424940.5 8267400000 7709900300.00000 1983 1487.27582832405 8079307093.5629 9220600000 8324900100.00000 1984 1831.08645937307 10480846007.247611594000000 9972699700.00000 1985 780.385865786157 4403887507.742275044592944.80499 4725492096.63947 1986 928.032248763549 5141122183.542516122198120.02892 5877395034.94818 1987 865.831754484669 4904138355.837315826987099.45901 5527990480.64919 1988 783.035401270523 4254835463.166465374314928.42536 5052914306.74847 1989 955.517374760504 5507452448.458776686593059.93691 6373562712.93375 1990 991.614841149791 5986263362.381697073675544.80847 6758924741.65132 1991 1351.29850024099 8477270016.460059824498183.03263 9461132793.67679 1992 1566.52962344191 10220400000 11605382504 11164249000.00000 1993 1733.39953649834 11179856000 13081042400 12384042400.00000 1994 1905.94349639051 12262958911.927 14644711384.820213962617074.06000 1995 2127.74808893306 13874731934.731916637370839.160815868370839.16080 1996 2293.75438147613 15106821336.352318241691857.354417516877243.86060 1997 2476.06040304923 16351730342.212920017480054.834 19222030487.15180 1998 2638.31327013425 17169209214.383421672231760.649120780878617.43440 1999 2653.22512384672 17538353205.678822136621337.0889 21161260672.96520 2000 2869.17813861021 19544733182.955824305717541.637123264321904.64420 2001 2977.43451003068 20470834581.511 25601765400.515324510208597.44770 2002 3110.32544702737 21796441766.611727137508656.852225985430347.29720 2003 2418.35042158878 17279707184.201621403167848.144420001897173.98710 2004 2487.32906105687 17507258474.182222322395368.027420508099190.80000 2005 3932.78440650852 28700126804.654835777570135.522533873701573.17020 2006 4109.03359145391 30451543543.543537879869897.897936027519171.17120 2007 4707.79505245725 35203901326.122443965420072.410741782447146.53060 2008 5087.98321278434 40208725746.754948122547177.188146374331821.57810 2009 5039.40312212985 41010750780.470348261033298.213346539816384.45570 2010 5555.39201393816 45387143577.223 53860175555.996151932177372.87930 2011 5913.42664885493 49667350224.22 58029750745.649555774581987.31350 2012 6110.36657603383 51534750355.414460681537195.799658281926478.18050 2013 6238.13236658362 52417189871.873162682163837.347 59708978487.60000 2014 6608.82550130065 55141745334.640667179914026.962363931917485.08030 2015 6921.52059432776 57789942862.217171164825256.684968227916795.24040 2016 7280.88361041225 61165645216.262575704720189.560772450765680.22160 2017 7609.35327534023 64309500963.512779997975621.865476203984074.69120

2018 8050.64407623416 67723440933.144885555378042.819681863297764.08810 2019 8282.11713050921 70147197128.759488941299733.501884871455782.15380 2020 7268.1969096591 64905431757.910378844702329.0785 74984131332.43110

Mean 2941.99181486092 22175042388.756327011653528.432925787259712.80080 Savings Rate 0.13373

growth rate GDP per capita0.02875211623854652.87521162385465

United States GDP per Capita Consump1on GDP GNI 5234.2966662115 839510000000 1073303000000 1074359000000 5609.38259952519 908897000000 1164850000000 1162926000000 6094.01798986165 993651000000 1279110000000 1280507000000 6726.35895596695 1088700000000 1425376000000 1431848000000 7225.69135952566 1195366000000 1545243000000 1553300000000 7801.45666356443 1327272000000 1684904000000 1684554000000 8592.25353727612 1462173000000 1873412000000 1869603000000 9452.57651914511 1615144000000 2081826000000 2082670000000 10564.9482220275 1793022000000 2351599000000 2349856000000 11674.1863100131 1990125000000 2627334000000 2614202000000 12574.7915062163 2204317000000 2857307000000 2847055000000 13976.1097504641 2440992000000 3207042000000 3201886000000 14433.787727053 2625786000000 3343789000000 3371448000000 15543.8937174925 2876998000000 3634038000000 3614168000000 17121.2254849995 3127068000000 4037613000000 4032292000000 18236.8277265009 3403470000000 4338979000000 4310074000000 19071.2271949295 3624267000000 4579631000000 4516535000000 20038.9410992658 3853172000000 4855215000000 4828878000000 21417.0119305191 4150467000000 5236438000000 5256093000000 22857.1544330056 4458186000000 5641580000000 5598381000000 23888.6000088133 4757180000000 5963144000000 5902290000000 24342.2589048189 4948306000000 6158129000000 6096750000000 25418.9907763319 5245942000000 6520327000000 6435469000000 26387.2937338171 5525024000000 6858559000000 6733768000000 27694.853416234 5829066000000 7287236000000 7170251000000 28690.8757013347 6104333000000 7639749000000 7574691000000 29967.7127181749 6417484000000 8073122000000 8045907000000 31459.1389804773 6757318000000 8577554457000 8589268000000 32853.6769523009 7144856000000 9062818202000 9135464000000 34513.5615037271 7630960000000 9630664202000 9689215000000 36334.9087770589 8200138000000 10252345464000 10383669000000 37133.2428088526 8603027000000 10581821399000 10743701000000 38023.1611144021 8987727000000 10936419054000 11054386000000 39496.4858751381 9470095000000 11458243878000 11530051000000 41712.8010675545 10065348000000 12213729147000 12314253000000 44114.7477810544 10709823000000 13036640230000 13167294000000 46298.7314440927 11333686000000 13814611414000 14072268000000 47975.9676958038 11905251000000 14451858656000 14543492000000 48382.5584490552 12328725000000 14712844084000 14684902000000 47099.9804711343 12272811000000 14448933025000 14400953000000 48466.6576026922 12695979000000 14992052727000 15127772000000 49882.5581321495 13152863000000 15542581104000 15835775000000 51602.9310457907 13522794000000 16197007349000 16669124000000 53106.5367672165 13849216000000 16784849196000 17172525000000 55049.9883272312 14388171000000 17527163695000 18054959000000 56863.3714957652 14905109000000 18238300569000 18696014000000 58021.4004997125 15430817000000 18745075687000 19069313000000 60109.6557260477 16083058000000 19542979183000 19966722000000

63064.4184096731 16884571000000 20611860934000 20954575000000 65279.5290260953 17539657000000 21433224697000 21690015000000 63543.577788724 .. 20936600000000 8883709420000 31196.5943606831 7173358360000 9040569281431.37 8883709420000

Savings Rate = 0

0.0351245705943502 3.51245705943502

Dominican Republic Savings Rate: 0.13373 n = 0.471089698207024 deprecia1on = 0.05 Law of Mo1on of Capital: k + s*y - (delta*k)

Steady State level of income per worker: 0.93092 How long will it take to double? 24.3460340168473

United States Savings Rate: 0 n = 0.290872 deprecia1on = 0.05

steady state income per worker: 1 How long to double 19.92906925708