Question
Hello, I need help with this Macroeconomics Excel assignment. Below is the google drive where the excel files are located. The question first asks to
Hello, I need help with this Macroeconomics Excel assignment. Below is the google drive where the excel files are located. The question first asks to plot separate line graphs of the data and then comment on it. This is supposed to be a short problem but i'm confused.
Excel Files in:
https://drive.google.com/drive/folders/14RnsC5olnO0H9HrkYdrgO-MnfoI7s1w6
Question 1.
PART A. Use the excel files labeled "nominal gdp", "real gdp", "nominal gdp growth rate", "real gdp growth rate."
(a) Create severalline graphs for nominal GDP, real GDP, nominal GDP growth rate, and real GDP growth rate.
(b) Can you roughly identify the phases of expansion (or booms) and recession (or depressions) based on your graphs?
PART B. Now use the excel files labeled "nominal gdp", and "international 2022."
(c) Createa linegraph depicting the evolution of US exports, imports, and current account balances.
(d) Determine the current account deficit/surplus (CA/GDP in percentage) using nominal GDP data and current account balances. Can you roughly identify the times or periodswhen the United States has a deficit or a surplus?
Graphs/ How The Data Should Look
(Only use line 1 listed as "Gross Domestic Product")
Nominal GDP
Date Nomial Gdp
Q1.1992 6363.1
.... ......
Nominal GDP Growth Rate
(Only use line 1 listed as "Gross Domestic Product")
Date Nomial Gdp
Q1.1992 1.6
.... ......
Real GDP
(Only use line 1 listed as "Gross Domestic Product")
Date Real Gdp
Q1.1992 58.696
.... ......
Real GDP Growth Rate
(Only use line 1 listed as "Gross Domestic Product")
Date Real Gdp
Q1.1992 4.9
.... ......
International Transactions
(In the file international 2022 use line 5 listed as "Balance on current account (line 1 less line 9)")
Date NomialGdp CA ("balances on current account") CA/GDP
Q1.1992 6363.1 -6234 (in excel -6234/6363.1) =-0.97971
...... ...... ........... .............
Then graph
Date CA/GDP
Q1.1992 -0.97971
......... .............
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started