For my final project, I plan on using the 1930/1931 Time Diary of College Educated Women. The data set is standardized so there is not much cleaning needed. I am not sure where the data could be extended, besides adding historical context, because it is very comprehensive. For my visualizations, I plan on using an interactive map to highlight the average number of hours worked (one for employment and one for household work) for each state to see if there are any major differences. I am also planning on doing a graph to compare urban vs. rural women’s hours worked (both professionally and on household tasks). Other options for visualizations include a pie chart showing the distribution of occupations. I am still brainstorming a way to compare the age of the women vs. the hours they worked weekly. I am currently working on research about the era and learning more about the data set’s collection.
Apologies for the late post!
2 replies on “Module 9: Work”
For the age vs hours worked, I think you’ll want something like a scatterplot with both Age and Hours converted to a dimension (rather than a measure, which they will default to in Tableau). I did a quick and dirty version here, where you can also download the Tableau workbook if you want to see how I set it up. After you drag over age and hours, I’d use something like Individual ID on the details card of the marks pane to split out all the individuals. You may also want to filter out hours worked of 0, since I at least found it harder to see any correlation of age to hours with that included. Hours worked seems to be only paid employment outside the household, so that may affect your write up and analysis.
(I’m glad you’re tackling this! It seems very interesting and I picked this for you because I thought you might be interested from what you said in your intro post)
Thank you!