Reference no: EM13372433

The website for the Economic Report of the President is given below. You will need to download the following Microsoft Excel tables from the Economic Report of the President, 2012

• TABLE B-2.  Real gross domestic product, 1963-2011
• TABLE B-80.  Federal receipts and outlays, by major category, and surplus or deficit, fiscal years 1945-2013
• TABLE B-39.  Civilian labor force participation rate and employment/population ratio, 1965-2011
• TABLE B-42. Civilian unemployment rate, 1965-2011

gpo.gov/fdsys/pkg/ERP-2012/content-detail.html

1. First, create a graph of that charts out the Federal Surpluses / Deficits and Real GDP in each year from 1965 to 2011. (Be careful with the Surplus / Deficit data, since there is an additional entry to account for a change in how the data was collected. I simply deleted this row for my graph.)
2. Again using Microsoft Excel, create a graph and chart the Civilian Labor Force Participation Rate and the Civilian Employment to Population Ratio on one axis and plot the civilian unemployment rate on a second "Y" axis? Plot each data series from 1965 to 2011.

Hints for Excel Graphs

1. You should graph these series as XY Scatter graph. To do this, the data for the X-axis  must be numeric. That last sentence is important but is all that I will say on the topic.
2. You will notice that the scales are different on some of the data series that you will be graphing. You probably want separate Y-axes for data that are widely variant.
   1. To accomplish this right click (Control-Click on a Mac) on the data series that you wish to have on a separate Y-Axis.
   2. Select "Format Data Series"
   3. Then Click on "Axis" and select "Secondary Axis"
   4. While you are in the "Format Data Series" you can ensure that each data set has a line.
3. You can drag the Legend inside the graph itself and then resize your graph to make it more legible.