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 08, 2018 by Admin
The SimplyAnalytics team will be exhibiting at ALA Midwinter in Denver February 9-12. Stop by booth 2152 for a visit and a tour of SimplyAnalytics, the best-in-class analytics and data vi...
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 Jul 26, 2016 by Admin
In this week’s SimplyMap report, we’ll take a look at the Retail Market Power dataset and provide a simple, effective example of how the data package can be used. If your institution curr...
Posted on Oct 07, 2024 by Admin
We're headed to Charleston! Come visit the SimplyAnalytics team on November 12th at the Gaillard Center at booth 41. We'll be doing live demonstrations of the database, answering question...
Posted on Oct 24, 2019 by Admin
Hi everybody! This week we wanted to bring you something unique, so we’re taking you behind the scenes to show you what goes in to setting up the SimplyAnalytics conference booth you’ve c...
Posted on May 16, 2022 by Admin
Hello readers! We hope you are having a wonderful day. Today we feature a question from the help desk that we think many users would find useful. Let’s get started. The question: How can ...
Posted on Nov 04, 2013 by Admin
SimplyMap 3.0 is here, and uses the latest technology to provide better performance, improved reliability, and powerful new features. There are many improvements designed to make it easie...
Posted on Aug 15, 2013 by Admin
Anyone who has traveled to Seattle hoping for a sunny day could fairly estimate that it is one of the rainiest states with the highest level of precipitation each year. SimmonsLOCAL varia...
Posted on Aug 20, 2015 by Admin
Is there a specific age group and income bracket you are specifically interested in researching for a target location? Our Life Stages module has the information you need. Life Stages, by...
Posted on Feb 20, 2018 by Admin
We are looking forward to attending the annual SCELC (Statewide California Electronic Library Consortium) Vendor day, at Loyola Marymount University in Los Angeles on March 8th. In additi...