Weekly Challenge

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

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

Submit Feedback
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.

Challenge #18: Predicting Baseball Wins

Highlighted
Alteryx Certified Partner

This is my proposed solution: I performed association analysis using Pearson's correlations. Next, I manually selected those fields and modelled the complete dataset using only those predictors  - and I explicitly disregarded any multicollinearity, assumptions checking etc. Subsequently I used that model to score the teams of interest and added two more fields: [Projected Losses] = Round(162 - [Projected Wins], 0)

[Games Back] = Round([Max_Projected Wins] - [Projected Wins], 0)

 

This shouldn't be the best way to perform this type of analysis as I'd prefer working with stepwise elimination and VIF and checks for multivariate normality... However, my results match with the solution... I'd suppose I should get a badge for this

 

Spoiler
18 - RWvL.png
Highlighted
8 - Asteroid

Good practice with predictive tools! Also included a win difference percent to see how the model did

 

 

 

 

 

 

Highlighted
Alteryx Partner

Good to learn a bit of predictive 

Highlighted
Alteryx
Alteryx
 
Highlighted
Alteryx Certified Partner

My solution 🙂 

Highlighted
9 - Comet

Fun fun fun! Full disclosure, I've never used the Association Analysis tool before so I did have to take a peek at a solution for this part.

Highlighted
8 - Asteroid

Fun challenge!

 

Spoiler
challenge_18_solution.png
8 - Asteroid

Solution attached

Spoiler
03-07-2019 09-37-13.png
Highlighted
8 - Asteroid

Great Challenge for learning the predictive tools!

Spoiler
Solution-Challenge 018.PNG
Highlighted
8 - Asteroid

Solution attached.  

 

Spoiler
Challenge 18 MP.png