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 Nov 29, 2009 by Admin
The ALA 2010 Midwinter Meeting will be held on January 15-19, 2010 at the Boston Convention and Exhibition Center. (Note that this is not the Hynes Convention Center). Geographic Research...
Posted on Oct 08, 2019 by Admin
Hello readers! This week’s “From the Help Desk” is short & sweet. Let’s get to it! Question: How do I analyze all of the states at once in a report? Answer: The Ranking Report allows ...
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...
Posted on May 25, 2010 by Admin
We will be exhibiting at the 2010 SLA Annual Conference & INFO-EXPO June 13-15 at the Ernest N. Morial Convention Center in New Orleans, LA. Join us at booth 1537 - bring your quest...
Posted on Feb 01, 2009 by Admin
Want to know the top 10 wealthiest ZIP codes in your state? How about the top 25 counties with the most elderly residents? Duke University students can now easily answer these questions a...
Posted on Mar 21, 2018 by Admin
The Quick Report is one of the newest features added to SimplyAnalytics - let’s take a look at how it can support your research. This report instantly provides you with a curated list of ...
Posted on Sep 20, 2019 by Admin
Hello readers! Today we have a brief update for you on what’s new in SimplyAnalytics. Since the release of the Quick Report feature a few months ago, we have been asked to make this repor...
Posted on Oct 16, 2015 by Admin
Did you know that SimplyMap includes the ability to export Shapefile data for use in desktop mapping software (such as MapInfo or ArcGIS)? This advanced feature extends the power of Simpl...
Posted on Dec 03, 2012 by Admin
Come visit the Geographic Research booth at the Ontario Library Association Super Conference this season. The conference will take place on January 30 - February 2, 2013 at the Metro Toro...
Posted on Oct 22, 2008 by Admin
Excerpt from University of Iowa Library blog: In your marketing class, you may be developing a marketing plan for a pre-made meals restaurant specializing in vegetarian menus in Chicagola...