Ask Business Economics Expert

In this data exercise, you will be looking at the relationship between changes in real Gross Domestic Product and changes in unemployment rates for the various metropolitan areas in Florida. Notice that GDP is constructed at the metro-area level, so it is a bit different than what you have seen before for entire countries. You will need to proceed as follows:
(1) Get data on changes in GDP for all available time periods in Florida metro areas. Go to:
http://www.bea.gov/iTable/iTable.cfm?reqid=70&step=1#reqid=70&step=1&isuri=1
and click on "Gross Domestic Product By Metro Area", choose "Real GDP", choose "All Industries", select all metropolitan areas in Florida (you should have at least 19) with the unit of measure as "percent change from preceding period", choose "all years". It should now print a page for you, go ahead and download it as an xls file and open in excel. We are only interested in "all industries" calculations so cut the other rows. Cut columns for everything but the area name and the yearly % changes for each of the years.
(2) Get data on changes in unemployment by year for Florida. Go to the BLS website at: http://bls.gov/lau/#tables then under the "Metropolitan Area Data" section, go to "over- the year change in unemployment rates for metropolitan areas" and download data for each yearly change. You will need to individually find the data for the relevant metropolitan areas for the Florida metro areas from part (1) then, next to each relevant yearly change in the previous worksheet you made in part (1), create a column for the change in unemployment for those same years. Notice this is only relevant starting from the 2007-2008 yearly change. Insert the data you found from the BLS dataset into these columns.
(3) You will then need to create a new worksheet where you reorder the previously downloaded data so that you have something that looks like (do this for each of the 19 Florida metro areas...notice that Palm Coast can be dropped, where delta means "change in"):

Tampa 2007-2008 2008-2009 2009-2010
2010-2011 2011-2012
Delta Unemployment
Delta rGDP

(4) Now you will use the above information to create 20 different charts (all placed in a new worksheet). 19 will be each separate metro area and the 20th will be for ALL the areas combined (i.e. you would just select ALL of each relevant column in making the chart rather than a subsection for that particular area). You will be graphing changes in unemployment on the x-axis and changes in real GDP on the y-axis. Title each table as "METRO AREA relationship" inserting the appropriate values for METRO AREA such as Tampa. Go ahead and insert 2 trendlines for each chart (click on each dataline to do this, and also insert the R- squared value as an option and the 3rd degree polynomial option while leaving all other options to their default setting). You should have axes labeled as well as the appropriate legends, and no "gridlines" visible in the chart so it looks cleaner. For the 20th chart, title it "Florida relationship".
QUESTIONS:

1. In which area do the unemployment and real GDP patterns look clearest (either going the same direction or opposite directions). Explain why you see this in the chart. Can you present a hypothesis for why you are seeing this pattern? What other information might you want in order to check your hypothesis?

2. What has been happening in Florida in general in terms of unemployment over this time period? What about for GDP? How can you explain what has been happening?

 

Business Economics, Economics

  • Category:- Business Economics
  • Reference No.:- M9221804

Have any Question?


Related Questions in Business Economics

Standards drive instruction therefore how do standards

Standards "drive instruction," therefore, how do standards influence curriculum planning?

Explain how the application of the pdca cycle can support a

Explain how the application of the PDCA cycle can support a competitive strategy of low cost leadership.

Ford motors expects a new hybrid-engine project to produce

Ford Motors expects a new? Hybrid-engine project to produce incremental cash flows of $ 95 million each year and expects these to grow at 4?% each year. The upfront project costs are? $900 million and? Ford's weighted av ...

A five-year bond with a yield of 11 continuously compounded

A five-year bond with a yield of 11% (continuously compounded) pays an 8% coupon at the end of each year. a) What is the bond's price? b) What is the bond's duration? c) Use the duration to calculate the effect on the bo ...

Image manufacturing is an electronics manufacturer and

IMAGE Manufacturing is an electronics manufacturer and retailer. Its main products are Ultrabook computers, PCs and calculators. The current price of the Ultrabook is $ 600, the PC is $700 and the calculator is $30. This ...

According to kulish what is about the design of the euro

According to Kulish, what is about the design of the euro currency that lessens its appeal compared to prior national currencies?

How has the value of the euro changed compared to other

How has the value of the Euro changed, compared to other countries, over the past 10 years (since the Great Recession began)?

In lecture we discussed why the production possibilities

In lecture we discussed why the production possibilities frontier (the boundary of the production possibilities set) is bowed 'outwards'. When might the production possibilities set be bowed 'inwards'? Give an example of ...

In 2013 gallup conducted a poll and found a 95 confidence

In 2013, Gallup conducted a poll and found a 95% confidence interval of the proportion of Americans who believe it is the government's responsibility for health care. Give the statistical interpretation. I do not underst ...

The standard deviation of the number of video game as

The standard deviation of the number of video game A's outcomes is 0.5479, while the standard deviation of the number of video game B's outcomes is 0.2498. Which game would you be likely to choose if you wanted players t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As