Question

Get data from the U.S spending on steel as a percentage of GDP from the last...

Get data from the U.S spending on steel as a percentage of GDP from the last 30 years and plot it on Excel.

PLEASE INCLUDE ALL EXCEL STEPS, THANK YOU

THE DATA NEEDS TO BE SEARCHED, IT IS NOT GIVEN. YOU HAVE TO FIND THE DATA AND PLOT IT

0 0
Add a comment Improve this question Transcribed image text
Answer #1


Then calculate the Growth Rate ROE- Equity ratio- Payout ratio- Growth Rate ROEx Equity ratio xPay out ratio Growth Rate- b.

Sorry due to techinal error unable to load correct answer, I will upload correct today. Please wait. Sorry of that.

Add a comment
Know the answer?
Add Answer to:
Get data from the U.S spending on steel as a percentage of GDP from the last...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1.What is the U.S. spending on steel as a percentage of GDP? Is the volatility of...

    1.What is the U.S. spending on steel as a percentage of GDP? Is the volatility of the spending share large? Get data from the last 30 years and plot it in Excel. PLEASE INCLUDE THE EXCEL FILE AND DETAILED STEPS AS TO HOW IT WAS DONE.

  • 2. Download the annual real GDP and GDP data of the United States 1950-2018 from FRED....

    2. Download the annual real GDP and GDP data of the United States 1950-2018 from FRED. For the real GDP, the data online is chain-weighted and uses 2012 as the base year. In the lecture hursday, I showed you the detailed method and calculated the new chain-weighted real GDP when 1990 is the base year. You are required to calculate a new sequence of chain- weighted real GDP given a new base-year. The base year you should use in your...

  • Go to BEA.gov and in the U.S. Economic Accounts find Table 1.1.5 (nominal GDP) and Table...

    Go to BEA.gov and in the U.S. Economic Accounts find Table 1.1.5 (nominal GDP) and Table 1.1.6 (real GDP) and download them for the period 1960 to the latest available year in annual frequency (yearly). In Excel plot line 1 of both tables within a single graph. Where do they cross? Explain what is the relationship between real and nominal GDP before and after the crossing point? Why? (25 points) In Excel, using the formula “=ln( )” take the natural...

  • The following table shows data on a hypothetical country's Real GDP from 1970 through 1978: Real...

    The following table shows data on a hypothetical country's Real GDP from 1970 through 1978: Real GDP Year (Billions of Dollars) 1970 192 1971 1972 1973 1974 1975 1976 1977 206 202 200 202 1978 210 ols The green line on the following graph shows the economy's long-term growth trend. ciples of Use the blue points (circle symbol) to plot the Real GDP in each of the years listed. (Note: Plot your points in the order in which you would...

  • 1. The federal budget The following table lists federal expenditures, revenues, and GDP for the U.S....

    1. The federal budget The following table lists federal expenditures, revenues, and GDP for the U.S. economy during several years. All numbers are in billions of dollars Year Revenues Expenditures GDP 2000 2001 2002 2003 2004 2,025 1,991 1,853 1,783 1,880 1,789 1,863 2,011 2,160 2,293 9,817 10,128 10,470 10,961 11,686 Plot the data for revenues and expenditures as a percentage of GDP on the following graph, rounded to the nearest percent. Use the purple points (diamond symbol) for expenditures...

  • The Data of Macroeconomics — End of Chapter Problem Obtain the percentage of GDP accounted for...

    The Data of Macroeconomics — End of Chapter Problem Obtain the percentage of GDP accounted for by each of the four components of GDP for 1976, 1996, and 2016. Data on the size of the components of GDP in the Canadian economy can be found at the GlobalEconomy.com. Specifically, you will seek data on Personal consumption expenditures ("Household consumption, percent of GDP") Gross private domestic investment ("Capital investment, percent of GDP") Government purchases ("Government spending as percent of GDP") Net...

  • The following table shows data on a hypothetical country's real GDP from 1980 through 1988:

    The following table shows data on a hypothetical country's real GDP from 1980 through 1988:YearReal GDP(Billions of Dollars)198046019814751982480198349019845101985515198650519875001988505The green line on the following graph shows the economy's long-term growth trend.Use the blue points (circle symbol) to plot the real GDP in each of the years listed. (Note: Plot your points in the order in which you would like them connected. Line segments will connect the points automatically.) Next, place the black point (plus symbol) on the graph to indicate the...

  • 8. Problems and Applications Q8 Consider the following data on U.S. GDP: GDP Year 2014 2015...

    8. Problems and Applications Q8 Consider the following data on U.S. GDP: GDP Year 2014 2015 2016 2017 2018 (Billions of current dollars) 17,521.7 18,219.3 18,707.2 19,485.4 20,494.1 (Billions of 2012 dollars) 16,899.8 17,386.7 17,659.2 18,050.7 18,566.4 Source: "National Economic Accounts."U.S. Bureau of Economic Analysis. The percentage change in nominal GDP from 2017 to 2018 was _ The percentage change in real GDP from 2014 to 2015 was True or False: The percentage change in real GDP from 2014 to...

  • Go to the Australian Bureau of Statistics website and find the latest (December 2018)figures for output. In particular, find the percentage change in Trend GDP from the September Quarter 2018 to Decem...

    Go to the Australian Bureau of Statistics website and find the latest (December 2018)figures for output. In particular, find the percentage change in Trend GDP from the September Quarter 2018 to December Quarter 2018; and the December Quarter 2017 to December Quarter 2018; and the percentage change in Seasonally Adjusted GDP over the same two periods.(2 marks)b)Do the same for the December 2017 figures.(1mark)c)Explain whether, based on the GDP data and all else equal, you would prefer to be incumbent...

  • Fiscal policy assume the U.S economy has the following GDP is 18,500 billion down from 19,350...

    Fiscal policy assume the U.S economy has the following GDP is 18,500 billion down from 19,350 nine months ago. Unemployment is at 6.8% up from 4.2% nine months ago. inflation is stable at 2.0% MPC+.75... NRU=4.0% and target inflation is 2,0%.. how do you figure this out using OKUN"S law p;ease help calculate?? ALSO NEED TO RECALCULATE MY GOVERMENT SPENDING AND TAX CUT,,,,,, TO MAKE SURE THE INCREASED GOVERMENT SPENDING AND HOUSEHOLD SPENDING DIDN.T LEAD TO A RESULT OF A...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT