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 07, 2011 by Admin
We will be exhibiting at the American Library Association Midwinter Meeting & Exhibition in Dallas this January. Visit us at booth 2513 for a demonstration and to have all your Simply...
Posted on Sep 28, 2018 by Admin
Welcome readers! Today we have a quick feature highlight that will assist you in browsing and searching for data variables. All data variables have a path where they reside within their d...
Posted on Jun 21, 2019 by Admin
Come visit the SimplyAnalytics booth (#3010) at the upcoming ALA 2019 show in Washington, D.C.! Our team will be on hand offering quick demos of SimplyAnalytics, answering questions and s...
Posted on Jun 25, 2015 by Admin
In this week’s SimplyMap report, we review the different options available when searching for a business. The easiest and fastest method of mapping businesses or creating a business repor...
Posted on Nov 19, 2019 by Admin
Hello readers! Today we are bringing you a new blog entry inspired by a recent Help Desk question. If you ever have any questions about SimplyAnalytics, please do not hesitate to reach ou...
Posted on Jan 23, 2024 by Admin
We are excited to again make the trip to Los Angeles for SCELCapalooza 2024 hosted at Loyola Marymount University! Please drop by our table on Wednesday, Feb. 28th to learn more about Sim...
Posted on Jul 28, 2013 by Admin
We recently discovered some interesting data on participation and attitudes towards recycling, and decided to dig a bit deeper into our Experian SimmonsLOCAL data. This data package inclu...
Posted on May 06, 2013 by Admin
We will be exhibiting at ALA 2013 at McCormick Place in Chicago, IL, June 28-July 1. The ALA Annual Conference programs, updates, conversations, and other events cover all of the key issu...
Posted on Nov 11, 2013 by Admin
Chad Boeninger, Business & Economics Subject Specialist at Ohio University Libraries has produced some excellent tutorial videos to help students learn how to analyze data and create ...
Posted on Jul 09, 2015 by Admin
In this week’s SimplyMap report, we set out to find which cities have the highest percentages of people who use their bike as their mode of transportation to work in the US. Let’s get sta...