Go up
Using SimplyMap to Identify Relationships Between Variables
Posted on Nov 11, 2015 by Admin
Inspired by a recent help desk ticket, we wanted to discuss how users may utilize SimplyMap to identify relationships between unique variables. For example, does having a college degree significantly impact the median income of areas? And how does median income effect spending on eating out? Let’s take a look at ZIP Codes within the state of North Carolina.
To quickly analyze a larger area by its smaller geographies, a Location Analysis Report is ideal.
Click on New Tabular Report > Location Analysis:
Choose the state of North Carolina, and navigate to the variables you would like to see compared and analyzed. In this example, we’ll use:
Household Inc, Median
% Education, College, Master's or Doctorate Degree, 2015
% Education, High School
Food away from home (Household Average)
# Households (HHs)
Once you’ve selected your variables, close out the Variables Panel and your report will be created. Be sure to select ZIP Codes from the Analyze Data By option that appears towards the top, shown below.
The last step is to choose a variable (column header) and Sort Descending. For example, if you sort descending for Median HH Income, you will get a ranked list (from high to low) of income by Zip Code. Scan the other columns to get a sense of education levels in these locations, and how much they tend to spend eating out.
Sort Descending Income Results:
Conclusion: The results yield that higher median income areas tends to also have a higher percentage of residents who have at least a college degree. The money spent eating out was somewhat surprising as results did not vary significantly in lower median income areas (although it did go down and especially in the very low income areas).
Note: You may also want to look at # Households or Population Totals in these areas as the averages and percentages would be impacted by those figures.
These results seem to verify a relationship that’s already well known and somewhat intuitive, however, with more than 60,000 variables in SimplyMap you could study relationships between Median Income and Whiskey Drinking, or Pet Ownership, or Yoga Participation, Transportation to work... the possibilities are endless. We’ll be sure to revisit this same topic in the near future!
More from SimplyAnalytics
Posted on Jan 24, 2009 by Admin
Men's Health magazine took a look this month at where our wireless habits are most out of control. Their methodology includes the use of SimplyMap: First, we crunched data from SimplyMap...
Posted on Feb 24, 2019 by Admin
We will be exhibiting at SCELC* Vendor Day on March 14th. Visit us at table 510 and attend one of our two sessions demonstrating SimplyAnalytics. The presentations will highlight newly av...
Posted on Nov 11, 2013 by Admin
Chad Boeninger, Business & Economics Subject Specialist at Ohio University Libraries has produced some excellent tutorial videos to help students learn how to analyze data and create ...
Posted on May 28, 2009 by Admin
The Charleston Advisor, which publishes critical reviews of online resources for libraries, published a review of SimplyMap in April. We are very pleased to have received 4 1/4 stars out...
Posted on Dec 06, 2009 by Admin
ALA's Choice Magazine, publisher of independent reviews of products and services for academic libraries, released a new review of SimplyMap in the December 2009 edition. The reviewer, Car...
Posted on Mar 02, 2015 by Admin
In this week’s SimplyMap tip, we outline the process of creating a radius location. Radius locations are a great way to quickly gather information from an area surrounding a target addres...
Posted on Aug 20, 2015 by Admin
Is there a specific age group and income bracket you are specifically interested in researching for a target location? Our Life Stages module has the information you need. Life Stages, by...
Posted on Aug 13, 2015 by Admin
In this quick SimplyMap report, we use Census data to help us identify which city in the United States has the highest percentage of residents who reported walking to work as their mode o...
Posted on Jul 20, 2020 by Admin
Hello readers! We hope you are doing well and staying safe. Today we are excited to introduce the Simmons NCS crosstabs functionality! This is a feature we’ve been working on for a while,...
Posted on Nov 11, 2014 by Admin
With Veteran’s Day in the US this week, we thought it would be an ideal time to explore some of the variables in SimplyMap that pertain to veterans. Specifically, we wanted to know which ...