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 Jun 08, 2023 by Admin
We are excited to announce Mansi Nishit Trivedi as the winner of the 2023 BRASS Student Travel Award sponsored by SimplyAnalytics! Mansi, a Master of Information student at Dalhousie, has...
Posted on Dec 11, 2015 by Admin
With the final week of the college football season in the books, and bowl game selections having just taken place, we wanted to search within SimplyMap to see if any data pertaining to co...
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 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 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 May 26, 2016 by Admin
In this week’s report exploring SimplyMap data, we take a look at the variables available relative to internet search engines used. The source of this data will come from the SimmonsLOCAL...
Posted on Jun 16, 2016 by Admin
This week’s SimplyMap report is a quick tip that we hope you find useful and time saving. Did you know that SimplyMap will save all recently searched business queries for future usage? Le...
Posted on Mar 18, 2015 by Admin
Can you guess which US city has the most residents per square mile? Today we’re going to use SimplyMap to answer this question for all cities, as well as cities with a population greater ...
Posted on May 26, 2020 by Admin
Hello readers! We hope you are doing well, and thank you for your continued support of SimplyAnalytics. We are excited to announce that scatterplots are officially live! Scatter plots ar...
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...