We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

mpennington
11 - Bolide

Attached.

 

Spoiler
MP 107.jpg
apathetichell
16 - Nebula

my solution...

Sashikumar
8 - Asteroid

My solution.

Spoiler
ch107.PNG
tammybrown_tds
8 - Asteroid
Spoiler
tammybrown_tds_0-1621027953186.png

 

tammybrown_tds_1-1621028271599.png

 

BeginnerMindset
8 - Asteroid

Fun challenge.  Answer: 2096 (assuming linear trend)

 

Looking for trends and finding the truth in the data is sort of my thing, so I got drawn in to this one. After doing the basic graph I took the following steps:

 

1) Convert the % into an index against the total % in full time employment - this removes any other economic trends/shocks (such as the 2008 financial crisis) which muddy the water

 

2) Plot these indexes to get a visual idea of the trends - clear steady rise in women in full time employment and corresponding decline in men as would expect.  However, there is a step change in both in 1994.  This suggests a change in the way the figures were recorded (as we have already removed any genuine economic shocks in step 1).  It is therefore necessary to allow for this step change or (more simply) only take the data from 1994 onward.  I took the latter option as that still leaves over 20 years of data, which is probably preferable to extrapolate from anyway, rather than the entire period.

 

3) Use the Linear Regression tool to create the equation of both lines, then solve algebraically. 

Spoiler
BeginnerMindset_0-1623927613793.png

 

 

 

cwkoops
8 - Asteroid

A bit of trouble with the formatting to exactly match.

GarryBrittain
6 - Meteoroid

Plotting the regression lines took a bit messing around but got there in the end.

 

Spoiler
challenge_107 image.png
IraWatt
8 - Asteroid

Nice to get to use the reporting tools didn't quite manage to get it 100%. 

IraWatt_0-1627660699217.png

 

Laurap1228
11 - Bolide

Here is my solution:

Spoiler
Laurap1228_0-1628542845321.png

 

JasonHu
8 - Asteroid

Here is my submission; it contains both actual value and trend line.

Spoiler
Output.pngworkflow.png