Hi guys- So I'm trying to group respondent scores into 5 buckets. Let's say if I have 100 responses and each of them has scores assigned, I want to group them into five equal buckets (20 respondents in each bucket). Tricky part is- If I get 10 more responses, the total response count now becomes 110, and each bucket should have 22 respondents. It is mandatory that the data is split equally across the 5 buckets (each bucket has 20% of datapoints). Is there a way for Qualtrics to automatically store 20% of data in each of the 5 buckets sorted by the scores? Any help would be great, thanks!

There is no direct formula for percentile calculation, you can use available operators to define your own formula. See below link for available operators in Qualtricshttps://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/

Hi @Vivek ,So what would happen when you have 106, 107 responses which cant be divided equally??

How to group respondents into 5 equal buckets based on score?

How to group respondents into 5 equal buckets based on score? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded