Exercise 13 Some US data to download and plot 1 Download the

Exercise 1.3 Some US data to download and plot 1. Download the following data from the Federal Reserve Bank of St Louis’ website:

a) Gross Domestic Product (GDP) from https://research.stlouisfed.org/ fred2/series/GDP/downloaddata (choose Frequency: Annual Data)

b) ConsumerPriceIndexforAllUrbanConsumers: AllItems(CPIAUCSL)from https://research.stlouisfed.org/fred2/series/CPIAUCSL/downloaddata (choose Frequency: annual data)

c) Total Population: All Ages including Armed Forces Overseas (POP) from https://research.stlouisfed.org/fred2/series/POP/downloaddata(choose Frequency: annual data)

d) PersonalConsumptionExpenditures(PCE)fromhttps://research.stlouisfed. org/fred2/series/PCE/downloaddata (choose Frequency: annual data)

2. If your father’s rst monthly wage was $1000 in 1985, how much is it in today’s dollars?

3. Plot for the longest possible period, for example putting all of this data on Excel oronGoogleSheets, andtransformingit(using GDPandCPIAUCSLto calculate realGDP,etc.),theannualgrowthrateofRealGDPpercapitausingtwomethods:

• The yt+1yt yt method.

• The log(yt+1)log(yt) method.

Provide the plots in your answer sheet.

4. Do the same for the annual growth rate of Real PCE per capita.

Solution

Q2. Monthly salary in 1985 = $1,000

CPI in 1985 = 107.60

CPI in 2015 = 238.11 (approx)

Value of monthly salary at present (2015) -

Value = Monthly salary in 1985 * (CPI in 2015/CPI in 1985)

         = $1,000 *(238.11/107.60)

         = $2,213

Thus, if our father’s rst monthly wage was $1000 in 1985 then in today’s dollars it will worth $2,213 per month.

Exercise 1.3 Some US data to download and plot 1. Download the following data from the Federal Reserve Bank of St Louis’ website: a) Gross Domestic Product (GDP

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site