02 Jun Question Assignment 1.Measurement and interpretation of regional concen
Question
Assignment
1.Measurement and interpretation of regional concentration and diversification. In this exercise we use the file HW3-14.xlsx. This data set was obtained from the Bureau of Economic Analysis (BEA):http://www.bea.gov/regional/index.htm
(a)Click on the BEA Website and select Regional Definition. Concisely discuss pivotal aspects of these data in terms of employment definition, industrial classification (specifically the SIC, NAICS classification) and disclosure avoidance procedures (max. 150 words).
(b)The file HW3-14.xls includes the BEA employment data for 14 NAICS sectors across 51 states for 2002 and 2012.
i. Calculate the location quotients for all the sectors and states considered in 2002 and 2012. Explain what these location quotients mean (Give some examples). Explain how they change over time. ii. Calculate the Hirschmann-Herfindahl Index for 2002 and 2012. Draw a Bar Chart for the 2 periods considered (Hint: look at the material). Discuss in details how these indexes change over space and time.
iii. Calculate the Relative Diversity Index for states in 2002 and 2012. Discuss results in details.
2.This exercise deals with the question whether Zipf’s law applies to a state you will choose (outside Ohio). To get the data set:
•go on the census websitehttp://quickfacts.census.gov/qfd/index.htmland select a state.
•Then click on browse data sets for a state of YOUR choice (outside Ohio). Note that you will need a state with at least 50 cities. So don’t pick states like New Hampshire or Rhode Island!
•Click on ”Want more? Browse data sets for YOUR STATE”.
Under Population Estimates select Places in your state listed alphabetically. Download the file in Excel.
•Copy and paste the first two columns (Geographic Area and Census data 2010) in a new Excel spreadsheet. Sort both column with respect to the largest cities.
•Create a third column labeled Rank describing the rank of cities. The largest city will have the value 1 and the ith cities will be rankedi.
•Finally, create the logarithm of the two variables you will analyze: rank and population size. You’re now ready to answer the questions!
For the specification of Zipf’s law use
ln(rank) =a+bln(pop) +e,
wherepoprefers to population,rankto the position of a city when ranked in decreasing order of population size,aandbare estimated coefficients, andeis the error terms.
(a)Estimate the parameteraandb.
(b)Use graphs to support or reject the validity of Zipf’s law for the US rank size distributions in 2010.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.