How to set up a percentile calculation?

Make sure your questionnaire is completed then head straight to the Extra Options tab and set up your custom score. 

Custom scoring

custom scoring example

Select Formulas in the Custom Scoring section, Click Create formula and add your formulas. For the percentile calculation, you'll need the following formulas and variables:

1 Calculate your scores per section

Build your formula by using the circled symbols to put your formula together. Or click Variables to access the drop-down menu of questionnaire variables that you can use in your formula.

Add up the custom score values for each question to be able to rank your respondent's score.

formula custom scoreformula custom score

custom score formula

2 Specify the rank order

Select a Formula to rank in order - this variable ranks the responses from the highest to the lowest.

rank order formula

rank order formula example

3 Specify the total number of responses

The response count of the questionnaire gives you the number of respondents who took your questionnaire. This formula collects the total number of respondents.

response count formula

response count formula example

4 Calculate the percentile

The rank order divided by the response count, multiplied by 100, will give you the percentage score. If you don't multiply it by 100, your results will show a number, e.g. you score better than 3/10 respondents.

percentile formula

5 Final Screen

Set up your final screen and don't forget to add your final formula! You can use the same variables in your PDF report.

formula to calculate percintile

final screen example

Read the full guide about Formulas.

That's all! Now log in and try out the formulas feature for yourself!

Vincent is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.