Makeover Monday – Working hours of the female labour force

Posted by

This week’s Makeover Monday challenge was based on an article, pointing out that US American women work more hours than their European counterparts.

Sounded interesting, and as a fan of working efficiently to avoid overtime wherever possible, I decided to have a look at this data set to see if some women really seem to work ‘more’ than others (or just longer hours).

Sidenote: I’d love to get into a bigger dataset about this which includes work force efficiency, because hours worked to me is not a good indicator of being productive, efficient and ‘working hard’, but for now ‘work hours’ are all I had to play with.

The original article focused on US women compared to European women. My first issue with the analysis is the term ‘European women’. Well, Europe is pretty big and includes a lot more than Germany and France. While US women have a higher percentage of those working 40+ hours per week compared to GER and FRA, Eastern Europe has the highest percentage of those working long hours.

Subsequently I wanted to look at the data globally and focus on the countries that have the highest percentage of 40+ hour weeks.

image001

My second issue was that the article had huge potential but didn’t really dig into the data further and therefore would have not provided comprehensive information for the reader. I don’t claim that my analysis does that, but I wanted to at least visualise the whole dataset to put things into perspective.

Finally, I found that adding the OECD average as a trend line would help people’s understanding, rather than just having it as as a row (in my case) or column (in the original article) to give people a benchmark.

Without further ado, here is my dashboard on Tableau Public

 

https://public.tableau.com/profile/eva.murray#!/vizhome/Womenworkinghours_0/WhatsgoingoninEasternEurope

 

 

2 comments

    1. I would love to do further analysis but at the moment there just isn’t enough time as we’re preparing for our big move.
      Hopefully once I finish up at work the busy-ness will die down a little.
      I will definitely check out the OECD pages once I’ve got spare time so thanks for the link 🙂

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s