Only Proff

daehan199f
problemsetdata.xlsx

Question 1

Country Year Debt-GDP level Debt-GDP category Real GDP growth
France 1950 27.4198898693 0-30% 7.4940047962
France 1951 22.8435917932 0-30% 6.1349693252
France 1952 23.4974918001 0-30% 2.6274303731
France 1953 25.781658973 0-30% 2.9185867896
France 1954 24.7686302031 0-30% 4.8258706468
France 1955 23.7004695609 0-30% 5.790223066
France 1956 23.1956885879 0-30% 5.024674742
France 1957 24.0700218818 0-30% 6.0230670654
France 1958 27.2948265827 0-30% 2.5382755842
France 1959 27.1464564894 0-30% 2.8290766208
France 1960 22.0902655938 0-30% 7.0691631639
France 1961 19.3084469359 0-30% 5.4960742327
France 1962 20.3955550301 0-30% 6.6305818674
France 1963 19.6609798296 0-30% 5.4885786802
France 1964 17.4770532841 0-30% 6.4962406015
France 1965 15.2158415132 0-30% 4.6879412595
France 1966 14.668951236 0-30% 5.3142702994
France 1967 15.1809045226 0-30% 4.5850409836
France 1968 15.2721568627 0-30% 4.3595395542
France 1969 14.5286525109 0-30% 6.9467261206
France 1970 12.3710204439 0-30% 5.793285056
France 1971 10.7705515964 0-30% 5.3723293922
France 1972 8.757900941 0-30% 5.8858267717
France 1979 31.1153032427 30-60% 3.3060357901
France 1980 29.5203655568 0-30% 1.0716382854
France 1981 30.5132376457 30-60% 1.547505313
France 1982 36.4492653782 30-60% 0.1249935199
France 1983 38.3336151982 30-60% 3.8668937136
France 1984 40.3885644613 30-60% 5.8941036808
France 1985 41.2177426362 30-60% 5.3540295135
France 1986 43.6684282344 30-60% 4.0375523146
France 1987 45.1460745231 30-60% 1.7800135205
France 1988 46.4365186106 30-60% -0.1728488253
France 1989 47.9036924505 30-60% 0.997558549
France 1990 49.3823807034 30-60% 1.927514003
France 1991 49.643753537 30-60% 3.1046289615
France 1992 55.1978267032 30-60% 3.5231049815
France 1993 61.4817898668 60-90% 2.7866370789
France 1994 64.8607314925 60-90% 5.0513843416
France 1995 70.2537636323 60-90% 4.186349074
France 1996 68.9067657964 60-90% 5.0997663359
France 1997 67.1295055308 60-90% 5.392640347
France 1998 68.978217405 60-90% 2.6827834908
France 1999 64.8565416831 60-90% 2.0257705901
France 2000 55.7910939483 30-60% 3.2535679946
France 2001 55.4106019299 30-60% 1.9901541356
France 2002 59.4461956132 30-60% 1.50205563
France 2003 62.9552712648 60-90% 1.0135240342
France 2004 61.7828621259 60-90% 3.8641263642
France 2005 58.8676685237 30-60% 2.7392074429
France 2006 53.2467111508 30-60% 2.280888542
France 2007 53.0848312115 30-60% 3.1340917857
France 2008 51.5673070886 30-60% 2.1321302984
France 2009 60.0015126432 60-90% -1.9066760919
US 1946 121.2520698348 Above 90% -10.9421586166
US 1947 105.8117095899 Above 90% -0.8983372391
US 1948 93.7540864039 Above 90% 4.3972749282
US 1949 94.5996855763 Above 90% -0.5123503398
US 1950 87.625928618 60-90% 8.7439692091
US 1951 75.220152318 60-90% 7.7318045862
US 1952 72.3151489771 60-90% 3.8313821665
US 1953 70.1479202845 60-90% 4.6035919604
US 1954 71.309042878 60-90% -0.630538514
US 1955 66.162098578 60-90% 7.1985937232
US 1956 62.357296216 60-90% 1.9757629085
US 1957 58.6699570367 30-60% 2.015923442
US 1958 59.1488051682 30-60% -0.9034639191
US 1959 56.1993499957 30-60% 7.1733395407
US 1960 54.3941414985 30-60% 2.4760180995
US 1961 53.0416553983 30-60% 2.3314140379
US 1962 50.9135773811 30-60% 6.058200145
US 1963 49.5078719644 30-60% 4.3711756282
US 1964 46.9730107379 30-60% 5.7878816229
US 1965 44.1209705165 30-60% 6.420422722
US 1966 40.6128078958 30-60% 6.5150549846
US 1967 39.1904057899 30-60% 2.527761163
US 1968 38.2038257228 30-60% 4.8421052632
US 1969 35.9325735312 30-60% 3.1064015097
US 1970 35.7236547193 30-60% 0.1900605378
US 1971 35.3327781732 30-60% 3.3583924682
US 1972 34.5149415091 30-60% 5.3112183627
US 1973 33.1434280049 30-60% 5.7942638294
US 1974 31.6812147871 30-60% -0.5511490746
US 1975 32.5571838554 30-60% -0.212683286
US 1976 34.0037816508 30-60% 5.3653038221
US 1977 34.4239200039 30-60% 4.5980588567
US 1978 33.6360624292 30-60% 5.5767335478
US 1979 32.258176567 30-60% 3.1245596731
US 1980 32.5562569492 30-60% -0.2732707088
US 1981 31.9129781246 30-60% 2.53810584
US 1982 35.1049428255 30-60% -1.9424772849
US 1983 38.9636734001 30-60% 4.518898295
US 1984 39.9976086901 30-60% 7.1852286431
US 1985 43.2271013634 30-60% 4.1386021195
US 1986 47.6514566189 30-60% 3.4631276189
US 1987 49.621587935 30-60% 3.2004515628
US 1988 51.0222279045 30-60% 4.1103195548
US 1989 52.1229266191 30-60% 3.5724136119
US 1990 55.7419783084 30-60% 1.876767395
US 1991 61.1689282839 60-90% -0.2340083894
US 1992 64.0874864879 60-90% 3.3935945902
US 1993 66.165055091 60-90% 2.8514196764
US 1994 66.2331325864 60-90% 4.0746650398
US 1995 67.0827262156 60-90% 2.5138940557
US 1996 66.655749686 60-90% 3.7410514972
US 1997 64.9650282199 60-90% 4.4562694114
US 1998 62.8440667413 60-90% 4.3554590382
US 1999 60.472239286 60-90% 4.8261778577
US 2000 57.0183209555 30-60% 4.1392233622
US 2001 56.4587837316 30-60% 1.079636558
US 2002 58.5234015729 30-60% 1.8136632826
US 2003 60.8792872326 60-90% 2.4902622695
US 2004 62.1770900784 60-90% 3.5732684723
US 2005 62.7667241243 60-90% 3.0545181754
US 2006 63.4899732569 60-90% 2.6728066844
US 2007 63.9854876347 60-90% 2.1416131071
US 2008 74.0910609583 60-90% 0.4381663033
US 2009 83.4828347084 60-90% -2.7301699384

