Challenge #107: Plot Employment Rates by Gender in the US

In honor of the new roll-out of the Women of Analytics group, we decided to theme this week's challenge!

This women's history month, let's analyze employment rates of men and women in the United states with data from the Bureau of Labor statistics. One of the challenges will be navigating the difficult excel file structure of merged headers, and the other will be reporting on the overall percent of men and women in the workforce. Try to replicate the chart pictured in the output.

For more advanced users, try to calculate the slope of the employment rate and around what year the slopes are set to intersect assuming linear growth. Plot the trend lines on the report chart as well!

challenge_107_start_file.yxzp

Reporting

Preparation

Advanced

Data Analysis

Reporting and Visualization

Difficult

Accepted answers

All comments

jamielaird

Spoiler

Here's my solution. Nice to play around with the charting tool, as I use it so infrequently. Had to resort to a slight hack to hide the horizontal axis labels.

challenge_107_JL.yxzp

LordNeilLord

Wow @jamielaird that's got to be one of the quickest submissions ever!

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

David-Carnes

OK, six tools total. I got a weird error trying to figure out the trends and don't have time to work on it.

challenge 107 output.png

Spoiler

David-Carnes_107.yxmd

patrick_digan

Spoiler

challenge_107_start_file.yxmd

bdaniels

Intermittent Charting tool Error but aside from that, good first experience with the tool

Spoiler

Screen Shot 2018-03-12 at 12.21.55 PM.png

challenge_107_BD.yxzp

DanielArenas

was stuck with plot but i finally made it.... kinda

Spoiler

challenge_107_start_file.yxmd

mmontgomery

Spoiler

challenge_107_start_file.yxmd

MJG

challenge_107_solution_MJG.yxmd

ggruccio

This workflow creates the chart from the challenge - along with one that has the slope and a prediction for the year when the slopes cross....

challenge_107_gg_finish.yxzp

kat

Spoiler

Challenge #107.yxzp

sunny430

challenge_107_start_file.yxzp

courtneyg

Spoiler

challenge_107_guc.yxzp

tochy

challenge_107_start_file_Tochy.yxwz

Michal

Not sure which font is used by should be done, this one was quite quick

challenge_107_Michal.yxmd

CHarrison

Spoiler

2018_03_13_23_05_17_Alteryx_Designer_x64_Challenge_107.png

Probably could've cleaned up the data in less tools, but got there in the end :')

Challenge 107.yxzp

dominiklz

Spoiler

challenge_107_Dominik.yxmd

JordyMicheal

Very fun problem

challenge_107_start_file_solution.yxmd

tochy

challenge_107_start_file_Tochy.yxmd

Vijuzy

Here it is..

Spoiler

Challenge_107_Vijay_M.yxzp

Krit_Gable

It was fun

challenge_107_kp.yxzp

philipmannering

The good news is that I got the R tool to work for the first time. The bad new is that we have to wait until the year 2120 to close the gender employment gap if the trend continues.