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

......... .............