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 Apr 27, 2015 by Admin
In this week’s write up we want to share some quick tips and tricks that you might not yet know about in SimplyMap. TIP #1 Did you know that you can share your work? SimplyMap allows you ...
Posted on Dec 08, 2017 by Admin
Good afternoon, readers! This week we’re going to talk about project management in SimplyAnalytics and how to best take advantage of it. Why are projects needed? Many users have multiple...
Posted on Feb 02, 2024 by Admin
We are excited to be back exhibiting at PLA this April in Columbus, OH. Join us at Booth #2631 to discover how SimplyAnalytics can help libraries understand their service area, assist sma...
Posted on May 02, 2016 by Admin
Inspired by a recent support desk question, this week’s SimplyMap report will demonstrate how a user would run a business search that consists of multiple names. In short, the user was at...
Posted on Feb 21, 2018 by Admin
We are looking forward to attending our first Electronic Resources & Libraries (ER&L) conference in Austin, TX! Visit us at Table #510 for a closer look at SimplyAnalytics – the b...
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 Jun 07, 2011 by Admin
We will be exhibiting at the Special Library Association Annual Conference in Philadelphia and the American Library Association conference in New Orleans later this month. Come and visit ...
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 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 Feb 26, 2014 by Admin
The Statewide California Electronic Library Consortium is holding another packed week of workshops and networking during the SCELCapalooza event in March 2014. Geographic Research will b...





