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.

(c) What is the unemployment 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?