Visualizing the 500 biggest corporations in the US

6

Every year, Fortune magazine compiles a list of the 500 largest US corporations - called the Fortune 500. Their list was a bit difficult to digest in text-form, so I thought I'd try using some maps & graphs on the data ...

For a map analysis, I thought it would be interesting to see how many companies were located in each state. The only tricky part here is that I didn't like any of the built-in legend binning algorithms for this particular data, so I created my bins, and then used a user defined format to have the legend show the values that corresponded to my custom bins. You can click the snapshot below to see the full size interactive map, with html hover-text showing all the company names in each state (note that some browsers might have a shorter length limit on the number of names they can show in the hover-text ... I find Google Chrome works well).

fortune500_2015

The map was interesting, but kind of predictable - the states with larger populations probably have more corporations, and therefore more corporations in the Fortune 500 list. Therefore I put on my thinking cap to see if I could come up with a way to visualize the data so that I could see if there were any states with a high (or low) number of Fortune 500 companies, for their population.

I decided to use a scatter plot, showing the number of Fortune 500 companies, versus the population, for each state. I used the same color binning that I had used in the map, to tie the two visualizations together (... for better, or for worse). And I added pointlabels to show the state abbreviation for each marker. Based on the scatter plot, it appears that although California has a large number of Fortune 500 companies, its value is a bit low for its population. You can click the snapshot below, to see the company names for each state, similar to the map.

fortune500_20151

And, of course, I also added a table of the data, with links to more information about each company. Here's a snapshot of a portion of the table - click the link to see the whole table.

fortune_500_table

 

What do you think of the Fortune 500 rankings, and what other graphical analyses of the data do you think would be useful?

Share

About Author

Robert Allison

The Graph Guy!

Robert has worked at SAS for over 20 years, and is perhaps the foremost expert in creating custom graphs using SAS/GRAPH. His educational background is in Computer Science, and he holds a BS, MS, and PhD from NC State University. He is the author of several conference papers, has won a few graphic competitions, and has written a book (SAS/GRAPH: Beyond the Basics).

6 Comments

  1. Leonid Batkhan
    Leonid Batkhan on

    Interesting presentation. What is the ranking criteria for the companies? If it is their capitalization it would be nice to have that value presented as well to see how these companies differ between each other, not just by their numbers by state.

  2. Bharat Thakkar on

    Hi Robert,
    A quick question if the data you presented was already stored in SAS dataset. What modification to you Java Code would need to make? Also, I'm running off network based Windows 7 and would connect to SAS server SAS datasets. Thank you ahead time for all of help.
    Bharat Thakkar

  3. Hi Robert,

    It really wonderful thought, Please let me know how did you load US map, Did you use Latitude and Longitude. I am trying to load New Jersey state map, But I am having hard time to get Latitude and Longitude for each city.

    Please advise.

Leave A Reply

Back to Top