Create a graph of that charts out the federal surpluses

Reference no: EM13106443

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

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.)
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

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.
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.
You can drag the Legend inside the graph itself and then resize your graph to make it more legible.

Reference no: EM13106443

Questions Cloud

Calculate the eoq and the total annual cost : The current order quantity for Paul's Pasta Pinwheels is 200 boxes. The order cost is $4 per order, the holding cost is $0.40 per box per year, and the annual demand is 500 boxes per year.

Proportion testing with z test : What is the alternative hypothesis consistent with the claim the test subject is an expert? Which of the following is consistent with the rule for the null hypothesis and with the alternative:

Discuss importance of calculation and interpretation ratios : Discuss the importance of the calculation and interpretation of ratios, to complete an effective financial ratio analysis?

Application of z score and probability : Suppose that SAT score is normally distributed with a mean 988 and a standard deviation of 211 in 2004.A local college plans to set up a scholarship budget for 2005 where $5000 will be awarded to each incoming freshman whose SAT score is higher th..

Create a graph of that charts out the federal surpluses : 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 ..

Determine the total number of chocolates got by student : Teachers also found that strength of class is maximum satisfying all above conditions. Determine the total no. chocolates got by student A of the first class.

Standard scores in populations : A population with u=73 and o=9 is transformed into a new population with u=10 and o=2. What is the new value for each of the following scores in the population?

Describe active threat and opportunity management process : We have now covered the steps of the Active Threat and Opportunity Management (ATOM) process. What is your opinion of the process as it relates to risk management?

Standardized z-scores for comparisons : How can standardized z-scores be used to compare people across different contexts, such as the batting averages of two players -one who played in the 1970s and one who played in the 1990s?

User Account

All Pages