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 Jul 30, 2018 by Admin
Hello readers! Welcome to this week’s blog. This week we will feature the Related Data Table view and how you can use it to maximize your productivity in SimplyAnalytics. What is it? The ...
Posted on Dec 09, 2014 by Admin
In this week’s SimplyMap blog post, we set out to discover which large US cities spend the most money per year on their pets. To find this out we used the variable, “Pets, Household Avera...
Posted on Feb 14, 2017 by Admin
In previous blog entries, we highlighted the value of having a mapping application to complement premium data when analyzing America's geographic preferences in credit cards, and mayonnai...
Posted on Jun 05, 2025 by Admin
We’re excited to announce that SimplyAnalytics will be exhibiting at the American Library Association (ALA) Annual Conference in Philadelphia! We’re thrilled to showcase how SimplyAnalyti...
Posted on May 15, 2015 by Admin
In this week’s SimplyMap report, we want to share with you the many options available when exporting maps in SimplyMap. In SimplyMap, when a user selects Export Map Image from the Actions...
Posted on Jun 08, 2023 by Admin
We are excited to announce Mansi Nishit Trivedi as the winner of the 2023 BRASS Student Travel Award sponsored by SimplyAnalytics! Mansi, a Master of Information student at Dalhousie, has...
Posted on Nov 28, 2012 by Admin
Come visit the SimplyMap team at the ALA Midwinter Meeting, January 25 - 28, 2013 in Seattle, WA. We will be in Booth 1307, and as always we look forward to meeting with customers new and...
Posted on Sep 10, 2010 by Admin
SimplyMap Canada is now available at several Canadian institutions, including York University and Ryerson University, in Toronto. SimplyMap Canada has all of the great features included i...
Posted on Oct 29, 2015 by Admin
Did you know that SimplyMap allows you to search for businesses by NAICS or SIC codes? Searching by these codes is a great alternative to the general keyword search. Using the keyword sea...
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...