U.S. State Metro 2012 Comparative Analysis Profiles

Situation & Outlook
- S&O Desktop
- S&O Profiles|Reports
> Comparative
> Narrative
> Site Analysis

CVXE GIS Tools

Data Resources Guide
- projections to 2060

Related Sections
- Situation & Outlook

- Applications Gallery
- States
- Congressional District
- School Districts
- Counties
- Cities/Places
- Tracts/Neighborhoods
- Block Groups
- Census Blocks

- Urban Areas

Estimates-Projections
- 2060 Demographic
... all county interactive table
- 2030 Demographic-Economic
- Single Year of Age

GIS Thematic Mapping
Visual Analysis Tools

Ranking Tables
National Scope
Demographic Change
2000-2010
- States
- Metros
- Congressional District
- School Districts
- Counties
- Cities/Places
- Census Tracts

U.S.-State-Metro Demographic-Economic Characteristics
-- Comparative Analysis Profiles

Decision-Making Information

ProximityOne
information resources & solutions
(888) DMI-SOLN
(888) 364-7656

Visual analysis with ProximityOne tools
click graphic for info; hover to pause

visually analyze clients/markets
site analysis using 1 mile radius

$median household income
patterns by census tract - Houston

113th Congressional Districts

US Asian Indian population 2010

geocoded students and school
McKinney ISD, TX

geocoded students and school
with tax parcels & streets

high school attendance zones
with schools by type

%high school graduates by
census tract - Puerto Rico

Austin, TX MSA counties &
places 10K+ population markers

Appalachia counties (green) &
coalfield counties (orange)

China provinces percent urban &
cities (markers) by state plan

Honolulu census tracts (red)
& census blocks

Central Park area NYC

Kansas City Metro & Counties
Home Depot locations (markers)

World Cities; focus on Spain

Decision-Making Information Blog
Examining Neighborhood Change

The Charlotte-Gastonia-Rock Hill NC-SC Metro and Austin-Round Rock-San Marcos TX Metro are roughly the same size based on total population. How do they compare based on educational attainment? percent population in poverty? homeownership rate? age distribution? migration? employment by industry? occupation? How do business opportunities compare? What about other metros? Choose from hundreds of measures in the state/metro demographic-economic interactive tables to compare and contrast states and metros based on side-by-side comparisons.

The U.S.-State-Metro Demographic-Economic interactive tables provide a useful resource to view/compare geographies when ranked on a specific subject matter column of interest. The interactive tables are also useful to view a selected set of geographic areas where subject matter fields are arrayed horizontally for each geographic area. The U.S.-State-Metro Demographic-Economic interactive tables are available in the following Web pages.
• General Demographics DP1 table
• Social Characteristics DP2 table
• Economic Characteristics DP3 table
• Housing Characteristics DP4 table
... side-by-side comparative analysis profiles can often add more to insights.

Comparative Analysis Profiles
Create "comparative analysis profiles" using data presented in the interactive tables. View demographic-economic attributes of selected geographic areas of interest in a side-by-side manner. Place the data in a spreadsheet for further analysis, linking with other data and/or printing or adding to a report.

Partial view of sample file (access full xls file here)

Steps to Create Comparative Analysis Profiles
The following example illustrates how to develop a comparative analysis profile for the Houston, TX metro, state of Texas and United States using the General Demographics DP1 data.
1. Save the DP1 xls file (see below) to a local drive.
2. Open the DP1 xls file using Excel or equivalent.
3. Open the General Demographics DP1 table.
4. Navigate to Houston, TX metro in DP1 table. Right click that row and select Copy from dropdown.
5. Go to the open DP1 xls file. Click on cell B1, right-click and select Paste. Data are loaded horizontally.
6. Right-click cell B1 and select Copy.
7. Click cell B2 and select Paste Special; choose the option transpose and click OK.
Houston metro data are now showing as a column of data (column B).
8. Repeat steps 4 through 7 for the state of Texas using column C rather than column B.
9. Repeat steps 4 through 7 for the U.S. using column D rather than column B.

Reusable DP xls template files are available as described below.

Spreadsheet Templates
The following spreadsheet templates (xls) are available for use as described above.
• General Demographics DP1 xls
• Social Characteristics DP2 xls
• Economic Characteristics DP3 xls
• Housing Characteristics DP4 xls

Additional Information
ProximityOne develops geodemographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact us (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.