3 Replies Latest reply: May 31, 2012 4:34 AM by Michel Kruiskamp

# How to calculate percentile?

Hi all,

I have a dimension 'total marks'. it has got total marks scored by a student out of 300.

I want to display the same in percentile.

Can someone suggest me on how I can achieve the same?

Thanks.

• ###### How to calculate percentile?

Try checking the option "Show in Percent" on the numbers tab.

• ###### How to calculate percentile?

Hi,

Let try below picture:

It is better to understand what you want if you can provide sample data and result you looking for.

Regards,

Sokkorn

• ###### Re: How to calculate percentile?

The definition as used in education:

A percentile ranking represents how well a student performs compared to other students in a nationwide norm sample for their grade. A student scoring at the 35th percentile scored as well as, or better than, 35 percent of students in the same grade in the norm group. It also means that 65 percent of the students exceeded this score.

A common mistake is for people to think this means that the student got 35 percent of the items correct. Percentile is not related to the percent of correct answers a student gets on a test.

The percentile is not a good method for measuring growth in students. Students who achieve typical growth will remain at approximately the same percentile score over time.

Please have a look at the fractile function, as mentioned in http://community.qlik.com/message/15054#15054.