Question 2

Date Inflation rate Wage growth
Jan-09 1.5777372176 3.6396724295
Feb-09 1.7862882641 -0.1789709172
Mar-09 1.4472865146 -3.6216446527
Apr-09 1.4229345789 -3.3912674862
May-09 1.057865675 -3.4351145038
Jun-09 0.8190115636 -4.1113490364
Jul-09 0.5168973076 -4.1486603284
Aug-09 0.536859535 -2.2154648132
Sep-09 0.2358161471 -3.0487804878
Oct-09 0.5711016961 -2.3255813953
Nov-09 0.4628983485 -3.8898601399
Dec-09 0.5969299412 -4.9604916594
Jan-10 -0.1434973414 -3.585835948
Feb-10 0.1004086072 -6.0565870911
Mar-10 0.2191272052 -6.976744186
Apr-10 0.4725199671 -6.4558629776
May-10 0.515856787 -4.6895935686
Jun-10 0.612344531 -3.4265103697
Jul-10 0.392955564 -4.7090182141
Aug-10 0.403238904 -4.0431266846
Sep-10 0.3828884028 -2.7852650494
Oct-10 0.6381254486 -0.7730786721
Nov-10 0.6133375398 1.3394919169
Dec-10 0.5817901091 2.1850302185
Jan-11 0.4044822766 2.7294117647
Feb-11 0.8620849392 2.9716981132
Mar-11 0.9378208152 1.9248826291
Apr-11 1.3343443404 1.0777881912
May-11 1.2532810825 0.466853408
Jun-11 1.0767446267 -0.6526806527
Jul-11 1.2649394105 -1.1235955056
Aug-11 0.5933323813 -1.3863216266
Sep-11 0.5420503122 -3.2538955087
Oct-11 1.132507009 -3.4639927074
Nov-11 1.3723142082 -4.2311191993
Dec-11 1.243709761 -4.1227668346
Jan-12 0.3022049942 -4.1227668346
Feb-12 0.7536399205 -3.4546292031
Mar-12 0.4918511489 -4.2188224386
Apr-12 0.9735102965 -3.624535316
May-12 1.3738838622 -3.0032848428
Jun-12 1.1961973612 -2.7462121212
Jul-12 1.6600493664 -4.3580131209
Aug-12 1.9263069734 -3.0791094268
Sep-12 1.8042130221 -4.4381491974
Oct-12 2.1181782937 -3.2304038005
Nov-12 2.5217339662 -2.6755852843
Dec-12 2.5339872064 -3.0100334448
Jan-13 1.4205230107 -3.3874045802
Feb-13 1.7639046538 -0.968054211
Mar-13 1.5015571536 -1.3982642237
Apr-13 1.5203312166 -1.5481373972
May-13 1.4007901431 0.3407984421
Jun-13 1.3622112509 2.2537971583
Jul-13 0.9761573347 1.8084066471
Aug-13 0.688382592 2.6679841897
Sep-13 0.7945901764 2.4545900835
Oct-13 0.6434450153 2.7000490918
Nov-13 1.3040080384 3.3004926108
Dec-13 1.5275081487 3.6049382716
Jan-14 0.8923193611 3.0791788856
Feb-14 1.175637583 6.4547677262
Mar-14 1.2758830559 6.7813267813
Apr-14 1.5228742472 5.5312954876
May-14 1.6101077257 3.6415908002
Jun-14 1.6003806407 3.8406144983
Jul-14 1.7409947779 4.7641963426
Aug-14 1.5677898506 4.3603258265
Sep-14 1.7196417265 3.776290631
Oct-14 1.4692851947 3.7672865999
Nov-14 1.8030470302 3.2888465205
Dec-14 1.6671457315 1.7543859649
Jan-15 1.0717476749 -1.6077170418
Feb-15 0.8654609578 -0.0460193281
Mar-15 1.1009278811 -1.1034482759
Apr-15 1.4533828437 0.1849283403
May-15 1.6110607791 -0.2311604253
Jun-15 1.7295652478 -1.2861736334
Jul-15 1.6434997339 -1.8824609734
Aug-15 1.5269102701 -1.1515430677
Sep-15 1.5309890606 -1.5165441176
Oct-15 1.6231949439 -1.338255653
Nov-15 2.3657597703 0.1863932898
Dec-15 2.7234642954 -0.6069094304
Jan-16 2.5645374526 -1.6574585635
Feb-16 2.8581952118 0.5113900511
Mar-16 2.896595132 0.6460544532
Apr-16 3.0030495684 1.1584800741
May-16 2.7788760723 1.5355979525
Jun-16 3.1149532349 2.9012634534
Jul-16 2.8878513888 1.9105312209
Aug-16 2.7149960206 2.6598226785
Sep-16 2.7484793512 2.5257249766
Oct-16 2.3663233395 2.1860465116
Nov-16 2.3757037238 4.3682480038
Dec-16 2.0017723805 1.872659176
Jan-17 1.4407825724 1.7576318224
Feb-17 1.7106514553 1.467216873
Mar-17 2.0682791382 2.1988089785
Apr-17 2.1835667991 3.5747021082
May-17 2.0101569329 2.8649386085
Jun-17 2.2721874753 4.435299497
Jul-17 2.370369136 4.0909090909
Aug-17 2.5760861437 3.3302919708
Sep-17 2.6843715366 3.0040964952