Excel Assignment
Econ 103
Instructions
1. This is an individually assignment (see the next page for the country to work with).
2. You need to submit a report that contains the graphs and analysis (TWO pages
maximum) and one Excel file as an Appendix that contains all your data. You need to
clearly mention in your report your name, course code, section number, as well as the
data sources that you used for each economic variable.
3. The deadline for this assignment is December 8th (Only HARD COPY is accepted).
4. READ ALL these guidelines very carefully and make sure you understand what to do
before starting your assignment.
Tasks
For all the tasks below only use quarterly or yearly data for at least 30 years.
1. (1 mark) Use real (or constant prices) household Consumption (C) and your data on
real GDP (Y). Plot on the same diagram the 45-degree line along with the
consumption curve (call this Figure 1):
??
??
where (a, b) are constants to be estimated.
HINTS:
The frequency of the data for C, and Y must be the same (e.g., quarterly or
yearly), and that you need to use constant prices of the same year for both
variables (e.g., Consumption and GDP, at constant prices of 2005, or
100=2005, or any other year available).
1.1 (1.5 marks) Provide an economic interpretation of your Figure 1.
2. (1 marks) On a new diagram (call this Figure 2), plot the average government
spending, ??? and the tax (T) equation curves such that:
??
??
where (m, n) are constants to be estimated.
2.1 (1.5 marks) Provide an economic interpretation of your Figure 2.
3. (1 mark) Assume anything else is constant, find the multiplier (K) for the chosen
economy.
DATA SOURCES
you can only use the following data sources (any other sources will not be considered as
valid or accurate and you will be penalized in your final mark for this assignment):
–
FRED https://fred.stlouisfed.org/
World Bank https://data.worldbank.org/
Note: you need to clearly mention the source of your data (with the website link) for each
economic variable. Failing to provide the data source will decrease your final mark in this
assignment.
ID
COUNTRY
10067
Tunisia

Purchase answer to see full
attachment