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 Feb 16, 2009 by Admin
Men's Health conducted their first survey of America's recycling habits, and used SimplyMap in their research. Here’s how the editors explain their methodology: To determine how well citi...
Posted on Jul 30, 2018 by Admin
Hello readers! Welcome to this week’s blog. This week we will feature the Related Data Table view and how you can use it to maximize your productivity in SimplyAnalytics. What is it? The ...
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 Jun 09, 2021 by Admin
Hello readers! SimplyAnalytics will be exhibiting at the Virtual ALA Annual Conference this year on June 23-26. Be sure to drop by our booth, and click the banner image to video chat with...
Posted on Jul 22, 2015 by Admin
In this week’s SimplyMap report, we take a look at one of our newly available data packages - ConneXions® from Nielsen. The ConneXions® segmentation system integrates consumer behavior an...
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 Feb 27, 2015 by Admin
SimplyMap is an excellent tool for market research, and it’s made even more powerful by Nielsen PRIZM data. Nielsen PRIZM is the highest quality market segment data available. Every house...
Posted on Sep 09, 2015 by Admin
This week’s SimplyMap report will set out to discover what America’s favorite type of music is. We will use data within the premium data package, SimmonsLOCAL to answer the question. The ...
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 Nov 06, 2013 by Admin
SimplyMap includes a number of helpful support tools; guided wizards available when and where you need them, detailed help files, and an online support center with FAQs and searchable kno...