3 ms·
US metropolitan areas by median population density
- oidar 5y agoLove the octile idea. How hard would this be to expand to the top 100 metro areas? I would like to see comparisons to Texas and Florida metros specifically.
- scythe 5y agoNot hard at all -- any metro can be added to the analysis by altering the file cbsas_of_interest.txt with the CBSA code and a preferred city name. The CBSA codes are easy to find by searching in msas_fips_counties.csv: Orlando is 36740, Jacksonville is 27260, Austin is 12420, San Antonio is 41700. Note that the first line after each city is the total population (a sanity check); the octiles follow.
- oidar 5y agoGot it. Which tool did you use to visualize this?
- scythe 5y agoI considered various fit-for-purpose tools before I gave up and used Excel. Once I had the results I just wanted a graph as soon as I could. https://support.microsoft.com/en-us/office/create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d https://support.microsoft.com/en-us/office/create-a-box-and-...