• About
    • About the FIA
    • Priorities
    • Our Team
    • Brainstorming Board
    • Partners and Affiliates
    • Contact Us
  • News + Events
    • News
    • Events
    • Videos
    • Newsletters
    • @FIAumd
    • In the Media
  • Spark Grants
    • Spark Grants Overview
    • Spark Grants FAQ
    • 2012-2015 Seed Grants
    • 2012-2015 Seed Grant Winners
  • Special Topics
    • SearchReSearch
    • Curated Topics
FIA

SearchReSearch

SearchResearch Bonus Challenge (July 20, 2022): What’s a large US city with very low population density?

Dan Russell • July 20, 2022
 SearchReSearch
Republished with permission from SearchReSearch
SearchResearch Bonus Challenge (July 20, 2022): What’s a large US city with very low population density? Dan Russell

As I mentioned last week, I'm in a place with very slow WiFi...


... so it's tricky to write up a detailed answer for you from last week.

BUT a question came up in conversation about "what large US city has the lowest population density as of 2020?"

There are tables one can find that will tell you one answer, but I'd like you to solve this Challenge in a more direct way--a way that will teach you how to download data directly into a table and then manipulate it yourself.

Can you do this hands-on data manipulation Challenge?

Here's what I want you to do:

1. Search for a table of the largest US cities by population. You'll want to find a table with at least 330 entires in it.

2. Download that table into a spreadsheet.

3. Compute the population density (if you need to... it might be a column in the data set).

4. Sort the table by density, and then tell us what the city name is!

Your table should look like the one above (hint: I got it from Wikipedia, but you can find your own source if you'd like--the diversity of data sources might be interesting).

This might feel like a bit of an odd Challenge, but it's a bit of a sensemaking exercise--can you get yourself through all the steps and get to the correct answer?

Everything you need to know is pretty easily discoverable, and knowing how to do this will put you in good standing as a beginning data analyst--you'll know how to find data, import it, transform it (as needed), and then validate it.

Can you do it?

Let us know in the comments below!

Search on!


P.S. My view at the moment. Will wait to upload this post until I get close to good wifi....



Share

Comments

This post was republished. Comments can be viewed and shared via the original site.
12 comments

About the Author

Dan RussellDan Russell

I study the way people search and research. I guess that makes me an anthropologist of search. While I work at Google, my blog and G+ posts reflects my own thoughts and not those of my employer. I am FIA's Future-ist in Residence. More »

Recent News

  • Deepfakes and the Future of Facts
    Deepfakes and the Future of FactsSeptember 27, 2019
  • Book cover for Joy of Search by Daniel M. Russell
    The Joy of Search: A Google Insider’s Guide to Going Beyond the BasicsSeptember 26, 2019
  • The Future of Facts in a ‘Post-Truth’ World
    The Future of Facts in a ‘Post-Truth’ WorldMay 15, 2018
  • The Future of Virtual and Augmented Reality and Immersive Storytelling
    The Future of Virtual and Augmented Reality and Immersive StorytellingJune 6, 2017

More »

Upcoming Events

There are no upcoming events scheduled. Please check back later.
Event Archive »
Video Archive »

Join Email List

SearchReSearch

  • SearchResearch Challenge (3/22/23):  What do you call the sediment that blocks a river from flowing to the sea?
    SearchResearch Challenge (3/22/23): What do you call the sediment that blocks a river from flowing to the sea?March 22, 2023
  • Answer: What do these everyday symbols mean?
    Answer: What do these everyday symbols mean?March 15, 2023
  • SearchResearch Challenge (3/8/23): What do these everyday symbols mean?
    SearchResearch Challenge (3/8/23): What do these everyday symbols mean?March 8, 2023
  • PSA:  Read Clive Thompson’s article about how he does research
    PSA: Read Clive Thompson’s article about how he does researchMarch 3, 2023

More »

University of Maryland logo
Robert W. Deutsch Foundation logo
Google logo
Barrie School
Library of Congress logo
State of Maryland logo
National Archives logo
National Geographic Society logo
National Park Service logo
Newseum logo
Sesame Workshop logo
Smithsonian logo
WAMU
© 2023 The Future of Information Alliance, University of Maryland | Privacy Policy | Web Accessibility