answer the question in the document (Data exercise #1)

User Generated

onfobfn

Economics

Data

Alzahra School

Description

Steps:

Unformatted Attachment Preview

Steps: • Download and plot (e.g. using Excel) data from 1950 to 2010 on US aggregate o Output (Q, measured in $): http://www.bea.gov/national/index.htm o Capital stock (K, measured in $): https://research.stlouisfed.org/fred2/series/RKNANPUSA666NRUG o Labor input (L, in hours worked): https://fred.stlouisfed.org/series/B4701C0A222NBEA • Using these data series, calculate and plot two additional data series for the interval 1950-2010 o Output per worker-hour (Q/L) o The annual change in output (e.g. subtract GDP in 1950 from GDP in 1951 ... and keep doing that) So on Thursday you'll hand in five separate plots in all: • • • • • GDP (Q) 1950-2010 Capital stock (K) 1950-2010 Labor input (L)1950-2010 Output per worker-hour (Y/L) 1950-2010 The annual change in output, 1951-2010 (You may also be interested in taking a look at the Penn World Tables, with data on countries outside the U.S. http://www.rug.nl/research/ggdc/data/pwt/pwt-8.1. This is not required.) Here is a more direct link to *the* GDP data (Q) https://www.bea.gov/national/xls/gdplev.xls (typos ... ughh)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached below is my completed answer (the calculation and graphs are also included in the Excel file)

Firstly, the screenshot of the website http://www.bea.gov/national/index.htm from which the
data for output (Q) is retrieved can be shown as following:

The data for output (Q, measured in $) from 1950 to 2010 on US aggregate can be downloaded
and plotted using Excel as shown below:

Output (Q) per Year
$16,000.00
$14,000.00
$12,000.00
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$0.00
1940

1950

1960

1970

1980

1990

2000

2010

2020

Year

Secondly, the screenshot of the website
https://research.stlouisfed.org/fred2/series/RKNANPUSA666NRUG from which the data for the
capital stock (K) is retrieved can be shown as following:

The data for capital stock (K, measured in $) from 1950 to 2010 on US aggregate can be
downloaded and plotted using Excel as shown below:

Capital Stock (K) per Year
$60,000,000
$50,000,000
$40,000,000

$30,000,000
$20,000,000
$10,000,000
$0
1940

1950

1960

1970

1980

1990

2000

2010

2020

Year

And finally, the screenshot of the website https://fred.stlouisfed.org/series/B4701C0A222NBEA
from which the data for the labor input (L) in hours is retrieved ...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags