Tools of Economic Analysis Assignment: The purpose of this assignment is to expose students to the basic tools of economic analysis (tables, graphs, and models), and make sure they know when and how best to use these tools.

Economic Growth and Development in America (1967 – date)

From the links below, gather in excel all relevant annual data for the unemployment rate, population, Nominal GDP, Real GDP growth rate, Inflation rate, and GDP deflator.

Data Links:

1. Nominal GDP (Links to an external site.)
2. GDP Deflator (Links to an external site.)
3. Unemployment rate (Links to an external site.)
4. Population (Links to an external site.)
5. GDP growth rate (Links to an external site.)

1. From your collected data, use excel to compute the

1. Nominal GDP per capita
2. Real GDP
3. Real GDP per capita
4. Population growth rate
5. Inflation rate

1. In separate graphs on a new excel sheet (not document) show the relationship between these variables

1. Unemployment rate and REAL GDP growth rate
2. Inflation rate, and NOMINAL GDP growth rate
3. Nominal GDP and real GDP (both in billions)
4. Population (in thousands) and Real GDP (in billions)
5. Population growth rate and unemployment rate

Your downloads and computations should be in excel. Your excel document must have 2 sheets. Sheet 1 should have the table of data for all the years and and the computed variables and sheet 2 should contain each of the 4 graphs in question 2.

1. Answer this question in your MLA formatted word document file. Build a simple economic model that shows the relationship between, the following variables based on your observation from questions 1 & 2 above: Nominal GDP, Inflation, Unemployment rate, and population. Explain the reason and assumptions behind your model and the hypothesis your model is intended to test if it were to be analyzed.

Neatly copy your graphs into Microsoft word and give detailed report on each graph. Talking about the relationships among the various macroeconomic variables and their importance and usefulness in economics and policy decision making. Your work should be correctly formatted in MLA and do not forget to cite all sources of data and information used.

Upload and submit both word and excel documents.