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 #18: Predicting Baseball Wins

RWvanLeeuwen
10 - Fireball

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
echuong
8 - Asteroid

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

 

 

 

 

 

 

joemkcarr
8 - Asteroid

Good to learn a bit of predictive 

EricWe
Alteryx
Alteryx
 
Hannah_Lissaman
11 - Bolide

My solution 🙂 

myastarling
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.

phottovy
12 - Quasar

Fun challenge!

 

Spoiler
challenge_18_solution.png
KMiller
8 - Asteroid

Solution attached

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

Great Challenge for learning the predictive tools!

Spoiler
Solution-Challenge 018.PNG
mpennington
11 - Bolide

Solution attached.  

 

Spoiler
Challenge 18 MP.png