EXCEL GRAPHING ECONOMICS DUE IN 12C HOURS

Base year = 2017

(constant 2017 USD)

Year NGDP (in millions) RGDP (in millions) dGDP 2017 e

1970

1971

1972

1973

1974

1975

1976

1977

1978

1979

1980

1981

1982

1983

1984

1985

1986

1987

1988

1989

1990

1991

1992

1993

1994

1995

1996

1997

1998

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

Calculated GDP deflator (2017 as base year)

USD per currency of country of choice currency, PPP-adjusted

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

Population No. of Workers

N L E U Hours Nom wL

Number of Empoyed Workers (E) in

Thousands

Number of Unempoyed Workers in Thousands

Average Number of Hours in Work Week (Dependent workers,

Main job)

Average total annual wages (National Currency Current Prices)

Nom w Real wL Real w K

Average hourly wage (National Currency Current Prices)

Average annual wages in 2017 US Dollar

Average hourly wage in 2017 US Dollar

Capital stock (K) at Constant National Prices, Millions of 2017 U.S. Dollars

Capital stock at Current Purchasing Power Parities for United States, Millions of 2017 U.S. Dollars

National Income Components

Federal Funds Rate Consumption

r C

Capital stock (K) at Constant National Prices, Millions of 2017 US Dollars

Gross Fixed Capital Formation, in Millions of Domestic Currency

Immediate interest rates, Call Money, Interbank Rate, Per cent per annum

National Income Components School Enrollment Rates Human Welfare Indicators

Exports Imports Net Exports

G EX IM NX

Government Expenditure

Primary (% net)

Primary (% gross)

Secondary (% net)

Secondary (% gross)

Life Expectancy at Birth

Human Welfare Indicators

Mortality rate, infant (per 1,000 live births)

Base year = 2017

(constant 2017 USD) Population

Year NGDP (in millions) RGDP (in millions) dGDP 2017 e N

1970 1,905.23 16730.005859375 11.38809024556 0.524693824 4499722

1971 2,137.37 18548.8515625 11.52292218876 0.510027145 4627202

1972 2,548.94 20476.94140625 12.44785540577 0.525360491 4755464

1973 3,007.32 23117.927734375 13.00862039235 0.526928763 4884460

1974 3,752.36 24505.431640625 15.31234734591 0.545844686 5014187

1975 4,616.15 25778.060546875 17.9072986956 0.549231537 5144632

1976 5,068.00 27512.443359375 18.42074377818 0.574790123 5275767

1977 5,883.19 28881.923828125 20.36978533447 0.598721724 5407496

1978 6,072.11 29501.349609375 20.58246605717 0.585958808 5539596

1979 7,052.49 30837.044921875 22.87017608646 0.601227715 5671801

1980 8,671.71 33295.58203125 26.04461462891 0.580391414 5803929

1981 9,697.62 34720.25390625 27.93072428191 0.553635739 5935895

1982 10,603.36 35310.390625 30.02899532415 0.573361263 6067769

1983 11,825.88 36944.5390625 32.00982240873 0.5704053 6199657

1984 14,869.89 37407.4140625 39.75117426767 0.68363271 6331760

1985 20,138.35 36613.4296875 55.00261994046 0.902101102 6464229

1986 22,804.64 37902.953125 60.16586159627 0.942597987 6596967

1987 28,733.74 41737.73046875 68.84356085127 1.061564452 6729930

1988 42,132.41 42637.5859375 98.81519446344 1.400703673 6863438

1989 54,371.15 44513.8671875 122.1442926204 2.039387036 6997877

1990 77,344.45 42287.328125 182.9021866341 3.280043154 7133491

1991 123,551.91 42611.67578125 289.9484811214 4.827878421 7270413

1992 145,067.28 47091.4921875 308.0541189059 4.956656374 7408339

1993 163,513.03 50492.765625 323.8345690318 5.049929992 7546467

1994 184,769.39 51655.70703125 357.6940579316 5.359080697 7683707

1995 214,122.96 54493.55078125 392.9326674126 5.786950198 7819239

1996 235,250.33 58379.65234375 402.9663096896 5.944465608 7952766

1997 280,362.82 63052.515625 444.6497037636 6.271281272 8084407

1998 318,648.99 67472.9140625 472.2620849904 6.430398078 8214427

1999 350,520.12 72003.921875 486.806979045 6.657675657 8343288

2000 393,302.97 76076.8984375 516.9808134632 7.080559281 8471317

2001 427,319.07 77453.328125 551.7116910113 7.165951714 8598599

2002 477,430.19 81936.453125 582.6834962511 7.511601855 8724974

2003 628,611.04 81728.828125 769.1423627961 10.14951061 8850317

2004 935,984.73 82801.109375 1130.401200674 14.07655992 8974444

2005 1,083,445.00 90470.7734375 1197.563544213 14.0959373 9097262

2006 1,261,399.67 100125.046875 1259.824296701 14.37795391 9218681

2007 1,458,416.52 108610.3046875 1342.797557057 14.72307579 9338856

2008 1,661,642.68 112096.15625 1482.336893677 15.80004703 9458079

Calculated GDP deflator (2017 as

base year)

USD per currency of country of choice

currency, PPP- adjusted

2009 1,736,041.06 113156.7578125 1534.191238091 15.68059494 9576736

2010 1,983,201.68 122593.640625 1617.703554694 16.68920124 9695117

2011 2,210,213.93 126435.015625 1748.102709938 ... 9813219

2012 2,386,016.25 129870.71875 1837.224179494 ... 9930916

