Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #44: Inspire Europe '16 Grand Prix (L3)

8 - Asteroid
 
Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner

My detailed answers seem to be the same, but slight differences on the regression.  Does the oversampling perhaps give different results each time it is run?

 

 

Spoiler
Process:
- Select unique records (unique reference numbers)
- Calculate average of Number of Vehicles
(Result: 1.817008)

- Calculate sum of accidents for each time bucket (group by time bucket)
(Result: Evening: 4,663)

- Filter on Casualty Class = "Pedestrian"
- Count Distinct Reference Number
(Result: 2,562)

- Create field WasFatal as boolean
- Oversample tool on field WasFatal = Yes at 50% level
- Logistic Regression tool on all the fields noted
(- Casualty Class with lowest P Value: Pedestrian: 0.00011
- Coefficient estimate: 1.86759
- Gender: Male)

MySolution.PNG

 

 

Highlighted
8 - Asteroid

Lap 3 Effort

 

Spoiler
JamesCameron_0-1575026839590.png

Schoolboy error - forgot to change # of Vehicles to Int before the regression  

Highlighted
Alteryx Partner

44 completed

Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid
Spoiler
Challenge 44 2019-12-13.jpg
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Finished the Grand Prix!

Highlighted
12 - Quasar
12 - Quasar

my solution