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 Sep 05, 2019 by Admin
SimplyAnalytics will be exhibiting at the biennial North Carolina Library Association conference, to be held this year at the Winston-Salem Benton Convention Center. If you are attending,...
Posted on Sep 15, 2016 by Admin
While creating a radius location is the fastest and easiest method for creating a custom location, there may be situations that require a more specific and targeted locale. Let’s say for ...
Posted on Feb 24, 2019 by Admin
Visit with the SimplyAnalytics team at this year's 14th annual Electronic Resources & Libraries Conference in Austin, TX! You can find us at Table 207, where we will be available to a...
Posted on Apr 30, 2024 by Admin
Congratulations to Brandyn Whitaker as the recipient of the 2024 BRASS Student Travel Award! Brandyn is a Library Services Associate in the Workforce and Economic Development department a...
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...
Posted on Oct 22, 2008 by Admin
Excerpt from University of Iowa Library blog: In your marketing class, you may be developing a marketing plan for a pre-made meals restaurant specializing in vegetarian menus in Chicagola...
Posted on Nov 03, 2017 by Admin
This week we’ll talk about one of our favorite features in SimplyAnalytics - the custom combination location. This feature is a simple and effective means to create custom geographies whe...
Posted on May 31, 2011 by Admin
Kenneth Johnson of the Science, Industry, and Business Library at the New York Public Library recently provided a "boot camp" on the library's market research resources to budding entrep...
Posted on Mar 21, 2018 by Admin
The Quick Report is one of the newest features added to SimplyAnalytics - let’s take a look at how it can support your research. This report instantly provides you with a curated list of ...
Posted on Jun 21, 2022 by Admin
Hello readers! We hope you’re having a great day. Today we are featuring 5 commonly asked questions about the American Community Survey dataset that’s available to all customers in Simply...





