Tag Archives: Bureau of Economic Analysis

Metro by Metro: What $100 Buys

.. data and tools to examine the purchasing power of the incomes in different metros and states … this section reviews how you can access to data on what $100 buys by state and metro. Examine patterns of what $100 buys by year, 2008-2014, for all items and by type of goods & services category. Use the interactive table to view, rank, compare the Buying Power Index for each/all states and metros (MSAs). See the main Web page for more details.

What $100 Buys by Metro: 2014
The following graphic shows patterns of 2014 all items buying power of $100 by metro (MSAs). The color patterns/intervals are shown in the inset legend. Click graphic for larger view. Expand browser to full window for best quality view. Use GIS tools to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Varying prices by region can be normalized using Regional Price Parities (RPP). The RPP is a weighted average of the price level of goods and services for the average consumer in one geographic region compared to all other regions in the U.S. See more about RPP measures. Using the RPP data, what $100 will buy can be determined by state and metro for the categories of all goods and services, goods, services-rents and other services. See about RPP goods and services types.

In the Boston metro, $100 buys about 90.7 percent of all items goods and services due to the high prices there. $100 in Boston seems more like $90.70 compared to the national average. In the Jefferson City, MO metro, the opposite is true. $100 buys all items goods and services due to lower prices in that metro. $100 in the Jefferson City, MO metro is the equivalent of $121.65 of all items goods and services compared to the national price levels.
• the Boston metro all items buying power index is 90.70
• the Jefferson City, MO metro all items buying power index is 121.65

Interactive Table – Top 10 Metros
The following graphic illustrates use of the Buying Power Index interactive table. This graphic shows the 10 metros that have the all items highest Buying Power Index. Use the interactive table to view/examine areas of interest.

– click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Navigating the U.S. Federal Statistical System

.. an overview of the Federal statistical system and how to access data  .. the U.S. Federal Statistical System offers a vast array of diverse data resources that are useful in wide-ranging planning and analytical applications. Many of these data resources, such as census block level demographics from the decennial census, are unique in scope and content; in many cases there are no alternative data resources.

But there are issues/challenges for the data user to navigate the Federal Statistical System. Examples … the Bureau of Labor Statistics releases total employment data by county quarterly and monthly through multiple programs. The data values differ, for methodological reasons, but the net result can be confusion. The Census Bureau releases total employment data from many statistical programs by county both annually and more frequently. Where are these alternative total employment data and how can they be accessed? How do these various measures differ and which data are right for my situation? This section provides basic statistical program information. Subsequent updates will provide more detail.

This section provides an overview of the U.S. Federal Statistical System (FSS) and information that can help stakeholders navigate access to selected types of data produced by the FSS. While the FSS is focused on agencies that collect, develop and make available statistical data, there is a broader set of data and resources that relate to accessing and using these data. As technology and related data analytics resources have evolved, access to and use of these data is closely associated with the development of geographic data by Federal statistical and other agencies and Geographic Information Systems (GIS).

The FSS is a decentralized set of agencies that collect, develop and make available statistical and geographic data. The OMB Office of Statistical Programs and Standards (SPS) provides a FSS coordinative role. The SPS establishes statistical policies and standards, identifies priorities for improving programs, evaluates statistical agency budgets, reviews and approves Federal agency information collections involving statistical methods, and coordinates U.S. participation in international statistical activities.

While the FSS spans more than 100 agencies, the 13 “principal statistical agencies” have statistical work as their principal mission. Excluding funding for the decennial census ($919.3 million requested for the Decennial Census for FY 2016), approximately 38 percent ($2,486.9 million of the $6,486.6 million total proposed for FY 2016 President’s budget request) of overall funding for Federal statistical activities (of the Executive Branch) provides resources for these 13 agencies. The principal statistical agencies include:
Census Bureau (Commerce)
Bureau of Economic Analysis (Commerce)
Bureau of Justice Statistics (Justice)
Bureau of Labor Statistics (Labor)
Bureau of Transportation Statistics (Transportation)
Economic Research Service (Agriculture)
Energy Information Administration (Energy)
National Agricultural Statistics Service (Agriculture)
National Center for Education Statistics (Education)
National Center for Health Statistics (CDC/HHS)
National Center for Science and Engineering Statistics NSF/Independent
Office of Research, Evaluation, and Statistics — SSA/Independent
Statistics of Income (IRS)

