Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #157: An Expert Challenge

T_Willins
14 - Magnetar
14 - Magnetar

 

 

Wow.  So not ready for the Expert Exam...yet.  I would have spent my entire exam time researching the tools for this.  The difficult part is knowing which predictive tools to use.  Went down a rabbit hole to combine results and calculate Chi-Squared until I revisited the tool documentation for predictive tools and found the Nested Test tool.  I wish I had Alteryx with these tools in college (soooo long ago).

 

Spoiler

Chi Squared.GIFVariable Importance Plot.GIFWorkflow 157.GIF

 

 

 

 

32bit
8 - Asteroid

Pardon me if I'm confused, but what does a question like this have to do with a designer certification? Find the answer to that, and you'll know why most people avoided it.

estherb47
15 - Aurora
15 - Aurora

Cool challenge! I have no idea if my solution is anywhere near correct, but enjoyed getting there nonetheless!

Spoiler
The first approach would normally be to use a Field Summary tool to explore the data. But, since we already know what we want to target, a Summarize tool on H0 is much faster. With just 2 answers, this is probably binary, so I'll model with a Logistic Regression.

Determining the Mean Decrease Gini Coefficient means a Forest model (see the same article that many of us found here)
Variables outlined in the red box below
image.png

2 Logistic regressions, one with F_38 and one without. And a Nested Test to compare the two models. Chi-squared is in the nested test
image.png


kelly_gilbert
13 - Pulsar

Whew, had to spend some quality time with the tool documentation on this one. Statistically, this was out of my depth, however, I was totally surprised to find that I was actually close to the right path. 

 

Spoiler
I had no idea how (or why) to use the model outputs in a chisq test. TIL about the Nested Test Tool!

challenge_157_workflow.PNG

 

Ladarthure
14 - Magnetar
14 - Magnetar

Nice challenge, way too hard without the community's help :)

Garrett
11 - Bolide

Glad this one's been retired. 

ggruccio
ACE Emeritus
ACE Emeritus

Facing my old nemesis from the expert exam!  I am one of the people who attempted this one.  LOL @CristonS  you won't believe what I did...

 

Spoiler
So...I knew immediately how to get to the variables with the highest Mean Decrease Gini by using a Random Forest Model.  However when it said compare two models and provide the difference in Chi-Sq I assumed this was also using Random Forest Model for just the 10 variables then removing F38.  Saw no obvious Chi-Sq difference in the output so I googled and believe I found a way to calculate it manually from the confusion matrix.  I would have never figured out that I had to use Logistic Regression and had to peek at the solution to understand it....

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

Community resources to the rescue!!!

 

 

Spoiler
Part of me is extremely pleased when the solution to a question has so few tools... the other part of me, which does not entirely understand what I did to get to this answer, is mildly terrified of the fact that this answer required so few tools. :)

WeeklyChallenge157.JPGWeeklyChallenge157ChiSq.JPG

Clearly, I now know what I should be doing for the next two months until the Expert exam at Inspire Nashville...

 

 

studying2.gif

 

Cheers!

NJ

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

PhilipMannering
16 - Nebula
16 - Nebula

Thanks to @patrick_digan for showing me where this variable importance plot was hiding.

 

My solution attached

Spoiler
workflowworkflow