Question
Instructions - Go to BEA.gov and in the U.S. Economic Accounts find Table 1.1.5 (nominal GDP) and Table 1.1.6 (real GDP) and download them for
Instructions
- Go to BEA.gov and in the U.S. Economic Accounts find Table 1.1.5 (nominal GDP) and Table 1.1.6 (real GDP) and download them for the period 1960 to the latest available year in annual frequency (yearly).
- In Excel plot line 1 of both tables within a single graph. Where do they cross? Explain what is the relationship between real and nominal GDP before and after the crossing point? Why? (25 points)
- In Excel, using the formula "=ln( )" take the natural log of real GDP (line 1) and plot the change in GDP from one year to the next measured by ln(GDP(t)) - ln(GDP(t-1)). (If you multiply by 100, it will be a Belpercentage.) (25 points)
- In Excel using nominal GDP (table 1.1.5) calculate and plot the GDP shares of Consumption (line 2), Investment (line 7), Government (line 22), and Net Exports (line 15). For example, the consumption share is C/Y or line 2 / line 1. (25 points)
https://apps.bea.gov/iTable/iTable.cfm?reqid=19&step=2#reqid=19&step=2&isuri=1&1921=survey
Lastly PLEASE provide me the Excel spreadsheet. If you cannot do so then please provide step by step instructions on how you came up with the chart and table. I'm stuck and need help with this. Thanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started