American Household Spending on Pets
In this week’s SimplyMap blog post, we set out to discover which large US cities spend the most money per year on their pets. To find this out we used the variable, “Pets, Household Average” found in the consumer expenditure category in SimplyMap.
The national quantiles (by counties) in our legend ranged from a low of $190.35 to a high of $751.84. Using the “Create Ranking from Map” feature, we were presented with the following unfiltered results:
Creating a ranking report from a map using the US as the location will present county level data by default. Because we wanted to find larger US cities, we had to do two things: change the geography that the data was analyzed by, and create a population filter to show cities with a population greater than 100,000.
Changing How the Data is Analyzed
Changing the geographies of your ranking report is a simple two step process. First, select the “analyze data by” drop down menu and then select a new geographic unit. SimpyMap will present your new data immediately.
Creating and Applying a Filter
To create and apply a filter to only show cities with a population > 100,000:
Select “Data filters” then “Create new filter” from the top right of your screen.
At the filter creation screen, we used a recent variable # Population. We then set the condition to be greater than and typed in the value of 100,000. Lastly, we created a name and saved the filter.
Final Results Presented
Using the Display Options menu located near the top right of SimplyMap, we chose to hide results that did not meet our criteria of a city population greater than 100,000. The final results are below:
At a yearly average of $737.86, Highlands Ranch, CO ranks #1 in the United States in yearly average household spending on pets.
Stay tuned for more reports and SimplyMap tips & tricks!
More from SimplyAnalytics
Posted on Feb 24, 2019 by Admin
We will be exhibiting at SCELC* Vendor Day on March 14th. Visit us at table 510 and attend one of our two sessions demonstrating SimplyAnalytics. The presentations will highlight newly av...
Posted on Jan 18, 2008 by Admin
The BRASS Business Reference Sources Committee of Reference & User Services Quarterly (RUSA) selected SimplyMap as one of the Outstanding Business Reference Sources for 2007. Excerpt...
Posted on Sep 07, 2011 by Admin
Geographic Research will be exhibiting and presenting during a vendor showcase session at the upcoming North Carolina Library Association (NCLA) Biennial Conference, October 4-7, 2011 in ...
Posted on Mar 02, 2018 by Admin
In this week’s blog we’ll take a look at how to enter an address in SimplyAnalytics to find the Census Block Group or Census Tract. Let’s get started! Use Case: You want to analyze the ar...
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 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 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 Mar 03, 2016 by Admin
In this week’s SimplyMap report we take a look into the SimmonsLOCAL dataset to determine which cities in America have the highest percentage of residents who consume organic food product...
Posted on Apr 14, 2016 by Admin
This week’s SimplyMap report will provide an overview of one of the more advanced functionalities in SimplyMap - applying multiple filter conditions. Filters can be applied to any map or ...
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,...