The remaining 62 percent of the FY 2016 budget involves more than 100 programs that conduct statistical activities in conjunction with another program mission. These statistical programs are components within a Federal department or other agency. They include a broad set of centers, institutes, and organizations in addition to the 13 principal statistical agencies.

There are also Federal agencies whose statistical activities are not part of the Executive Branch. These agencies include the Congressional Budget Office, which develops and applies projection models for the budgetary impact of current and proposed Federal programs; the Federal Reserve Board, which compiles the widely used Flow of Funds report and other statistical series and periodically conducts the Survey of Consumer Finances; and the U.S. Government Accountability Office, which uses statistical data in evaluations of government programs.

Guide to Navigating the Federal Statistical System
The following graphic is a snapshot of the Guide to Navigating the Federal Statistical System. See http://proximityone.com/fss.htm to access the entire guide.

– click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn

Real Purchasing Power by State & Metro

.. how does the real purchasing power in metros of interest compare to other metros? Use data and tools reviewed here to examine the purchasing power of the incomes in different metros and states … this section provides access to regional price parities (RPPs) estimates developed compare regions within the U.S. RPPs are regional price levels expressed as a percentage of the overall national price level for a given year. The price level is determined by the average prices paid by consumers for the mix of goods and services consumed in each region. See about these data. See example about using RPPs below in this section.

• Use the interactive table to view, rank, compare the RPPs
.. for all states and metropolitan statistical areas (MSAs).
• Use GIS tools described here to develop RPP thematic pattern maps.
.. add your own data & geography, select different HPI measures or criteria.
.. zoom to different geographic extents, label and modify colors as desired.

Patterns of Regional Price Parities by Metro: 2014
The following graphic shows patterns of 2014 all items Regional Price Parities by metro (MSAs). The color patterns/intervals are shown in the inset legend. In additional views (below this graphic) metros are labeled with the 2014 all items RPP. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional Views — install GIS project (see steps here) and create your own custom maps
Georgia & Region
Missouri & Region
Texas & Region

Using the RPP — Illustrative Examples
1. Comparing real purchasing power:
  — Houston, TX metro compared to Waco, TX metro.
