3 ms·
Love 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.
by oidar 5y ago
Love 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-...