02 Oct ECON 202 Economics II – Fundamental Macro Measures
36499Subject: Economics / General Economics
Question
ECON 202: Economics II
School of Economics
Drexel University Data Assignment with Excel Part I: “Fundamental Macro Measures in the United States”
1) Go to The FRED Database published by the Federal Reserve Bank of St Louis at
https://fred.stlouisfed.org/
2) Download monthly data on the CPI for the United States. Use this data to calculate averages
across each 3-month period to calculate the quarterly CPI. Start your series in 1980.
3) Calculate the inflation rate for each quarter using the formula for the inflation rate that we
learned in section 2 of the course.
4) What was the minimum, maximum and mean value of the inflation rate during this period?
Don’t look for the minimum and the maximum manually. Use an excel function to do so. Part II: “Bilateral Trade for the United States”
1) Go to The FRED Database published by the Federal Reserve Bank of St Louis at
https://fred.stlouisfed.org/
2) Download data for the following series from 2005 until the last year available:
a. US exports of goods to Mexico
b. Value of exports to Mexico from each of the 50 states in the US.
c. US imports of goods from Mexico
3) For each series calculate the average annual growth rate between 2005 and the last year
available.
4) Plot the value of exports for each state (as a percentage of the country total) for the last
year available in the data.
5) Comment on which US states would you expect to be more affected by a potential “trade
war” with Mexico. Part III: “the Banking Sector Around the World”
1) Go to http://data.worldbank.org/data-catalog/global-financial-development and download
the Global Financial Development Database of the World Bank.
2) Write a 1-paragraph summary of what this dataset contains. Include type of information,
a few examples of variables provided there, countries, time-period, etc.
3) Collect the following variables that will allow you to get an idea of how important the
banking sector is in several different areas of the world:
a. Firms using banks to finance investments (%)
b. Firms using banks to finance working capital (%)
c. Bank credit to bank deposits (%)
d. Bank deposits to GDP (%)
Collect the data for the following areas:
a. East and Asia Pacific (developing only)
b. Euro Area
c. Europe and Central Asia
d. Latin America and Caribbean (developing only)
e. Middle East and North Africa
f. South Asia
g. United States
h. Upper Middle Income
i. Middle Income
j. Lower Middle Income
k. Low Income
l. High Income
4) For each area calculate the percentage of firms using banks to finance either investment
or working capital.
5) Plot the evolution of this series over time. You should have a graph with years on the
horizontal axis and one series for each country. Do one graph for high income, low
income, middle income, etc. group. Do another graph for the regions. Do a separate graph
for the United States.
6) Describe (in a couple of sentences) what you observe.
7) For each area calculate the ratio of bank credit to GDP (in %).
8) Plot this % for the last year available in each country. You should have a bar graph where
each bar contains the data for each country for the last year available.
9) Describe (in a couple of sentences) what you observe.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.