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 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 Sep 08, 2016 by Admin
One of our favorite uses of SimplyMap is to find data that validates our general assumptions and observations. For example, in a previous blog we wrote about the growth of tablet ownershi...
Posted on Mar 02, 2009 by Admin
ACRL's 14th National Conference will be held at the Washington State Trade and Convention Center in downtown Seattle, March 12-15, 2009. Every other year, ACRL offers its premier profe...
Posted on May 18, 2015 by Admin
The SimplyMap team is looking forward to visiting with customers and others at the SLA Annual Conference, coming to Boston on June 14-16. Come visit us at Booth #916, we are happy to answ...
Posted on May 19, 2015 by Admin
We will be attending ALA this summer in San Francisco (hint: dress warm!). Visit us at Booth 413 and don't forget to enter our raffle - we will be giving away a $100 gift certificate to A...
Posted on Jul 24, 2013 by Admin
Registration is now open for the North Carolina Library Association Conference! Visit us at the 60th biennial conference (Booth #45) through October 15 - 18, 2013. We have beautiful ca...
Posted on Feb 21, 2018 by Admin
We are looking forward to sharing SimplyAnalytics with the public library community at the upcoming PLA 2018 Conference in Philadelphia, PA. Our team will be exhibiting in Booth #855. Vis...
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 Jun 08, 2015 by Admin
In this week’s report we take a look at one folder found within SimplyMap’s SimmonsLOCAL data package. SimmonsLOCAL is a powerful targeting and profiling system that provides insights int...
Posted on May 08, 2018 by Admin
This summer's ALA conference is in New Orleans and the SimplyAnalytics team will be exhibiting at booth #837. We hope you stop by to learn about new features, check out our new data offer...