Finds data's specific percentile value.

Input

Output

21 Related tools

Table Statistic?

Any Questions?

Finds data's specific percentile value. A percentile is a measure that indicates the value below which a given percentage of observations in a group fall. Read more about percentile on Wikipedia https://en.wikipedia.org/wiki/Percentile

The 90th percentile of the set [10, 20, 30, 40, 50, 60, 70, 80, 90, 100] is 90, because it is the value below which 90% of the observations fall.

Sales managers or marketing professionals might need to understand where a particular metric, like sales figures or website hits, stands relative to all data. By understanding percentiles, they can make better-informed decisions and strategies.

  • Microsoft Excel:
  • Google Sheets:
  • Apple Numbers:
  • Python Pandas: df['column'].quantile(0.95)
  • Related Words: ranking analysis, percentile calculation, data position

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.