Monday, February 13, 2012

Tableau creation

This represents my first try with the Tableu software. In response to seeing a video concerning the Fair Pay Act - the first bill President Obama signed- I was curious to see how disparities from 2009 would mactch up with 2010-2011. Not much time really, but I was expecting to see more of a difference than I found looking at the chart. It's listed state by state and it's clear the difference is bigger in some areas than others, however it's just as apparent that the pay gap is often close to 10k or so a year.

I also thought this tied in nicely with the discussion from last week concerning the idea some have about the way the market works. If the idea is that "important jobs" are paid more and everybody has the potential to work up to those jobs then why would this disparity exist at all? For minorities and immigrant populations as well? (though I didn't include those in this graph).

The sources I used to get the informatoin to construct this particular graph can be found at the bottom of this post.

(I couldn't get the embed to work properly so if you want to check it out just follow the link)
http://public.tableausoftware.com/views/paygendergap/Sheet1?:embed=y


http://www.aauw.org/learn/research/statedata/upload/gendergap2009_data.pdf

http://www.pay-equity.org/

2 comments:

  1. Matt, nice that you tried out Tableau. Did the data allow for any significant controls--such as occupation?

    ReplyDelete
    Replies
    1. Unfortunately no. There were a few variables I would have been interested in seeing including occupation, education level, age, and dependents, to name a few. It did give a chance to test out tableau at least. I used some other variables such as povertry rates and graduation rates and applied those on the map and it was pretty interesting to see it visualized that way.

      Delete