The the all items RPP for the Houston metro in 2014 was 100.3 while the all items RPP for the Waco, TX metro in 2014 was 91.5. (from RPP table). On average, prices are 0.3 percent higher and 8.5 percent lower than the U.S. average for the Houston metro and the Waco metro, respectively. The per capita personal income (PCPI) for the Houston metro in 2014 was $54,820 and the per capita personal income for the Waco metro was $35,340 (get from the table at http://proximityone.com/reis.htm). The RPP-adjusted PCPI values are $53,223 ($54,820/1.03) and $38,622 ($35,340/0.915), respectively. The gap between the purchasing power of the two metro PCPIs is reduced when adjusted by their respective RPPs.

2. Comparing real purchasing power:
  — Washington, DC metro compared to Columbia, MO metro.
• Washington, DC metro 2014 all items RPP: is 119.4 (from RPP table); 2014 PCPI: $62,975 (from this table)
• Columbia, MO metro 2014 all items RPP: 93.0 (from RPP table); 2014 PCPI: $41,418 (from this table)
• The RPP-adjusted PCPI values are $52,742 ($62,975/1.194) and $44,535 ($41,418/0.93), respectively.

Using the RPP Interactive Table
Use the interactive table to examine the RPP by state and metro. The following graphic illustrates use of the table to show the 10 metros having the highest 2014 all items RPP. Click graphic for larger view. Examine metros and states of interest with more detail using tools below the table.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive table

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

State Demographic-Economic Briefing Notes

.. with the ever increasing availability of demographic and economic data, it can be difficult to access key up-to-date data for the U.S. and individual states, metros and counties … among other geography.

Here we look at the “tip of the iceberg” — intentionally. This section provides links to access State Demographic-Economic Briefing Notes. A summary of selected key demographic-economic measures and trends for each state are presented in comparison with the U.S. Use the Briefing Notes to facilitate briefings to others, collaboration and to obtain a snapshot of current and trending conditions. These data are mostly taken from the more detailed tables available as links at the bottom of each Briefing Notes section.

The Briefing Notes have been developed using the Regional Demographic-Economic Modeling System (RDEMS). The Briefing Notes sections and related detailed tables update frequently.

The per capita real Gross Domestic Product (GDP) estimates, new this past week from the Bureau of Economic Analysis, for 2010 and 2015 were added today. See how this comprehensive measure of economic well-being is trending and compares to the U.S. overall in states of interest.

Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

America’s Million+ Population Cities: Chicago

.. there are 10 U.S. cities having population of 1 million or more … Chicago is ranked 3rd among all U.S. cities based on 2015 population.  The population of Chicago, IL changed from 2,695,605 in 2010 to 2,720,546 in 2015 (24,941 or 0.9%). The population of the U.S. overall changed from 308,758,105 in 2010 to 321,418,820 in 2015 (12,660,715 or 4.1%). Examine population characteristics and trends of the city of Chicago in context of other cities and counties using the interactive table.

Chicago is a principal city of the Chicago-Naperville-Elgin, IL-IN-WI Metropolitan Statistical Area (CBSA 16980). This section reviews selected geographic, demographic and economic characteristics of the city of Chicago and tools to analyze these data.

Chicago City in Regional Context
Chicago city is shown as green-fill semi-transparent area.

… view developed using the CV XE GIS software.
… click map for larger view.

Chicago Urbanized Area (orange fill pattern below city layer)
.. about urbanized areas

Examining Characteristics, Patterns and Trends of Chicago
View extended demographic-economic characteristics of Chicago in this table. Compare attributes of the city for 2012, 2014 and change. Annual demographic-economic estimates are available for all geographies for areas of 65,000 population or more from the American Community Survey (ACS).

Regional Demographic-Economic System & Cook County, IL
View Cook County tables from RDEMS. Click links below to view demographic-economic characteristics of the county.
POP1 Population & Components of Change
POP2 Population by Age
HSG1 Housing Units & New Residential Construction
DEM1 Demographic-Economic Profile
LF1 Labor Force
LF2 Labor Force
EST1 Establishments, Employment, Earnings
CA4 Personal Income and Employment by Major Component
CA5 Personal Income by Major Component and Earnings by Industry
CA6 Compensation of Employees by Industry
CA25 Employment by Industry
CA30 Economic Profile
CA35 Current Transfer Receipts
CA45 Farm Income & Expenses

Comparing Chicago Annual Total Population to Other Areas
Use the interactive table in the related section to view, rank, query and compare annual population estimates for states, cities, counties and sub-county areas of interest.

View, Rank, Compare Chioago with any/all Other Cities
Use these tables based on ACS 2014 5-year estimates to view Chicago in context with other cities.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Metro Gross Domestic Product Patterns & Trends

.. 282 metropolitan statistical areas, of the total 381, experienced an increase in real Gross Domestic Product (GDP) between 2009 and 2014. Collectively, real GDP for U.S. metropolitan areas increased 2.3 percent in 2014 after increasing 1.9 percent in 2013. Use the interactive table and GIS project/datasets described here to view/analyze patterns and characteristics in metros of interest. See more details in related Web version of this document.

Percent Change in Real GDP by Metro, 2009-2014
The following graphic shows patterns of percent change in real GDP by metro from 2009 to 2014. The orange fill pattern shows metros experiencing a decrease in real GDP over the period.

— view created using CV XE GIS and associated MetroGDP GIS Project
— click graphic for larger showing legend details.

View Metro GDP Characteristics section in the Metropolitan Area Situation & Outlook Reports, providing the same scope of data as in the table below integrated with other data. See example for the Dallas, TX MSA.

GDP by metropolitan area is the sub-state counterpart of the national gross domestic product, the most comprehensive measure of U.S. economic activity. GDP by metropolitan area is derived as the sum of the GDP originating in all the industries in the metropolitan area. Use the interactive table, tools and resources provided/described in this section to access and analyze current and real metro GDP patterns. See more about metro GDP below in this section.

Use the Metro GDP GIS Project/Datasets
Use the CV XE GIS software and MetroGDP GIS project to create thematic pattern maps and integrate the employment situation data with other data. Add your own data. Apply different queries. Label geographic areas. Create zoom views. Put results into stories and analytical documents. ProximityOne User Group members may install the MetroGDP GIS Project (see details here) and prepare thematic pattern maps like the one shown above.

Use the Metro GDP Interactive Table
The graphic below illustrates use of the Metro GDP Interactive Table to view, rank, query current dollar and real GDP annually over the period 2009-2014. This view shows metros ranked on real GDP change during the period 2009 to 2014. The National Rank column show the rank of the metro among all 381 MSAs as of 2014 based on current dollar GDP. Use the interactive table to examine peer groups and sets of metros of interest. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss accessing, integrating and using these data with other data that relate to your situation.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.