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 Dec 03, 2015 by Admin
With the Thanksgiving holiday last week, we decided to take a quick look into SimplyMap to see what pertinent variables are available for analysis. First, open the Variables panel and cli...
Posted on Dec 08, 2017 by Admin
Good afternoon, readers! This week we’re going to talk about project management in SimplyAnalytics and how to best take advantage of it. Why are projects needed? Many users have multiple...
Posted on Oct 02, 2015 by Admin
In this week’s SimplyMap tip, we wanted to do a quick write up reminding users about the Saved Tabs feature within SimplyMap. Did you know that SimplyMap will automatically save all of yo...
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...
Posted on Sep 05, 2019 by Admin
We are pleased to be exhibiting again at the Charleston Library Conference, on Tuesday November 5th, 2019. The Vendor Showcase will be held in the Gaillard Center Grand Ballroom (95 Calho...
Posted on May 06, 2013 by Admin
The GRI team is looking forward to exhibiting at SLA 2013 at the San Diego Convention Center, June 9th through the 11th. The Special Libraries Association (SLA) is a nonprofit global orga...
Posted on Feb 16, 2009 by Admin
Men's Health conducted their first survey of America's recycling habits, and used SimplyMap in their research. Here’s how the editors explain their methodology: To determine how well citi...
Posted on Aug 27, 2018 by Admin
Welcome readers! This week we are excited to feature our newest view in SimplyAnalytics, the Time Series Table.What is it?The Time Series Table allows you to quickly pull all years availa...
Posted on Nov 03, 2017 by Admin
This week we’ll talk about one of our favorite features in SimplyAnalytics - the custom combination location. This feature is a simple and effective means to create custom geographies whe...
Posted on Sep 27, 2019 by Admin
Hello readers! This week we provide an in-depth response to a question asking about the legend classification methods in SimplyAnalytics. This response is now part of our Help Center: htt...