2013 2,619,769.70 136202.1875 1923.441718961 ... 10048226

2014 2,925,665.10 145805.078125 2006.559126399 ... 10165182

2015 3,205,655.14 155905.03125 2056.158874698 ... 10281675

2016 3,487,292.51 166287.046875 2097.152230579 ... 10397738

2017 3,802,655.77 174047.171875 2184.842035338 ... 10513111

2018 4,235,846.77 186200.078125 2274.889897793 ... 10627147

2019 4,562,235.08 195607.203125 2332.345129857 ... 10738957

2020 ... ... ... ... 10847904

No. of Workers

L E U Hours Nom wL Nom w

.. 54.03 ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. 52.66 ..

.. .. ..

.. 53.69 ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

.. .. ..

2569954 .. ..

2639165 54.1 ..

2709858 57.3 ..

2779158 52.9 ..

2847558 52.5 ..

2917282 .. ..

2987680 62.35 ..

3060636 62.24 ..

3134711 64.34 ..

3208540 .. ..

3282359 58.51 6.43

3286981 57.28 7.26

3384928 57.57 6.78

3388368 56.63 6.94

3452459 56.85 6.3

3509453 56.62 6.59

3656408 57.3 5.65

3705721 57.21 5.16

3803887 57.59 4.76

Number of Empoyed

Workers (E) in Thousands

Number of Unempoyed Workers in Thousands

Average Number of Hours in Work Week (Dependent workers,

Main job)

Average total annual wages (National Currency Current Prices)

Average hourly wage (National Currency Current Prices)

3733574 55.47 5.47

3907278 56.71 5.21

4089236 58.16 6.09

4215759 59.43 6.72

4307344 59.27 7.35

4399404 59.53 6.72

4663526 62.01 7.61

4763944 62.45 7.28

4838894 62.37 5.83

5029428 63.77 5.86

5199103 65.19 6.36

4858960 60.34999847412 6.130000114441

Real wL Real w K

Average annual wages in 2017 US Dollar

Average hourly wage in 2017 US Dollar

Capital stock (K) at Constant National Prices, Millions of 2017 U.S. Dollars

Capital stock at Current Purchasing Power Parities for United States, Millions of 2017 U.S. Dollars

Capital stock (K) at Constant National Prices, Millions of 2017 US Dollars

National Income Components

Consumption Exports Imports

r C G EX IM

Gross Fixed Capital Formation, in Millions of Domestic Currency

Federal Funds Rate

Immediate interest rates, Call Money, Interbank Rate, Per cent per annum

Government Expenditure

National Income Components School Enrollment Rates Human Welfare Indicators

Net Exports

NX

Primary (% net)

Primary (% gross)

Secondary (% net)

Secondary (% gross)

Life Expectancy at Birth

Mortality rate, infant (per 1,000 live births)

Variable Data Source Years/Time Periods Available

1. Nominal GDP 1970-2019

2. Real GDP 1970-2019

1970-2010

5. Population World Bank 1970-2020

IMF's International Financial Statistics

FRED - Federal Reserve Economic Data from the St. Louis Federal

Reerve Bank

4. Exchange Rate with US dollar, PPP adjusted

FRED - Federal Reserve Economic Data from the St. Louis Federal

Reerve Bank

5. Population World Bank 1970-2020

6. Labor (L) or number of workers World Bank 1990-2020

7. Number of Empoyed Workers (E) World Bank Consistent from 2000-2020, however

there is some data availabe from 1970- 1999

8. Number of hours in average work week

11. Capital Formation

8. Number of hours in average work week

9. Hourly wage rate/ measure of labor income

10. Capital Stock (K) - here using constant prices, but also took the current prices to chance base year to 2010 as it is with other variables

12. Measure of Capital Return - for both countries, using the

"Immediate interest rates, Call Money, Interbank Rate, Per cent

per annum"

13. Components of National Income

15. Life Expectancy at Birth

14. School Enrollment Rates - provided net and gross percentages

(not sure which would be most helpful)

16a. Measures of Human Welfare - Infant Mortality rates

Instructions on How to Retrieve the Variable

Citation

International Monetary Fund (IMF), International Financial Statistics. Gross Domestic Product and Components selected indicators - Gross Domestic

Product, Domestic Currency [Data set] URL: https://data.imf.org/regular.aspx? key=61545852

Federal Reserve Bank of St. Louis, FRED Economic Data FRB Rates - discount, fed funds, primary credit. Effective Federal Funds Rate [Data set] URL:https://fred.stlouisfed.org/series/NYGDPPCAPKDDOM

Federal Reserve Bank of St. Louis, FRED Economic Data FRB Rates - discount, fed funds, primary credit. Effective Federal Funds Rate [Data set] URL:

https://fred.stlouisfed.org/series/PPPTTLDOA618NUPN

World Bank, World Development Indicators. Population, total - Dominican Republic [Data set] URL:

https://data.worldbank.org/indicator/SP.POP.TOTL? locations=DO&view=chart

World Bank, World Development Indicators. Population, total - Dominican Republic [Data set] URL:

https://data.worldbank.org/indicator/SP.POP.TOTL? locations=DO&view=chart

World Bank, World Development Indicators. Labor force, total - Dominican Republic [Data set] URL: https://data.worldbank.org/indicator/SL.TLF.TOTL.IN?locations=DO

World Bank, World Development Indicators. Labor force participation rate, total - Dominican Republic [Data set] URL:

https://data.worldbank.org/indicator/SL.TLF.CACT.NE.ZS?locations=DO