# 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)

Highlighted
8 - Asteroid

Lap 3 Effort

Spoiler

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

Highlighted
8 - Asteroid

Finished the Grand Prix!

Highlighted
12 - Quasar

my solution