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 Aug 22, 2009 by Admin
Lynda Kellam, the Data Services & Government Information Librarian at the University of North Carolina, Greensboro has produced some new tutorial videos to help students learn how to ...
Posted on Jan 28, 2010 by Admin
Come visit the Geographic Research booth at the Ontario Library Association Super Conference, February 24-27, 2010 at the Metro Toronto Convention Centre. The Ontario Library Association ...
Posted on Apr 05, 2019 by Admin
Come visit the SimplyAnalytics booth (325) at the upcoming ACRL 2019 show in Cleveland! Say hello, grab a chocolate, and stay for a quick demo of SimplyAnalytics. The team will be showcas...
Posted on Jan 29, 2016 by Admin
In a previous blog entry, we highlighted the benefits of having multiple years of data available for the same variable. This allows users to identify trends over time. Keeping with the sa...
Posted on Jun 02, 2016 by Admin
Three weeks ago we utilized the SimmonsLOCAL data set to visualize contiguous America’s mayonnaise brand preference. Staying with the American visualization theme, this week’s report will...
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 Jul 30, 2015 by Admin
One great feature within SimplyMap is the ability to track the same variable across multiple years. In this report, we will track the percentage of households in the US ordering items fro...
Posted on Apr 30, 2008 by Admin
Doreen Harwood, Business Librarian from the University of Washington has developed a series of detailed tutorials on using SimplyMap. The tutorials, which are Flash-based and interactive,...
Posted on Jan 10, 2024 by Admin
We are delighted to announce our sponsorship of the Midwest Entrepreneurship Case Competition! At SimplyAnalytics, we understand the power of data-driven decision-making in entrepreneursh...
Posted on Dec 16, 2015 by Admin
Visit the SimplyMap team at the ALA Midwinter Meeting 2016 in Boston. We will be at booth #1913 offering product demonstrations, tips & tricks, and of course Ghirardelli Chocolate! Ex...