Go up
American Household Spending on Pets
Posted on Dec 09, 2014 by Admin
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 May 17, 2016 by Admin
This week’s SimplyMap report is a quick reader challenge. Can you guess what the map of the United States below is depicting? Keep in mind the legend colors - lighter is less, and darker ...
Posted on Oct 27, 2017 by Admin
Welcome to our first ever SimplyAnalytics blog! Every Friday we’ll post a write up on a specific feature or highlight some interesting data in SimplyAnalytics. The goal of these posts is ...
Posted on Apr 01, 2014 by Admin
Another fantastic series of workshops and events are planned at the SLA Conference on June 8-10th, 2014. Register now for networking and workshops throughout the week. Over 200 events are...
Posted on Sep 18, 2015 by Admin
With tens of thousands of variables available in SimplyMap, it’s common for users to wonder whether or not a particular variable they have in mind is available in SimplyMap. This is where...
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,...
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 Dec 09, 2014 by Admin
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 Avera...
Posted on Dec 15, 2014 by Admin
Stop by the Geographic Research booth at the Ontario Library Association Super Conference to check out SimplyMap Canada. The conference will take place January 28-31 at the Metro Toronto ...
Posted on Nov 17, 2014 by Admin
Our recent series Exploring SimplyMap Data Reports has focused on creating ranking reports for unique variables. Accordingly, we thought it would be helpful to write a quick tip on how to...
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...