What is the average annual rate of growth of real gdp

Reference no: EM13184118

This is for a Macro class I am taking a test prep and I need like a step by step guide as to how i can do this using excel (the data must be found online) I apreciate as much help as possible!:

Question 1- Using a spreadsheet program, download the following U.S data series at a quarterly frequency for the period 1950 to 2012, stating in each case the source of the series and the precise definition of each variable:

(i) Nominal GDP

(ii) Consumer Price Index

(a) Using the Consumer Price index, construct the rate of inflation and plot it.

(b) Construct Real GDP

(c) What is the average annual rate of growth of real GDP for each of the decades for which you have data? What do these growth rates tell us about the health of the economy? What do they not tell us about the health of the economy?

Question 2: Now download quarterly data fro the following variables for the US during the same period 1950-2012, again stating your sources and the precise definition of each variable clearly:

(i) Total population

(ii) Total # of employed individuals

(iii) total number of unemployed individuals

(a) Construct series for the labor force

(b) what is the labor force patricipation rate? Constrcut a series for the labor force participation rate.

(d) Using your series for real GDP from the previous question, jointly plot real GDP and the employment rate. how are the series related?

Reference no: EM13184118

Questions Cloud

Competition and competitive technologie : There are many questions that can be asked and answered to determine if a product still has a useful life. However, there is another variable which is less predictable and that is competition.

Explain why might electricity restructuring be a good idea : You have been put in charge of electricity restructuring on the Isle of Mann. As part of the restructuring plan, it has been suggested to you that all wholesale electricity should be sold on the spot market at a price that is set every single min..

What are the equilibrium price and quantity : If the monopolist is left unregulated, what are the market price and quantity, the monopolists profit, consumer surplus, producer surplus, total surplus, and dead weight loss. If the monopolist is forced to produce where P = MC, what are the eq..

Explain bovine serum albumin is a biochemically : Bovine serum albumin (BSA) is a biochemically useful protein. A 0.225 gram sample of bovine serum albumin is dissolved in water to make 0.117 L of solution,

What is the average annual rate of growth of real gdp : This is for a Macro class I am taking a test prep and I need like a step by step guide as to how i can do this using excel (the data must be found online) I apreciate as much help as possible! Question 1- Using a spreadsheet program, download the..

Explain specific metric unit : When working NMR questions, solutions maunuals say that the peaks are 1.0 spaces long or 5.5 spaces long.

Calculate the intercept in each of the four quarters : Consider a firm subject to quarter-to-quarter variation in its sales. Suppose that the following equation was estimated using quarterly data for the period 2006-2013 (the time variable goes from 1 to 32). The variables D1, D2 and D3 are , respecti..

Explain the dimensions of a typical atom : How would this computed ? compare with the dimensions of a typical atom? (-1 if much smaller, 0 if about the same magnitude, +1 if much bigger)

How the government is increasing the minimum wage : Assume you are the owner of a small cafe that employs 15 people, 10 of whom are front-line, unskilled workers, and currently paid the minimum wage. The state government is considering increasing the minimum wage. As a business owner, would you su..

User Account

All Pages