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 May 19, 2016 by Admin
Drop by booth #215 at the SLA 2016 conference to chat with us and get the latest info on SimplyMap. We look forward to seeing our customers, friends, and all others interested in learning...
Posted on Jan 19, 2009 by Admin
The 2009 Midwinter Meeting will be held in Denver, CO, from Jan 23–28, 2009. http://www.ala.org/midwinter The exhibits will be held Jan 23–26, 2009 at the Colorado Convention Center,...
Posted on Feb 05, 2015 by Admin
Our Winter Sweepstakes has begun! Enter to win an iPad Mini 3 or Kindle Fire. How to Enter: Follow @SimplyMap on Twitter Like our SimplyMap Facebook Page for a 2nd Chance to Win If you ...
Posted on Jan 23, 2015 by Admin
SimplyMap offers a total of 5 unique types of reports: Standard Report, Ranking Report, Business Report, Ring Study, and Location Analysis. This brief write up will define what each repor...
Posted on Nov 23, 2012 by Admin
Men's Health magazine is charting vanity in US cities, with help from SimplyMap. What did they find? The Sunshine State, with a long history of going to great lengths to look good, tops t...
Posted on Sep 03, 2015 by Admin
This week we explore the SimmonsLOCAL data package to find which cities in America have the highest percentage of residents enrolled in a frequent flyer program. SimmonsLOCAL is available...
Posted on Oct 08, 2008 by Admin
Geographic Research, Inc. (GRI) is pleased to sponsor the fourth annual American Collegiate Retailing Association’s Undergraduate Student Retail Analysis Competition. This is the second ...
Posted on Dec 15, 2014 by Admin
Custom Locations allow SimplyMap users to combine several locations into one larger region. For example, you can use this feature to combine three adjacent ZIP Codes to create your study ...
Posted on Feb 21, 2018 by Admin
We are looking forward to attending our first Electronic Resources & Libraries (ER&L) conference in Austin, TX! Visit us at Table #510 for a closer look at SimplyAnalytics – the b...
Posted on May 26, 2020 by Admin
Hello readers! We hope you are doing well, and thank you for your continued support of SimplyAnalytics. We are excited to announce that scatterplots are officially live! Scatter plots ar...