Monday, December 6, 2010


For my Social Stratification class I was recently working on my final research paper on the topic of disability. During my research I discovered quantitative information on the employment rate of disabled people, in 1994. The information included the amount of men and women working with no disabilities, mild disabilities and severe disabilities. I created a bar graph with this information. The other set of information is the median monthly incomes for each section of men and women, and it created my second bar graph. The multivariate graph took both those information and compared it. The monthly median income information is in a bar graph (or column graph on excel), and the percent of people working shadows the bar graph. The X axis labels the identity of the people.

After I entered the information into excel I created the two separate column graphs. My initial plan for displaying the information was in a double bar graph with each set of information (monthly income & percent working) its own bar color. After what felt like years of researching how to do that, I discovered an even better way of displaying the secondary information. The most difficult part of creating the graph on excel was my own stupidity. I was capable of compiling the information into one graph, but I needed to have two different Y axes because the numbers did not correspond (income and percent). The simple solution was selecting the secondary information (percent working) and formatting the data series onto a secondary axis. By creating the graph I was able to see how closely the information coincided. The amount of women working fluctuate the same as their monthly rate. One thing the graph clearly shows is men consistently make more money than women, regardless of disability.

No comments:

Post a Comment