In this blog post, we will see about most fundamental stuff in Performance Testing, how to calculate percentile value? First, let us see about percentile value.

**What is Percentile Value?**

Percentile value is a measure of statistical distribution of the data. The median is the middle value. The median is the value for which 50 per cent of the values were bigger, and 50 per cent smaller. But 90^{th} percentile gives you the value for which 90 per cent of the data points are smaller and 10% are bigger.

90 percentile is considered as a thumb rule in performance testing for result analysis and benchmarking. Most of the performance testing rule sets the 90 percentile value.

**How to calculate 90 percentile value?**

Easiest way to calculate 90 percentile is as below. Consider you have following ten data, 15, 63, 78, 12, 56, 74, 52, 79, 90, and 46.

Arrange above numbers in ascending order, i.e. 12, 15, 46, 52, 56, 63, 74, 78, 79 and 90. Ninth value i.e. 79 is the 90 percentile value. If you use Microsoft Excel, use **=PERCENTILE(array,k)** where k is the percentile value you want to calculate, for 90 percentile, k value will be 0.9. Similarly you can calculate for other values 10^{th} percentile, 50^{th} percentile, or any values.

For the above mentioned series, 90 percentile value is 80.1 in Microsoft Excel. Below is the sample Percentile Calculator to find the Percentile Rank (PR) of students.

Happy Testing!

Subscribe to our QAInsights YouTube Channel. If you are enjoying our work, please do subscribe our free weekly newsletter or Google feeds.

Image Courtesy: Fotofolia via Microsoft Clipart

- What’s new in HPE LoadRunner 12.53? - May 15, 2016
- How to send Google mail in Apache JMeter? - March 26, 2016
- 5 Tips for Continuous Delivery of Quality Apps in Agile Testing Cycles - March 3, 2016
- 12 Great Web Service Testing Tools - February 18, 2016
- Deep dive into HPE LoadRunner Controller - February 18, 2016
- How to use Load Generator Calculator? - February 8, 2016
- HP QTP License and End of Sale Announcement - February 7, 2016
- Importance of Correlation in Performance Testing - February 2, 2016
- Learn about IP Spoofing supported Vusers Types - January 31, 2016
- Solve Server has a weak ephemeral Diffie-Hellman public key in LoadRunner - January 24, 2016

## One thought on “How to calculate Percentile value?”