alteryx Community

# 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

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

## Challenge #141: Examination Data Simulation

11 - Bolide

Hi! Here my solution :)

Spoiler
6 - Meteoroid
Spoiler

Sadly our IT has not installed us the Predictive Tools at the moment but i wanted to see if i can do the same in Python. I have to say my solution is done without spending too much work so it could be done much better. Hopefully when we get the Tools i can compare both ways.

16 - Nebula
Spoiler
Definitely have never used this tool before!

11 - Bolide

Great way to learn new ways of using tools !

Spoiler

17 - Castor

Solution.

Sapna Gupta
15 - Aurora

28

Spoiler
8 - Asteroid
Spoiler

I really like the simulation sampling tool! Very useful tool
11 - Bolide

I missed the hints in the description so I could have handled this better, but still...

Spoiler
I used some R code to generate the data:
Spoiler

#set threshold for 1 person that can reasonably be expected to be >.9 or <.5
z <- qnorm(0.9995)

#generate normally distributed data where 99.9% of samples are between .5 and .9
Score <- rnorm(1000, mean=0.7, sd=(0.2/z))

#reset values below 0.5 to 0.5 and above 0.9 to 0.9
Score <- ifelse(Score < 0.5, 0.5, Score)
Score <- ifelse(Score > 0.9, 0.9, Score)

#ensure the dataset is 1 column with 1000 rows (from 1 vector to 1 dataframe)
Score <- data.frame(Score)

#write to Alteryx
write.Alteryx(Score, 1)

And I paired it with the existing table and visualised the end result:
Spoiler
This was the workflow:
Spoiler
Alteryx Alumni (Retired)

I was wondering what those simulation tools did...

13 - Pulsar

My solution:

Spoiler

The Simulation Sampling tool is going right in my back pocket. I'll be using this in the future. Thanks!