VIDEO TUTORIAL: How to calculate Percentile Rank (for A/B testing)

jaeW_at_Onyx · 2021-02-11T21:23:57+00:00

There was an error rendering this rich post.

Percent ranking answers what "% of values were less than Y." Kudos to @GrantSmith for the question.

This is useful for comparing test results in two populations. Imagine 67 respondents tested 75% or les whereas in group B 99 respondents scored 75% or less.

To calculate % rank, you calculate the rank and divide each rank by the count of values.

Here's the video tutorial on 3 different ways to calculate the result (using MagicETL, Analyzer and Dataset Views)

https://www.youtube.com/watch?v=Esnu1PSxRjM&t=35s

Find more posts tagged with

Comments

kensie_rowell

This was so helpful Jae! Thank you!!

verytiredgirl

@jaeW_at_Onyx

Thank you for the video. I have a question on using View. When I did the group by User and Exam to get the Sum of Score, the original column `Score` would not be in the dataset after the Group By. Then how did you use SUM(`Score' ) in the BeastMode to calculate the percentile rank?

Thank you