Create a graph of that charts out the federal surpluses

Assignment Help Macroeconomics
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

  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.

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?

Reviews

Write a Review

Macroeconomics Questions & Answers

  Inflation targeting be a good policy

Why might it be difficult for the Fed to formally adopt inflation targeting?  Would inflation targeting be a good policy for the Fed in the present economic environment

  In using the taylor rule

In using the Taylor Rule as a guideline for monetary policy, what are the pros and cons of using forecasted values of inflation and output rather than observed values of these variables?

  Describe the present economic crisis situation in europe

Describe the present economic crisis situation in Europe.  Why has it been so difficult for the Europeans to find a solution to this problem?   Comment on what implications the crisis may have for the rest of the world if Europeans are not able to ag..

  Long-term federal government budget problems

Question:. Explain why there are long-term Federal government budget problems. Explain why the base-line forecast of the CBO is misleading.

  Derive and compare demand curve

Question based on Derive and compare demand curve,  Derive Ambrose's demand function for peanuts. How does it compare with Johnny's demand curve for peanuts?

  Problem based on utility function

Problem based on  Utility Function - Problem,  Answer and explain the following using a diagram which is completely labeled.

  Laffer curve : tax rate and tax revenue

Question based on Laffer Curve : Tax Rate and Tax Revenue,  Do raising tax rates necessarily raise tax revenue? What factors affect how tax revenue changes when tax rates change?

  Problem - income elasticity of demand

Problem - Income Elasticity of Demand,  Interpret the following Income Elasticities of Demand (YED) values for the following and state if the good is normal or inferior; YED= +0.5 and YED= -2.5

  Positive balance of payment

Question Positive Balance of Payment: "Things will look good for the US if we could just get to where we are consistently running a positive Balance of Payments."

  Effect of recession on the investment curve

Comment on the effect of a recession on the investment curve (only) and on the level of savings, investment, and the equilibrium real interest rate in the financial crisis that hits United States first starting in fall 2007.

  Affect of falling domestic investment on trade surplus and

How will a fall in domestic investment affect the trade surplus and net capital outflows in the domestic economy, the trade deficit and capital inflows in the rest of the world.

  Crises in the banking sector and bank run

Banking crises crisis decreases depositors' confidence in the banking system. What would be the effect of a rumor about a banking crisis on checkable deposits in such a country?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd