{"id":451,"date":"2013-09-26T07:50:51","date_gmt":"2013-09-26T11:50:51","guid":{"rendered":"http:\/\/ibit.temple.edu\/analytics\/?p=451"},"modified":"2015-09-12T14:39:35","modified_gmt":"2015-09-12T18:39:35","slug":"challenge-1-moneyballing-economic-development","status":"publish","type":"post","link":"https:\/\/ibit.temple.edu\/analytics\/challenge-1-moneyballing-economic-development\/","title":{"rendered":"Moneyballing Economic Development"},"content":{"rendered":"<h5><b>Philly Challenge<\/b><\/h5>\n<hr \/>\n<h3><b>Problem <\/b><\/h3>\n<p>Philadelphia has a strong employment base in higher education and healthcare\u2010related industries. However, other sectors such as manufacturing continue to lose jobs. The task for government is to support workforce development and business assistance in industry sectors where Philadelphia has a competitive advantage.<\/p>\n<p>Specific considerations that impact local development include:<\/p>\n<ul>\n<li>Philadelphia\u2019s concentration of talent in specific industries<\/li>\n<li>\u201cHot\u201d industries that are primed for growth<\/li>\n<li>City policies, demographics, and geography<\/li>\n<\/ul>\n<p>Visualize opportunities for economic development in the City of Philadelphia. The city wants to be able to focus its business attraction and retention and workforce development efforts in industries that will remain competitive in the future.<\/p>\n<p>There are several things which have been useful in identifying economic opportunities:<\/p>\n<ul>\n<li>Sectors in which Philadelphia has a competitive advantage relative to the region, state, or nation<\/li>\n<li>Emerging sectors that are growing at a faster rate locally than in the region, state, or nation<\/li>\n<li>Subsectors that are driving growth over time within a particular sector<\/li>\n<\/ul>\n<h3><b>Data<\/b><\/h3>\n<p>The Bureau of Labor Statistics provides data about employment and businesses at the County level using NAICS (North American Industry Classification System) codes. You can learn more about NAICS, and get their definitions at the <a href=\"http:\/\/www.census.gov\/eos\/www\/naics\/\">US\u00a0Census Site<\/a>.<\/p>\n<ul>\n<li>Find 2012 data on the <a href=\"ftp:\/\/ftp.bls.gov\/pub\/special.requests\/cew\/beta\/2012\">Bureau of Labor Statistics FTP server<\/a>.\u00a0For comparison data, find other years <a href=\"ftp:\/\/ftp.bls.gov\/pub\/special.requests\/cew\/beta\/\">here<\/a>.\n<ul>\n<li>Specifically, select <a href=\"ftp:\/\/ftp.bls.gov\/pub\/special.requests\/cew\/beta\/2012\/2012.annual.by_area.zip\">2012.annual.by_area.zip<\/a> and use it as the Final Year. Select your own Base Year.<\/li>\n<\/ul>\n<\/li>\n<li>Search for Philadelphia County, Pennsylvania<\/li>\n<\/ul>\n<p>Useful comparisons:<\/p>\n<ul>\n<li>U.S. Total<\/li>\n<li>Philadelphia-Camden-Wilmington, PA-NJ-DE-MD MSA<\/li>\n<li>Pennsylvania &#8212; Statewide<\/li>\n<li>U.S. Metropolitan Statistical Areas (Combined)<\/li>\n<\/ul>\n<h3><b>Example<\/b><\/h3>\n<p><strong><em>Bubble-Chart to Display Four Distinct Variables that Can Compare Philadelphia with the Country, the State, and the Region<\/em><\/strong><\/p>\n<p>A \u201clocation quotient\u201d measures how <i>specialized<\/i> a local economy is in a particular sector. It is calculated by dividing the share of employment in a particular sector in the local economy by the share in that sector in the national economy. The local economy is specialized in that sector if that number is greater than one. It is the y-axis of the depicted graph.<\/p>\n<p>A \u201cshift-term\u201d measures the <i>competitiveness<\/i> of that sector, or the local rate of change relative to the national rate of change. It is the x-axis of the depicted graph. Thus, a sector with a positive \u201cShift Term\u201d, which would lie on the rightward quadrants of the graph, would be growing at a faster rate, or shrinking at a slower rate, than that sector nationally. The formula for calculating the shift-term can be found below:<\/p>\n<p>(eit+n\/eit) &#8211; (Eit+n\/Eit) where:<\/p>\n<ul>\n<li>ei = total employment of a particular sector in the local economy<\/li>\n<li>Ei = total employment of a particular sector in the national economy<\/li>\n<li>t = year one<\/li>\n<li>t+n = final year<\/li>\n<\/ul>\n<p><a href=\"http:\/\/ibit.temple.edu\/analytics\/files\/2013\/10\/PhillyQuad.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-747 aligncenter\" alt=\"PhillyQuad\" src=\"http:\/\/ibit.temple.edu\/analytics\/files\/2013\/10\/PhillyQuad-300x268.png\" width=\"300\" height=\"268\" \/><\/a><\/p>\n<p>The <b>size <\/b>of the bubble represents size of local employment in a particular sector in the final year.<\/p>\n<p>The <b>color<\/b> tells us if the sector is growing or shrinking (in raw numbers and not relative to the national economy). Green would represent sectors that have grown by more than 5%, yellow for stable sectors that have had employment changes between -5% and 5%, and red for sectors that have declined by more than 5%.<\/p>\n<p>An analysis of private business sectors on the 2-digit level using this approach, a time-series of <span style=\"text-decoration: underline\">2004-2011, and comparing Philadelphia with the nation.<\/span><\/p>\n<p><em>Click image to see full size<\/em><\/p>\n<p><b><a href=\"http:\/\/ibit.temple.edu\/analytics\/files\/2013\/10\/PhillyBubble.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-thumbnail wp-image-746\" alt=\"PhillyBubble\" src=\"http:\/\/ibit.temple.edu\/analytics\/files\/2013\/10\/PhillyBubble-150x150.png\" width=\"150\" height=\"150\" \/><\/a><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Philly Challenge Problem Philadelphia has a strong employment base in higher education and healthcare\u2010related industries. However, other sectors such as manufacturing continue to lose jobs. The task for government is to support workforce development and business assistance in industry sectors where Philadelphia has a competitive advantage. Specific considerations that impact local development include: Philadelphia\u2019s concentration [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[25],"tags":[],"class_list":["post-451","post","type-post","status-publish","format-standard","has-post-thumbnail","category-25","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/ibit.temple.edu\/analytics\/files\/2013\/09\/PhiladelphiaImage.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ROyF-7h","_links":{"self":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/comments?post=451"}],"version-history":[{"count":30,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":994,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/451\/revisions\/994"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/media\/494"}],"wp:attachment":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/media?parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/categories?post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/tags?post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}